ITPub博客

首页 > Linux操作系统 > Linux操作系统 > rman里面的PLUS ARCHIVELOG方式

rman里面的PLUS ARCHIVELOG方式

原创 Linux操作系统 作者:bpmfhu 时间:2019-06-24 20:39:07 0 删除 编辑
os: redhat linux as 3 + u3
db: oracle 10.1.0.4 rac

  PLUS ARCHIVELOG方式的备份RMAN执行如下步骤的操作:
1)运行一个ALTER SYSTEM ARCHIVELOG CURRENT命令
2)运行BACKUP ARCHIVELOG ALL命令。注意如果备份优化被启用,RMAN只会备份未备份过的日志
3)备份BACKUP命令中定义的文件
4)运行ALTER SYSTEM ARCHIVELOG CURRENT命令
5)备份所有的剩下的归档日志
 BACKUP incremental level 0
 format '/opt/rman/orcl/%d_LVL0_%T_%u_s%s_p%p'
 database PLUS ARCHIVELOG format '/opt/rman/orcl/%d_AL_%T_%u_s%s_p%p'
 delete input;
 
 
starting full resync of recovery catalog
full resync complete

Starting backup at 17-MAY-05
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=134 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=139 devtype=DISK
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=247 recid=18 stamp=558482511
input archive log thread=1 sequence=248 recid=19 stamp=558482882
input archive log thread=1 sequence=249 recid=20 stamp=558486920
input archive log thread=1 sequence=250 recid=22 stamp=558503203
channel ORA_DISK_1: starting piece 1 at 17-MAY-05
channel ORA_DISK_2: starting archive log backupset
channel ORA_DISK_2: specifying archive log(s) in backup set
input archive log thread=2 sequence=32 recid=21 stamp=558484567
input archive log thread=2 sequence=33 recid=25 stamp=558525163
channel ORA_DISK_2: starting piece 1 at 17-MAY-05
channel ORA_DISK_2: finished piece 1 at 17-MAY-05
piece handle=/opt/rman/orcl/ORCL_AL_20050517_0hgkkqp9_s17_p1 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:46
channel ORA_DISK_2: deleting archive log(s)
archive log filename=/opt/archive_log/2_32_558015678.dbf recid=21 stamp=558484567
archive log filename=/opt/archive_log/2_33_558015678.dbf recid=25 stamp=558525163
channel ORA_DISK_1: finished piece 1 at 17-MAY-05
piece handle=/opt/rman/orcl/ORCL_AL_20050517_0ggkkt4f_s16_p1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:01
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/opt/archive_log/1_247_558015678.dbf recid=18 stamp=558482511
archive log filename=/opt/archive_log/1_248_558015678.dbf recid=19 stamp=558482882
archive log filename=/opt/archive_log/1_249_558015678.dbf recid=20 stamp=558486920
archive log filename=/opt/archive_log/1_250_558015678.dbf recid=22 stamp=558503203
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=251 recid=23 stamp=558524656
input archive log thread=1 sequence=252 recid=24 stamp=558527527
channel ORA_DISK_1: starting piece 1 at 17-MAY-05
channel ORA_DISK_1: finished piece 1 at 17-MAY-05
piece handle=/opt/rman/orcl/ORCL_AL_20050517_0igkkt8c_s18_p1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/opt/archive_log/1_251_558015678.dbf recid=23 stamp=558524656
archive log filename=/opt/archive_log/1_252_558015678.dbf recid=24 stamp=558527527
Finished backup at 17-MAY-05

Starting backup at 17-MAY-05
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/dev/raw/raw1
input datafile fno=00002 name=/dev/raw/raw3
input datafile fno=00004 name=/dev/raw/raw4
channel ORA_DISK_1: starting piece 1 at 17-MAY-05
channel ORA_DISK_2: starting incremental level 0 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00006 name=/dev/raw/raw15
input datafile fno=00003 name=/dev/raw/raw16
input datafile fno=00005 name=/dev/raw/raw19
channel ORA_DISK_2: starting piece 1 at 17-MAY-05
channel ORA_DISK_2: finished piece 1 at 17-MAY-05
piece handle=/opt/rman/orcl/ORCL_LVL0_20050517_0kgkkr1u_s20_p1 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:11:37
channel ORA_DISK_1: finished piece 1 at 17-MAY-05
piece handle=/opt/rman/orcl/ORCL_LVL0_20050517_0jgkkta5_s19_p1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:15:15
Finished backup at 17-MAY-05

Starting backup at 17-MAY-05
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
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=253 recid=26 stamp=558528735
channel ORA_DISK_1: starting piece 1 at 17-MAY-05
channel ORA_DISK_2: starting archive log backupset
channel ORA_DISK_2: specifying archive log(s) in backup set
input archive log thread=2 sequence=34 recid=27 stamp=558526422
channel ORA_DISK_2: starting piece 1 at 17-MAY-05
channel ORA_DISK_1: finished piece 1 at 17-MAY-05
piece handle=/opt/rman/orcl/ORCL_AL_20050517_0lgkku7c_s21_p1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/opt/archive_log/1_253_558015678.dbf recid=26 stamp=558528735
channel ORA_DISK_2: finished piece 1 at 17-MAY-05
piece handle=/opt/rman/orcl/ORCL_AL_20050517_0mgkkrv3_s22_p1 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_2: deleting archive log(s)
archive log filename=/opt/archive_log/2_34_558015678.dbf recid=27 stamp=558526422
Finished backup at 17-MAY-05

Starting Control File and SPFILE Autobackup at 17-MAY-05
piece handle=/opt/rman/orcl/c-1085796414-20050517-00 comment=NONE
Finished Control File and SPFILE Autobackup at 17-MAY-05

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4096/viewspace-52492/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 上帝关上了门
请登录后发表评论 登录
全部评论

注册时间:2001-12-26

  • 博文量
    237
  • 访问量
    153367