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
■ %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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- rman全庫備份備份歸檔日誌檔案
- Oracle設定多個歸檔路徑生成多份歸檔日誌,Rman備份時也只備份其中的一份歸檔日誌Oracle
- RMAN備份歸檔日誌指令碼指令碼
- 備份歸檔日誌
- rman備份後為什麼要同時備份歸檔日誌
- 用RMAN備份歸檔日誌時檢查歸檔日誌是否存在
- 備份之歸檔重做日誌備份
- 備份歸檔日誌檔案
- oracle rman備份歸檔日誌需要先切換日誌嗎Oracle
- RMAN備份整庫和歸檔日誌的方法
- RMAN備份資料檔案+控制檔案+歸檔日誌
- 歸檔日誌大小 與使用rman 備份後的歸檔日誌產生的備份集大小的關係
- RMAN備份及恢復歸檔日誌的語法
- RMAN說,我能備份(5)--RMAN備份歸檔檔案
- Oracle RMAN 不完全恢復(只有資料檔案備份,丟失歸檔日誌備份)Oracle
- oracle rman不能自動刪除歸檔日誌備份解決Oracle
- RMAN備份恢復之歸檔日誌對BLOCKRECOVER的影響BloC
- 誤刪歸檔日誌除導致備份歸檔日誌失敗
- Backup And Recovery User's Guide-備份資料庫-使用RMAN備份歸檔重做日誌GUIIDE資料庫
- 冷備份+歸檔日誌的恢復
- 使用logmnr,在RMAN備份檔案中恢復備份的歸檔日誌檔案進行分析
- 請問RMAN備份異機還原,備份之後的歸檔日誌在RMAN中怎麼處理?
- 手工rm刪除歸檔日誌對備份歸檔日誌的影響
- Backup And Recovery User's Guide-使用RMAN備份歸檔重做日誌GUIIDE
- 如何用rman備份不是預設目錄下的歸檔日誌,
- RMAN備份與恢復(新舊控制檔案及歸檔日誌)測試
- Oracle 12C 新特性:關於歸檔日誌的備份Oracle
- 使用RMAN備份RAC本地目錄中不是用NFS的歸檔日誌NFS
- 使用_allow_resetlogs_corruption開啟無歸檔日誌rman備份庫
- Oracle使用備份檔案集恢復歸檔日誌Oracle
- RMAN備份與恢復(新舊控制檔案及歸檔日誌)測試(敘)
- 備份與恢復--從備份的歸檔日誌中恢復資料
- TSM備份時因歸檔日誌丟失而導致備份失敗
- 手動刪除了歸檔日誌後,rman備份出現問題解決
- RAC環境備份歸檔日誌和RMAN恢復啟動資料庫資料庫
- 非歸檔資料庫RMAN備份資料庫
- 老虎是如何從備份集中恢復歸檔日誌
- Backup And Recovery User's Guide-只備份需要備份的歸檔重做日誌檔案GUIIDE