pdb做不完全恢复
1.数据库全备份
run
{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
backup as compressed backupset full filesperset 10 database format '/u01/rmanbak/fullbk_%d_%s_%u_%T.bak';
sql 'alter system archive log current';
backup as compressed backupset archivelog all format '/u01/rmanbak/daily_arch_%d_%s_%u_%T.bak' delete input;
backup current controlfile format '/u01/rmanbak/daily_ctl_%d_%s_%u_%T.bak';
backup spfile format '/u01/rmanbak/daily_spfile_%d_%s_%u_%T.bak';
release channel ch1;
release channel ch2;
release channel ch3;
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt obsolete;
}
或者是单个pdb备份
run
{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
backup as compressed backupset full filesperset 10 pluggable database pdb format '/u01/rmanbak/pdbbak/pdb_fullbk_%d_%s_%u_%T.bak';
sql 'alter system archive log current';
backup as compressed backupset archivelog all format '/u01/rmanbak/pdbbak/daily_arch_%d_%s_%u_%T.bak' delete input;
backup current controlfile format '/u01/rmanbak/pdbbak/daily_ctl_%d_%s_%u_%T.bak';
backup spfile format '/u01/rmanbak/pdbbak/daily_spfile_%d_%s_%u_%T.bak';
release channel ch1;
release channel ch2;
release channel ch3;
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt obsolete;
}
2.执行不完全恢复
关闭pdb
alter pluggable database pdb close immediate;
删除该pdb的数据文件
[oracle@19c pdbbak]$ cd /u01/app/oracle/oradata/ora19c/pdb
[oracle@19c pdb]$ rm *.dbf
创建辅佐目录
mkdir -p /u01/recover
执行不完全恢复
基于scn(可行)
run{
set until scn 1498061;
restore pluggable database pdb;
recover pluggable database pdb auxiliary destination '/u01/recover';
}
基于时间点(可行)
RMAN>
run{
set until time "TO_DATE('2023-04-12 22:11:00','YYYY-MM-DD HH24:MI:SS')";
restore pluggable database pdb;
recover pluggable database pdb auxiliary destination '/u01/recover';
}
基于sequence(执行报错)
RMAN>
run{
set until sequence 24 thread 1;
restore pluggable database pdb;
recover pluggable database pdb auxiliary destination '/u01/recover';
}
报错信息如下:
Starting recover at 12-APR-23
Segmentation fault (core dumped)
相关文章
- 使用了enabled_PDBs_on_standby参数后,主库新增pdb后从库的操作
- pdb备份和恢复
- 使用CREATE_FILE_DEST创建pdb遇到的文件路径问题
- 主库上克隆一个可读写的pdb,从库恢复过程
- oracle 12c pdb日常维护
- pdb表空间传输(nodone)
- 18cRAC dataguard主库克隆pdb从库报错误
- 创建触发器启动pdb
- pdb文件部分解释
- Oracle PDB的相关使用说明
- PDB自动启动以及Oracle Pfile的参数修改示范
- oracle 12c创建可插拔数据库(PDB)与用户详解
- 关于Oracle 12C pdb用户无法登录的问题
- oracle 12c创建可插拔数据库(PDB)及用户
- VS报错已加载“C:WindowsSystem32WinTypes.dll”。无法查找或打开 PDB 文件 & qt project settings无法点击
- 利用pdb获取未导出符号
- WinDbg配置pdb路径
- 在 Visual Studio 调试器中指定符号 (.pdb) 和源文件
- 修复 VisualStudio 构建时没有将 NuGet 的 PDB 符号文件拷贝到输出文件夹
- 探索Oracle之数据库升级七 11gR2 to 12c 升级完成后插入PDB