项目要求,归档日志需要备份两份。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
■ %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/