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
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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle基於時間點的不完全恢復Oracle
- oracle實驗記錄 （恢復-表空間基於時間點恢復(rman)）Oracle
- ORACLE資料庫基於時間點的不完全恢復Oracle資料庫
- oracle實驗記錄 （恢復-表空間基於時間點恢復(手動)）Oracle
- Oracle基於時間點的恢復Oracle
- oracle實驗記錄 （恢復-不完全恢復）Oracle
- 12C針對cdb全備與 PDB執行不完全恢復（基於SCN)
- RMAN基於時間點恢復Oracle資料庫Oracle資料庫
- oracle基於scn的不完全恢復Oracle
- oracle 閃回基於時間的恢復Oracle
- 基於時間執行資料庫不完全恢復資料庫
- mongodb 基於oplog的時間點恢復MongoDB
- 使用RMAN的不完全恢復-基於時間/SCN/日誌序列
- 記錄一次ORACLE的不完全恢復Oracle
- Oracle 11g 主動選擇的不完全恢復，基於時間，DDL操作Oracle
- 使用RMAN對PDB執行按時間點恢復
- Oracle 12c PDB的資料備份恢復Oracle
- oracle實驗記錄 （恢復-rman基於控制檔案的恢復）Oracle
- 恢復到特定點（時間點、scn、日誌序列號），rman不完全恢復
- oracle 基於使用者管理的不完全恢復Oracle
- 【RECO_ORACLE】Oracle 12c之CDB與PDB的備份與恢復（四）PDB的幾種恢復方式Oracle
- 【RMAN】表空間基於時間點的RMAN恢復-TSPITR
- Oracle 基於 RMAN 的不完全恢復(incomplete recovery by RMAN)Oracle
- 【TSPITR】RMAN表空間基於時間點的自動恢復
- 小記基於控制檔案的scn不完全恢復
- Backup And Recovery User's Guide-執行基於時間的或基於改變的不完全恢復GUIIDE
- 備份與恢復：Polardb資料庫資料基於時間點恢復資料庫
- PostgreSQL 時間點恢復SQL
- Oracle 不完全恢復Oracle
- oracle 12c 多租戶 pdb 恢復（單個pdb資料檔案、非系統pdb表空間、整個pdb資料庫）Oracle資料庫
- RAC 資料庫恢復到單例項下並且基於時間點恢復資料庫單例
- 基於percona xtrabackup之innobackupex實現基於時間點資料庫恢復資料庫
- 2.MongoDB 4.2副本集環境基於時間點的恢復MongoDB
- 用mysqlbinlog做基於時間點的資料恢復一例MySql資料恢復
- oracle實驗記錄 （恢復-完全恢復）Oracle
- oracle實驗記錄 （恢復-rman恢復）Oracle
- Oracle表空間時間點恢復技術TSPITROracle
- 【ASK_ORACLE】Oracle 12c之CDB與PDB的備份與恢復（一）什麼是CDB與PDB？Oracle