RMAN BACKUP...PLUS ARCHIVELOG命令执行步骤

BACKUP...PLUS ARCHIVELOG命令在备份过程中会依次执行下列步骤:

  1 )运行ALTER SYSTEM ARCHIVE LOG CURRENT语句对当前 Redolog 进行归档。

  2 )执行BACKUP ARCHIVELOG ALL命令备份所有已归档日志。

  3 )执行BACKUP命令对指定项进行备份。

  4 )再次运行ALTER SYSTEM ARCHIVE LOG CURRENT对当前 Redolog 归档。

  5 )对新生成的尚未备份的归档文件进行备份。

示例:

RMAN> backup database format '/home/oracle/full_%d_%s_%p_%T' plus archivelog delete input;


Starting backup at 2015-01-06 09:20:53
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=14095 RECID=26042 STAMP=868266136
input archived log thread=1 sequence=14096 RECID=26045 STAMP=868266403
input archived log thread=1 sequence=14097 RECID=26048 STAMP=868266737
input archived log thread=1 sequence=14098 RECID=26051 STAMP=868267004
input archived log thread=1 sequence=14099 RECID=26053 STAMP=868267254
channel ORA_DISK_1: starting piece 1 at 2015-01-06 09:22:22
channel ORA_DISK_1: finished piece 1 at 2015-01-06 09:22:23
piece handle=/dbdat/orclprd/flash_recovery_area/DB1/backupset/2015_01_06/o1_mf_annnn_TAG20150106T092055_bbpg6gq4_.bkp tag=TAG20150106T092055 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=/dbdat/orclprd/oracle/archivelog/1_14095_840379839.dbf RECID=26042 STAMP=868266136
archived log file name=/dbdat/orclprd/oracle/archivelog/1_14096_840379839.dbf RECID=26045 STAMP=868266403
archived log file name=/dbdat/orclprd/oracle/archivelog/1_14097_840379839.dbf RECID=26048 STAMP=868266737
archived log file name=/dbdat/orclprd/oracle/archivelog/1_14098_840379839.dbf RECID=26051 STAMP=868267004
archived log file name=/dbdat/orclprd/oracle/archivelog/1_14099_840379839.dbf RECID=26053 STAMP=868267254
Finished backup at 2015-01-06 09:22:24

Starting backup at 2015-01-06 09:22:24
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=00005 name=/dbdat/orclprd/oradata/orcl/userspace1.dbf
input datafile file number=00006 name=/dbdat/orclprd/oradata/orcl/userspace2.dbf
input datafile file number=00001 name=/dbdat/orclprd/oradata/orcl/system01.dbf
input datafile file number=00002 name=/dbdat/orclprd/oradata/orcl/sysaux01.dbf
input datafile file number=00003 name=/dbdat/orclprd/oradata/orcl/undotbs01.dbf
input datafile file number=00004 name=/dbdat/orclprd/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2015-01-06 09:22:24
channel ORA_DISK_1: finished piece 1 at 2015-01-06 09:22:59
piece handle=/home/oracle/full_ORCL_69_1_20150106 tag=TAG20150106T092224 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2015-01-06 09:23:00
channel ORA_DISK_1: finished piece 1 at 2015-01-06 09:23:01
piece handle=/home/oracle/full_ORCL_70_1_20150106 tag=TAG20150106T092224 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2015-01-06 09:23:01

Starting backup at 2015-01-06 09:23:01
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=14100 RECID=26057 STAMP=868267341
input archived log thread=1 sequence=14101 RECID=26061 STAMP=868267382
channel ORA_DISK_1: starting piece 1 at 2015-01-06 09:23:03
channel ORA_DISK_1: finished piece 1 at 2015-01-06 09:23:04
piece handle=/dbdat/orclprd/flash_recovery_area/DB1/backupset/2015_01_06/o1_mf_annnn_TAG20150106T092303_bbpg7q6h_.bkp tag=TAG20150106T092303 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=/dbdat/orclprd/oracle/archivelog/1_14100_840379839.dbf RECID=26057 STAMP=868267341
archived log file name=/dbdat/orclprd/oracle/archivelog/1_14101_840379839.dbf RECID=26061 STAMP=868267382
Finished backup at 2015-01-06 09:23:04


  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值