RMAN備份資料檔案+控制檔案+歸檔日誌

zhangsharp20發表於2015-01-28

RMAN> backup database include current controlfile plus archivelog;

 

Starting backup at 09-APR-14

current log archived

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

channel ORA_DISK_1: starting archive log backupset

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

input archive log thread=1 sequence=11 recid=9 stamp=844197561

input archive log thread=1 sequence=12 recid=10 stamp=844206816

input archive log thread=1 sequence=13 recid=11 stamp=844219881

input archive log thread=1 sequence=14 recid=12 stamp=844259634

input archive log thread=1 sequence=15 recid=13 stamp=844363185

input archive log thread=1 sequence=16 recid=15 stamp=844396883

channel ORA_DISK_1: starting piece 1 at 09-APR-14

channel ORA_DISK_2: starting archive log backupset

channel ORA_DISK_2: specifying archive log(s) in backup set

input archive log thread=1 sequence=3 recid=2 stamp=844124125

channel ORA_DISK_2: starting piece 1 at 09-APR-14

channel ORA_DISK_3: starting archive log backupset

channel ORA_DISK_3: specifying archive log(s) in backup set

input archive log thread=1 sequence=17 recid=14 stamp=844396868

input archive log thread=1 sequence=18 recid=16 stamp=844396885

input archive log thread=1 sequence=19 recid=17 stamp=844396887

input archive log thread=1 sequence=20 recid=18 stamp=844396888

input archive log thread=1 sequence=21 recid=19 stamp=844396888

input archive log thread=1 sequence=22 recid=20 stamp=844400067

channel ORA_DISK_3: starting piece 1 at 09-APR-14

channel ORA_DISK_3: finished piece 1 at 09-APR-14

piece handle=/u02/rman/SAFE/set/disk3/1/SAFE_0np591e4_1_1.bak tag=TAG20140409T033427 comment=NONE

channel ORA_DISK_3: backup set complete, elapsed time: 00:00:17

channel ORA_DISK_3: starting archive log backupset

channel ORA_DISK_3: specifying archive log(s) in backup set

input archive log thread=1 sequence=4 recid=1 stamp=844124109

input archive log thread=1 sequence=5 recid=3 stamp=844124132

input archive log thread=1 sequence=6 recid=4 stamp=844124144

input archive log thread=1 sequence=7 recid=5 stamp=844124772

input archive log thread=1 sequence=8 recid=6 stamp=844124773

input archive log thread=1 sequence=9 recid=7 stamp=844124785

input archive log thread=1 sequence=10 recid=8 stamp=844124795

channel ORA_DISK_3: starting piece 1 at 09-APR-14

channel ORA_DISK_3: finished piece 1 at 09-APR-14

piece handle=/u02/rman/SAFE/set/disk3/1/SAFE_0op591el_1_1.bak tag=TAG20140409T033427 comment=NONE

channel ORA_DISK_3: backup set complete, elapsed time: 00:00:10

channel ORA_DISK_1: finished piece 1 at 09-APR-14

piece handle=/u02/rman/SAFE/set/disk1/SAFE_0lp591e4_1_1.bak tag=TAG20140409T033427 comment=NONE

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

channel ORA_DISK_2: finished piece 1 at 09-APR-14

piece handle=/u02/rman/SAFE/set/disk2/SAFE_0mp591e4_1_1.bak tag=TAG20140409T033427 comment=NONE

channel ORA_DISK_2: backup set complete, elapsed time: 00:01:58

Finished backup at 09-APR-14

 

Starting backup at 09-APR-14

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=/u01/app/oracle/oradata/SAFE/system01.dbf

input datafile fno=00004 name=/u01/app/oracle/oradata/SAFE/users01.dbf

channel ORA_DISK_1: starting piece 1 at 09-APR-14

channel ORA_DISK_2: starting full datafile backupset

channel ORA_DISK_2: specifying datafile(s) in backupset

input datafile fno=00003 name=/u01/app/oracle/oradata/SAFE/sysaux01.dbf

input datafile fno=00002 name=/u01/app/oracle/oradata/SAFE/undotbs01.dbf

channel ORA_DISK_2: starting piece 1 at 09-APR-14

channel ORA_DISK_3: starting full datafile backupset

channel ORA_DISK_3: specifying datafile(s) in backupset

including current control file in backupset

channel ORA_DISK_3: starting piece 1 at 09-APR-14

channel ORA_DISK_3: finished piece 1 at 09-APR-14

piece handle=/u02/rman/SAFE/set/disk3/1/SAFE_0rp591hu_1_1.bak tag=TAG20140409T033627 comment=NONE

channel ORA_DISK_3: backup set complete, elapsed time: 00:01:07

channel ORA_DISK_3: starting full datafile backupset

channel ORA_DISK_3: specifying datafile(s) in backupset

including current SPFILE in backupset

channel ORA_DISK_3: starting piece 1 at 09-APR-14

channel ORA_DISK_3: finished piece 1 at 09-APR-14

piece handle=/u02/rman/SAFE/set/disk3/1/SAFE_0sp591k9_1_1.bak tag=TAG20140409T033627 comment=NONE

channel ORA_DISK_3: backup set complete, elapsed time: 00:00:21

channel ORA_DISK_2: finished piece 1 at 09-APR-14

piece handle=/u02/rman/SAFE/set/disk2/SAFE_0qp591hr_1_1.bak tag=TAG20140409T033627 comment=NONE

channel ORA_DISK_2: backup set complete, elapsed time: 00:03:27

channel ORA_DISK_1: finished piece 1 at 09-APR-14

piece handle=/u02/rman/SAFE/set/disk1/SAFE_0pp591hr_1_1.bak tag=TAG20140409T033627 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:04:17

Finished backup at 09-APR-14

 

Starting backup at 09-APR-14

current log archived

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

channel ORA_DISK_1: starting archive log backupset

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

input archive log thread=1 sequence=23 recid=21 stamp=844400444

channel ORA_DISK_1: starting piece 1 at 09-APR-14

channel ORA_DISK_1: finished piece 1 at 09-APR-14

piece handle=/u02/rman/SAFE/set/disk1/SAFE_0tp591ps_1_1.bak tag=TAG20140409T034044 comment=NONE

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

Finished backup at 09-APR-14

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29802484/viewspace-1418453/,如需轉載,請註明出處,否則將追究法律責任。

相關文章