探索Oracle之数据库升级一,探索Oracle之数据库升级九 12.1.0.1 Update 12.1.0.2

RMAN> backup database plus archivelog delete input format '/DBBackup/Phycal/full_%U.bak';

Starting backup at 02-DEC-14

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

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

input archived log thread=1 sequence=48 RECID=1 STAMP=865232107

input archived log thread=1 sequence=49 RECID=2 STAMP=865232108

input archived log thread=1 sequence=50 RECID=3 STAMP=865232110

input archived log thread=1 sequence=51 RECID=4 STAMP=865232124

input archived log thread=1 sequence=52 RECID=5 STAMP=865232126

input archived log thread=1 sequence=53 RECID=6 STAMP=865232129

input archived log thread=1 sequence=54 RECID=7 STAMP=865232130

input archived log thread=1 sequence=55 RECID=8 STAMP=865232199

input archived log thread=1 sequence=56 RECID=9 STAMP=865232199

input archived log thread=1 sequence=57 RECID=10 STAMP=865232203

input archived log thread=1 sequence=58 RECID=11 STAMP=865232203

input archived log thread=1 sequence=59 RECID=12 STAMP=865232203

input archived log thread=1 sequence=60 RECID=13 STAMP=865232203

input archived log thread=1 sequence=61 RECID=14 STAMP=865232209

input archived log thread=1 sequence=62 RECID=15 STAMP=865232380

channel ORA_DISK_1: starting piece 1 at 02-DEC-14

channel ORA_DISK_1: finished piece 1 at 02-DEC-14

piece handle=/DBBackup/Phycal/full_05pp4pfs_1_1.bak tag=TAG20141202T061940 comment=NONE

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

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_48_b7st3cbs_.arc RECID=1 STAMP=865232107

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_49_b7st3d69_.arc RECID=2 STAMP=865232108

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_50_b7st3fwr_.arc RECID=3 STAMP=865232110

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_51_b7st3wto_.arc RECID=4 STAMP=865232124

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_52_b7st3ydw_.arc RECID=5 STAMP=865232126

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_53_b7st41h9_.arc RECID=6 STAMP=865232129

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_54_b7st428n_.arc RECID=7 STAMP=865232130

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_55_b7st66z1_.arc RECID=8 STAMP=865232199

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_56_b7st67ox_.arc RECID=9 STAMP=865232199

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_57_b7st6c1b_.arc RECID=10 STAMP=865232203

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_58_b7st6c22_.arc RECID=11 STAMP=865232203

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_59_b7st6c6y_.arc RECID=12 STAMP=865232203

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_60_b7st6c7o_.arc RECID=13 STAMP=865232203

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_61_b7st6kq8_.arc RECID=14 STAMP=865232209

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_62_b7stcwmv_.arc RECID=15 STAMP=865232380

Finished backup at 02-DEC-14

Starting backup at 02-DEC-14

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00004 name=/DBData/WOO12C/datafile/o1_mf_undotbs1_b7gh653v_.dbf

input datafile file number=00001 name=/DBData/WOO12C/datafile/o1_mf_system_b7gh4dtv_.dbf

input datafile file number=00003 name=/DBData/WOO12C/datafile/o1_mf_sysaux_b7gh21p2_.dbf

input datafile file number=00006 name=/DBData/WOO12C/datafile/o1_mf_users_b7gh6409_.dbf

channel ORA_DISK_1: starting piece 1 at 02-DEC-14

channel ORA_DISK_1: finished piece 1 at 02-DEC-14

piece handle=/DBData/fast_recovery_area/WOO12C/backupset/2014_12_02/o1_mf_nnndf_TAG20141202T061942_b7stcyyx_.bkp tag=TAG20141202T061942 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:36

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00014 name=/DBData/WOO12C/0847D2A3397B02B0E0533307A8C077E9/datafile/o1_mf_sysaux_b7gknfyd_.dbf

input datafile file number=00013 name=/DBData/WOO12C/0847D2A3397B02B0E0533307A8C077E9/datafile/o1_mf_system_b7gknfmp_.dbf

input datafile file number=00015 name=/DBData/WOO12C/0847D2A3397B02B0E0533307A8C077E9/datafile/o1_mf_users_b7gkngh6_.dbf

channel ORA_DISK_1: starting piece 1 at 02-DEC-14

channel ORA_DISK_1: finished piece 1 at 02-DEC-14

piece handle=/DBData/fast_recovery_area/WOO12C/0847D2A3397B02B0E0533307A8C077E9/backupset/2014_12_02/o1_mf_nnndf_TAG20141202T061942_b7stgzdo_.bkp tag=TAG20141202T061942 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:55

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00009 name=/DBData/WOO12C/08D98EA3271835F9E0533307A8C068EE/datafile/o1_mf_sysaux_b7ghrvm2_.dbf

input datafile file number=00008 name=/DBData/WOO12C/08D98EA3271835F9E0533307A8C068EE/datafile/o1_mf_system_b7ghrvnw_.dbf

input datafile file number=00010 name=/DBData/WOO12C/08D98EA3271835F9E0533307A8C068EE/datafile/o1_mf_users_b7ght9rv_.dbf

channel ORA_DISK_1: starting piece 1 at 02-DEC-14

channel ORA_DISK_1: finished piece 1 at 02-DEC-14

piece handle=/DBData/fast_recovery_area/WOO12C/08D98EA3271835F9E0533307A8C068EE/backupset/2014_12_02/o1_mf_nnndf_TAG20141202T061942_b7stlll8_.bkp tag=TAG20141202T061942 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00007 name=/DBData/WOO12C/datafile/o1_mf_sysaux_b7gh7gjq_.dbf

input datafile file number=00005 name=/DBData/WOO12C/datafile/o1_mf_system_b7gh7gkl_.dbf

channel ORA_DISK_1: starting piece 1 at 02-DEC-14

channel ORA_DISK_1: finished piece 1 at 02-DEC-14

piece handle=/DBData/fast_recovery_area/WOO12C/08D970F59616336FE0533307A8C03C35/backupset/2014_12_02/o1_mf_nnndf_TAG20141202T061942_b7stn9ly_.bkp tag=TAG20141202T061942 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05

Finished backup at 02-DEC-14

Starting backup at 02-DEC-14

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

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

input archived log thread=1 sequence=63 RECID=16 STAMP=865232715

channel ORA_DISK_1: starting piece 1 at 02-DEC-14

channel ORA_DISK_1: finished piece 1 at 02-DEC-14

piece handle=/DBBackup/Phycal/full_0app4pqb_1_1.bak tag=TAG20141202T062515 comment=NONE

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

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/DBData/fast_recovery_area/WOO12C/archivelog/2014_12_02/o1_mf_1_63_b7stpbxz_.arc RECID=16 STAMP=865232715

Finished backup at 02-DEC-14

Starting Control File and SPFILE Autobackup at 02-DEC-14

piece handle=/DBData/fast_recovery_area/WOO12C/autobackup/2014_12_02/o1_mf_s_865232716_b7stpfto_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 02-DEC-14