ITPub博客

首页 > 数据库 > Oracle > RMAN备份数据文件+控制文件+归档日志

RMAN备份数据文件+控制文件+归档日志

原创 Oracle 作者:zhangsharp20 时间:2015-01-28 16:52:05 0 删除 编辑

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博客 ” ,链接:https://blog.itpub.net/29802484/viewspace-1418453/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-08-12

  • 博文量
    382
  • 访问量
    801408