{2 マルチテナント}PDBのリカバリ

 

https://docs.oracle.com/cd/F19136_01/multi/backing-up-and-recovering-cdbs-and-pdbs.html#GUID-86822B10-B187-4E41-9A8F-93BFFBD143E9
https://docs.oracle.com/cd/F19136_01/bradv/rman-complete-database-recovery.html#GUID-8D0D3B72-C618-4AD2-902A-6A4064C14C44
https://docs.oracle.com/cd/F19136_01/bradv/rman-performing-flashback-dbpitr.html#GUID-26CD7EC8-12AC-4073-BB8D-A68502112E48

 

system表データファイル損失
ユーザ表データファイル損失
undoファイルの損失
全部損失
不完全リカバリ

 

export NLS_LANG=American_America.AL32UTF8
export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'

rman target /

delete noprompt backup;
BACKUP DATABASE plus archivelog delete input ;

LIST RESTORE POINT ALL;

DROP RESTORE POINT rp1;
CREATE RESTORE POINT rp1;
LIST RESTORE POINT ALL;

report schema;

 

     system表データファイル損失
cd /oradata/orcl/pdb11
mv system01.dbf system01.dbf.1
ls -l

alter pluggable database pdb11 close;
restore tablespace pdb11:system;
recover tablespace pdb11:system;
alter pluggable database pdb11 open;

 

     ユーザ表データファイル損失
cd /oradata/orcl/pdb11
mv users01.dbf users01.dbf.1
ls -l

alter pluggable database pdb11 close;
restore tablespace pdb11:users;
recover tablespace pdb11:users;
alter pluggable database pdb11 open;

     undoファイルの損失
cd /oradata/orcl/pdb11
mv system01_i1_undo.dbf system01_i1_undo.dbf.1
ls -l

alter pluggable database pdb11 close;
restore tablespace pdb11:undo_1;
recover tablespace pdb11:undo_1;
alter pluggable database pdb11 open;

 

     全部損失
cd /oradata/orcl
mv pdb11 pdb11.1
ls -l

alter pluggable database pdb11 close;
restore pluggable database pdb11;
recover pluggable database pdb11;
alter pluggable database pdb11 open;

 

     不完全リカバリ

alter pluggable database pdb11 close;
restore pluggable database pdb11 until scn 12464509;
recover pluggable database pdb11 until scn 12464509;
alter pluggable database pdb11 open resetlogs;