Oracle 11g RMAN 备份异机恢复并创建新DBID(二)

2014-11-24 18:03:12 · 作者: · 浏览: 1


piece handle=/u01/app/oracle/flash_recovery_area/ORCL/autobackup/2011_04_11/o1_mf_s_748210222_6t79my7k_.bkp comment=NONE


Finished Control File and SPFILE Autobackup at 11-APR-11



sql statement: alter system archive log current



Starting backup at 11-APR-11


current log archived


channel c1: starting archived log backup set


channel c1: specifying archived log(s) in backup set


input archived log thread=1 sequence=11 RECID=6 STAMP=748188047


channel c1: starting piece 1 at 11-APR-11


channel c2: starting archived log backup set


channel c2: specifying archived log(s) in backup set


input archived log thread=1 sequence=12 RECID=7 STAMP=748210223


input archived log thread=1 sequence=13 RECID=8 STAMP=748210223


channel c2: starting piece 1 at 11-APR-11


channel c1: finished piece 1 at 11-APR-11


piece handle=/u02/backup/arch_0nm9hi1f_1_1_20110411 tag=ARC_BAK comment=NONE


channel c1: backup set complete, elapsed time: 00:00:01


channel c1: deleting archived log(s)


archived log file name=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_04_11/o1_mf_1_11_6t6myz6m_.arc RECID=6 STAMP=748188047


channel c2: finished piece 1 at 11-APR-11


piece handle=/u02/backup/arch_0om9hi1f_1_1_20110411 tag=ARC_BAK comment=NONE


channel c2: backup set complete, elapsed time: 00:00:01


channel c2: deleting archived log(s)


archived log file name=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_04_11/o1_mf_1_12_6t79mzb6_.arc RECID=7 STAMP=748210223


archived log file name=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_04_11/o1_mf_1_13_6t79mzg7_.arc RECID=8 STAMP=748210223


Finished backup at 11-APR-11



Starting backup at 11-APR-11


channel c1: starting full datafile backup set


channel c1: specifying datafile(s) in backup set


including current control file in backup set


channel c1: starting piece 1 at 11-APR-11


channel c1: finished piece 1 at 11-APR-11


piece handle=/u02/backup/ctl_file_0pm9hi1h_1_1_20110411 tag=BAK_CTLFILE comment=NONE


channel c1: backup set complete, elapsed time: 00:00:03


Finished backup at 11-APR-11



Starting backup at 11-APR-11


channel c1: starting full datafile backup set


channel c1: specifying datafile(s) in backup set


including current SPFILE in backup set


channel c1: starting piece 1 at 11-APR-11


channel c1: finished piece 1 at 11-APR-11


piece handle=/u02/backup/ORCL_spfile_0qm9hi1l_1_1_20110411 tag=SPFILE comment=NONE


channel c1: backup set complete, elapsed time: 00:00:01


Finished backup at 11-APR-11



Starting Control File and SPFILE Autobackup at 11-APR-11


piece handle=/u01/app/oracle/flash_recovery_area/ORCL/autobackup/2011_04_11/o1_mf_s_748210230_6t79n67d_.bkp comment=NONE


Finished Control File and SPFILE Autobackup at 11-APR-11



released channel: c2



released channel: c1



RMAN> list backup;




List of Backup Sets


===================




BS Key Type LV Size Device Type Elapsed Time Completion Time


------- ---- -- ---------- ----------- ------------ ---------------


13 Incr 0 444.11M DISK 00:00:02 11-APR-11


BP Key: 13 Status: AVAILABLE Compressed: NO Tag: ORCL_LEV0