多租户-完全恢复

多租户-完全恢复

1 ROOT恢复

1.1 ROOT备份

rman target sys/oracle@cdb3
backup database root;

1.2 模拟故障

删除CDB的所有数据文件

cd /u01/app/oracle/oradata/CDB3
rm *.dbf

shutdown abort
startup

1.3 故障恢复

rman target sys/oracle@cdb3
restore database root;
recover database root;
alter database open;

 

2 PDB恢复

2.1 PDB备份

rman target sys/oracle@pdb2
backup database;

2.2 模拟故障

删除所有的Pdb2数据文件

cd /u01/app/oracle/oradata/CDB3/pdb2
rm *.dbf

shutdown abort
startup

2.3 故障恢复

rman target sys/oracle@pdb2
restore pluggable database pdb2;
recover pluggable database pdb2;
alter database open;