RMAN备份归档日志多份 %c

项目要求,归档日志需要备份两份。RMAN中可以直接设置进行修改。不过在备份的时候遇到了错误,加了%c后备份成功,记录一下。
■ %c Copy number for multiple copies in a duplexed backup
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;


new RMAN configuration parameters:
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
new RMAN configuration parameters are successfully stored


RMAN> backup archivelog all format '/home/oracle/backup/%t_%d_%u.arc';


Starting backup at 18-NOV-13
current log archived
using channel ORA_DISK_1
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=9 recid=5 stamp=831479128
input archive log thread=1 sequence=10 recid=6 stamp=831548007
input archive log thread=1 sequence=11 recid=7 stamp=831806585
input archive log thread=1 sequence=12 recid=8 stamp=831823051
input archive log thread=1 sequence=13 recid=9 stamp=831823120
channel ORA_DISK_1: starting piece 1 at 18-NOV-13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/18/2013 13:58:41
RMAN-20039: format requires %c when duplexing


RMAN> backup archivelog all format '/home/oracle/backup/%t_%d_%u_%c.arc';


Starting backup at 18-NOV-13
current log archived
using channel ORA_DISK_1
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=9 recid=5 stamp=831479128
input archive log thread=1 sequence=10 recid=6 stamp=831548007
input archive log thread=1 sequence=11 recid=7 stamp=831806585
input archive log thread=1 sequence=12 recid=8 stamp=831823051
input archive log thread=1 sequence=13 recid=9 stamp=831823120
input archive log thread=1 sequence=14 recid=10 stamp=831823172
channel ORA_DISK_1: starting piece 1 at 18-NOV-13
channel ORA_DISK_1: finished piece 1 at 18-NOV-13 with 2 copies and tag TAG20131118T135932
piece handle=/home/oracle/backup/831823172_PROD_0rop97a4_1.arc comment=NONE
piece handle=/home/oracle/backup/831823172_PROD_0rop97a4_2.arc comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 18-NOV-13


Starting Control File and SPFILE Autobackup at 18-NOV-13
piece handle=/home/oracle/backup/control/c-243217534-20131118-0f comment=NONE
Finished Control File and SPFILE Autobackup at 18-NOV-13

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

转载于:http://blog.itpub.net/26084062/viewspace-1061785/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
在使用RMAN备份数据库时,可以同时备份归档日志,并将备份归档日志复制到其他位置,以便在需要时进行恢复。具体步骤如下: 1. 首先需要将数据库设置为归档模式,并启用归档日志备份。 2. 创建一个备份集,可以使用以下命令: ``` RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/%U'; RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2; ``` 这个命令将创建一个备份集,将归档日志备份到磁盘上,每个备份集的大小为一个日志文件的大小。 3. 复制备份集到其他位置,可以使用以下命令: ``` RMAN> COPY BACKUPSET <backupset_tag> DEVICE TYPE DISK TO '/backup/archive_backup/'; ``` 其中,backupset_tag为备份集的标记,/backup/archive_backup/为归档日志备份的目标路径。 4. 恢复归档日志时,可以从备份集中恢复,也可以从归档日志备份的目标路径中恢复。如果需要从归档日志备份的目标路径中恢复,可以使用以下命令: ``` RMAN> CATALOG START WITH '/backup/archive_backup/'; RMAN> RESTORE ARCHIVELOG FROM TIME '<time>' UNTIL TIME '<time>' THREAD <thread#>; ``` 其中,time为恢复的时间点,thread#为归档日志所在的线程号。 需要注意的是,在备份归档日志时,需要确保备份集和复制的归档日志完整且没有损坏,以避免在恢复时出现问题。此外,在对归档日志进行恢复时,需要确保数据库处于归档模式,并备份好数据,以避免数据丢失。

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值