Oracle 12c PDB基于时间点的不完全恢复记录

Oracle 12c Point-In-Time Recovery of PDBS

Oracle 12c中当对指定的PDB进行不完全恢复的时候,其它的PDBS是完全不受影响的,多租户特性的好处就在于此,并且在恢复完成后老的PDB备份仍然有效,我们也不用为这个PDB创建新的备份。在实验的时候我遇到了一个小问题,就是在进行recover操作时会启动辅助实例,辅助实例则会使用到fast recovery area,如果fast recovery area的空间不够了,recover时会报错。后来手动使用AUXILIARY DESTINATION子句来为辅助实例指定一个临时的位置,就没有问题了。


--删除数据文件或者建表之类的模拟操作步骤就省略了,登录CDB直接开始恢复...
ALTER PLUGGABLE DATABASE ORA12CPD CLOSE;
RMAN> run{
2> set until time "TO_DATE('2016-06-03 14:46:44','yyyy-mm-dd hh24:mi:ss')";
3> restore pluggable database ora12cpd;
4> recover pluggable database ora12cpd auxiliary destination '/tmp/oracle';
5> }


executing command: SET until clause


Starting restore at 03-JUN-16
using channel ORA_DISK_1


channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00017 to /u01/app/oradata/ora12c/ora12cpd/system01.dbf
channel ORA_DISK_1: restoring datafile 00018 to /u01/app/oradata/ora12c/ora12cpd/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00019 to /u01/app/oradata/ora12c/ora12cpd/sales01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORA12C/33ABAC8133770B4DE0530A562EA0BF77/backupset/2016_05_27/o1_mf_nnndf_TAG20160527T092513_cnh8hsyp_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORA12C/33ABAC8133770B4DE0530A562EA0BF77/backupset/2016_05_27/o1_mf_nnndf_TAG20160527T092513_cnh8hsyp_.bkp tag=TAG20160527T092513
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 03-JUN-16


Starting recover at 03-JUN-16
using channel ORA_DISK_1
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time


List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1


Creating automatic instance, with SID='gylB'


initialization parameters used for automatic instance:
db_name=ORA12C
db_unique_name=gylB_pitr_ora12cpd_ORA12C
compatible=12.1.0.2.0
db_block_size=8192
db_files=200
diagnostic_dest=/u01/app/oracle
_system_trig_enabled=FALSE
sga_target=2560M
processes=200
db_create_file_dest=/tmp/oracle
log_archive_dest_1='location=/tmp/oracle'
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used




starting up automatic instance ORA12C


Oracle instance started


Total System Global Area    2684354560 bytes


Fixed Size                     3714440 bytes
Variable Size                654312056 bytes
Database Buffers            2013265920 bytes
Redo Buffers                  13062144 bytes
Automatic instance created


contents of Memory Script:
{
# set requested point in time
set until  time "TO_DATE('2016-06-03 14:46:44','yyyy-mm-dd hh24:mi:ss')";
# restore the controlfile
restore clone controlfile;
 
# mount the controlfile
sql clone 'alter database mount clone database';
}
executing Memory Script


executing command: SET until clause


Starting restore at 03-JUN-16
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=191 device type=DISK


channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORA12C/autobackup/2016_05_27/o1_mf_s_912936317_cnh8hx2x_.bkp
channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORA12C/autobackup/2016_05_27/o1_mf_s_912936317_cnh8hx2x_.bkp tag=TAG20160527T092517
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/tmp/oracle/ORA12C/controlfile/o1_mf_co2gc7xt_.ctl
Finished restore at 03-JUN-16


sql statement: alter database mount clone database


contents of Memory Script:
{
# set requested point in time
set until  time "TO_DATE('2016-06-03 14:46:44','yyyy-mm-dd hh24:mi:ss')";
# switch to valid datafilecopies
switch clone datafile  17 to datafilecopy 
 "/u01/app/oradata/ora12c/ora12cpd/system01.dbf";
switch clone datafile  18 to datafilecopy 
 "/u01/app/oradata/ora12c/ora12cpd/sysaux01.dbf";
switch clone datafile  19 to datafilecopy 
 "/u01/app/oradata/ora12c/ora12cpd/sales01.dbf";
# set destinations for recovery set and auxiliary set datafiles
set newname for clone datafile  1 to new;
set newname for clone datafile  4 to new;
set newname for clone datafile  3 to new;
set newname for clone datafile  6 to new;
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile  1, 4, 3, 6;
 
switch clone datafile all;
}
executing Memory Script


executing command: SET until clause


datafile 17 switched to datafile copy
input datafile copy RECID=3 STAMP=913564910 file name=/u01/app/oradata/ora12c/ora12cpd/system01.dbf


datafile 18 switched to datafile copy
input datafile copy RECID=4 STAMP=913564910 file name=/u01/app/oradata/ora12c/ora12cpd/sysaux01.dbf


datafile 19 switched to datafile copy
input datafile copy RECID=5 STAMP=913564910 file name=/u01/app/oradata/ora12c/ora12cpd/sales01.dbf


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


Starting restore at 03-JUN-16
using channel ORA_AUX_DISK_1


channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /tmp/oracle/ORA12C/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to /tmp/oracle/ORA12C/datafile/o1_mf_undotbs1_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /tmp/oracle/ORA12C/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00006 to /tmp/oracle/ORA12C/datafile/o1_mf_users_%u_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORA12C/backupset/2016_05_27/o1_mf_nnndf_TAG20160527T091026_cnh7n323_.bkp
channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORA12C/backupset/2016_05_27/o1_mf_nnndf_TAG20160527T091026_cnh7n323_.bkp tag=TAG20160527T091026
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 03-JUN-16


datafile 1 switched to datafile copy
input datafile copy RECID=10 STAMP=913564925 file name=/tmp/oracle/ORA12C/datafile/o1_mf_system_co2gcfxy_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=11 STAMP=913564925 file name=/tmp/oracle/ORA12C/datafile/o1_mf_undotbs1_co2gcfy5_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=12 STAMP=913564925 file name=/tmp/oracle/ORA12C/datafile/o1_mf_sysaux_co2gcfy2_.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=13 STAMP=913564925 file name=/tmp/oracle/ORA12C/datafile/o1_mf_users_co2gcfyb_.dbf


contents of Memory Script:
{
# set requested point in time
set until  time "TO_DATE('2016-06-03 14:46:44','yyyy-mm-dd hh24:mi:ss')";
# online the datafiles restored or switched
sql clone "alter database datafile  1 online";
sql clone "alter database datafile  4 online";
sql clone "alter database datafile  3 online";
sql clone 'ORA12CPD' "alter database datafile 
 17 online";
sql clone 'ORA12CPD' "alter database datafile 
 18 online";
sql clone 'ORA12CPD' "alter database datafile 
 19 online";
sql clone "alter database datafile  6 online";
# recover pdb
recover clone database tablespace  "SYSTEM", "UNDOTBS1", "SYSAUX", "USERS" pluggable database 
 'ORA12CPD'   delete archivelog;
sql clone 'alter database open read only';
plsql <<<begin
   add_dropped_ts;
end; >>>;
plsql <<<begin
   save_pdb_clean_scn;
end; >>>;
# shutdown clone before import
shutdown clone abort
plsql <<<begin
   pdbpitr_inspect(pdbname =>  'ORA12CPD');
end; >>>;
}
executing Memory Script


executing command: SET until clause


sql statement: alter database datafile  1 online


sql statement: alter database datafile  4 online


sql statement: alter database datafile  3 online


sql statement: alter database datafile  17 online


sql statement: alter database datafile  18 online


sql statement: alter database datafile  19 online


sql statement: alter database datafile  6 online


Starting recover at 03-JUN-16
using channel ORA_AUX_DISK_1


starting media recovery


archived log for thread 1 with sequence 42 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_42_cnhgksrf_.arc
archived log for thread 1 with sequence 43 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_43_cnhgnpph_.arc
archived log for thread 1 with sequence 44 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_44_cnhhfc7c_.arc
archived log for thread 1 with sequence 45 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_45_cnhklyp9_.arc
archived log for thread 1 with sequence 46 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_46_cnho3hmf_.arc
archived log for thread 1 with sequence 47 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_47_cnhzo8ng_.arc
archived log for thread 1 with sequence 48 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_48_cnjnrqdw_.arc
archived log for thread 1 with sequence 49 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_49_cnjnzj1b_.arc
archived log for thread 1 with sequence 50 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_50_cnk9tbb8_.arc
archived log for thread 1 with sequence 51 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_51_cnkjy5m5_.arc
archived log for thread 1 with sequence 52 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_52_cnkyxsmg_.arc
archived log for thread 1 with sequence 53 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_53_cnl2gdwt_.arc
archived log for thread 1 with sequence 54 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_54_cnlf04qm_.arc
archived log for thread 1 with sequence 55 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_55_cnljjpbg_.arc
archived log for thread 1 with sequence 56 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_56_cnlv4wb8_.arc
archived log for thread 1 with sequence 57 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_57_cnm5n6yz_.arc
archived log for thread 1 with sequence 58 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_58_cnm9878c_.arc
archived log for thread 1 with sequence 59 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_59_cnmq57bn_.arc
archived log for thread 1 with sequence 60 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_60_cnn59frv_.arc
archived log for thread 1 with sequence 61 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_61_cnnm9vbj_.arc
archived log for thread 1 with sequence 62 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_62_cnnmjgpp_.arc
archived log for thread 1 with sequence 63 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_63_cno21rmr_.arc
archived log for thread 1 with sequence 64 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_64_cnocxwqc_.arc
archived log for thread 1 with sequence 65 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_65_cnoq49tz_.arc
archived log for thread 1 with sequence 66 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_66_cnot0sql_.arc
archived log for thread 1 with sequence 67 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_67_cnp4kzpz_.arc
archived log for thread 1 with sequence 68 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_68_cnp88pnh_.arc
archived log for thread 1 with sequence 69 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_69_cnpx44y9_.arc
archived log for thread 1 with sequence 70 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_70_cnql7px2_.arc
archived log for thread 1 with sequence 71 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_71_cnqq9dj6_.arc
archived log for thread 1 with sequence 72 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_72_cnr7c3w6_.arc
archived log for thread 1 with sequence 73 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_73_cnrkyc5n_.arc
archived log for thread 1 with sequence 74 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_74_cnrl2n59_.arc
archived log for thread 1 with sequence 75 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_31/o1_mf_1_75_cnrx8rv0_.arc
archived log for thread 1 with sequence 76 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_31/o1_mf_1_76_cnso0sjf_.arc
archived log for thread 1 with sequence 77 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_31/o1_mf_1_77_cnt6lxn5_.arc
archived log for thread 1 with sequence 78 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_31/o1_mf_1_78_cnth2gy5_.arc
archived log for thread 1 with sequence 79 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_31/o1_mf_1_79_cnv672fp_.arc
archived log for thread 1 with sequence 80 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_31/o1_mf_1_80_cnv6bzxs_.arc
archived log for thread 1 with sequence 81 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_81_cnvf87qo_.arc
archived log for thread 1 with sequence 82 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_82_cnw5w9gg_.arc
archived log for thread 1 with sequence 83 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_83_cnwtyp29_.arc
archived log for thread 1 with sequence 84 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_84_cnx2b4pw_.arc
archived log for thread 1 with sequence 85 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_85_cnxtm4lz_.arc
archived log for thread 1 with sequence 86 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_86_cnxtqcwk_.arc
archived log for thread 1 with sequence 87 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_87_cnxyz3k6_.arc
archived log for thread 1 with sequence 88 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_88_cnypqrr6_.arc
archived log for thread 1 with sequence 89 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_89_cnz8bop1_.arc
archived log for thread 1 with sequence 90 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_90_cnzlwgqo_.arc
archived log for thread 1 with sequence 91 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_91_cnzxg85x_.arc
archived log for thread 1 with sequence 92 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_92_co0h18mf_.arc
archived log for thread 1 with sequence 93 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_93_co0h5jz2_.arc
archived log for thread 1 with sequence 94 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_94_co0hbbpc_.arc
archived log for thread 1 with sequence 95 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_03/o1_mf_1_95_co142qct_.arc
archived log for thread 1 with sequence 96 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_03/o1_mf_1_96_co1mqn4g_.arc
archived log for thread 1 with sequence 97 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_03/o1_mf_1_97_co1x87ny_.arc
archived log for thread 1 with sequence 98 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_03/o1_mf_1_98_co24dffk_.arc
archived log for thread 1 with sequence 99 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_03/o1_mf_1_99_co2bdg28_.arc
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_42_cnhgksrf_.arc thread=1 sequence=42
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_43_cnhgnpph_.arc thread=1 sequence=43
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_44_cnhhfc7c_.arc thread=1 sequence=44
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_45_cnhklyp9_.arc thread=1 sequence=45
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_46_cnho3hmf_.arc thread=1 sequence=46
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_47_cnhzo8ng_.arc thread=1 sequence=47
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_48_cnjnrqdw_.arc thread=1 sequence=48
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_27/o1_mf_1_49_cnjnzj1b_.arc thread=1 sequence=49
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_50_cnk9tbb8_.arc thread=1 sequence=50
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_51_cnkjy5m5_.arc thread=1 sequence=51
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_52_cnkyxsmg_.arc thread=1 sequence=52
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_53_cnl2gdwt_.arc thread=1 sequence=53
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_54_cnlf04qm_.arc thread=1 sequence=54
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_55_cnljjpbg_.arc thread=1 sequence=55
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_56_cnlv4wb8_.arc thread=1 sequence=56
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_57_cnm5n6yz_.arc thread=1 sequence=57
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_28/o1_mf_1_58_cnm9878c_.arc thread=1 sequence=58
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_59_cnmq57bn_.arc thread=1 sequence=59
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_60_cnn59frv_.arc thread=1 sequence=60
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_61_cnnm9vbj_.arc thread=1 sequence=61
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_62_cnnmjgpp_.arc thread=1 sequence=62
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_63_cno21rmr_.arc thread=1 sequence=63
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_64_cnocxwqc_.arc thread=1 sequence=64
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_65_cnoq49tz_.arc thread=1 sequence=65
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_29/o1_mf_1_66_cnot0sql_.arc thread=1 sequence=66
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_67_cnp4kzpz_.arc thread=1 sequence=67
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_68_cnp88pnh_.arc thread=1 sequence=68
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_69_cnpx44y9_.arc thread=1 sequence=69
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_70_cnql7px2_.arc thread=1 sequence=70
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_71_cnqq9dj6_.arc thread=1 sequence=71
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_72_cnr7c3w6_.arc thread=1 sequence=72
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_73_cnrkyc5n_.arc thread=1 sequence=73
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_30/o1_mf_1_74_cnrl2n59_.arc thread=1 sequence=74
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_31/o1_mf_1_75_cnrx8rv0_.arc thread=1 sequence=75
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_31/o1_mf_1_76_cnso0sjf_.arc thread=1 sequence=76
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_31/o1_mf_1_77_cnt6lxn5_.arc thread=1 sequence=77
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_31/o1_mf_1_78_cnth2gy5_.arc thread=1 sequence=78
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_31/o1_mf_1_79_cnv672fp_.arc thread=1 sequence=79
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_05_31/o1_mf_1_80_cnv6bzxs_.arc thread=1 sequence=80
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_81_cnvf87qo_.arc thread=1 sequence=81
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_82_cnw5w9gg_.arc thread=1 sequence=82
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_83_cnwtyp29_.arc thread=1 sequence=83
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_84_cnx2b4pw_.arc thread=1 sequence=84
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_85_cnxtm4lz_.arc thread=1 sequence=85
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_86_cnxtqcwk_.arc thread=1 sequence=86
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_01/o1_mf_1_87_cnxyz3k6_.arc thread=1 sequence=87
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_88_cnypqrr6_.arc thread=1 sequence=88
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_89_cnz8bop1_.arc thread=1 sequence=89
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_90_cnzlwgqo_.arc thread=1 sequence=90
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_91_cnzxg85x_.arc thread=1 sequence=91
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_92_co0h18mf_.arc thread=1 sequence=92
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_93_co0h5jz2_.arc thread=1 sequence=93
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_02/o1_mf_1_94_co0hbbpc_.arc thread=1 sequence=94
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_03/o1_mf_1_95_co142qct_.arc thread=1 sequence=95
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_03/o1_mf_1_96_co1mqn4g_.arc thread=1 sequence=96
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_03/o1_mf_1_97_co1x87ny_.arc thread=1 sequence=97
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_03/o1_mf_1_98_co24dffk_.arc thread=1 sequence=98
archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2016_06_03/o1_mf_1_99_co2bdg28_.arc thread=1 sequence=99
media recovery complete, elapsed time: 00:00:34
Finished recover at 03-JUN-16


sql statement: alter database open read only






Oracle instance shut down




Removing automatic instance
Automatic instance removed
auxiliary instance file /tmp/oracle/ORA12C/datafile/o1_mf_sysaux_co2gcfy2_.dbf deleted
auxiliary instance file /tmp/oracle/ORA12C/controlfile/o1_mf_co2gc7xt_.ctl deleted
Finished recover at 03-JUN-16


RMAN> alter pluggable database ora12cpd open resetlogs;


Statement processed

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26753337/viewspace-2113555/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26753337/viewspace-2113555/