rac rman備份因歸檔不可訪問出錯RMAN-06059 RMAN-03002 ORA-19625

YallonKing發表於2012-09-13
--linux環境10g的rac庫
--rman RAC備份出錯如下(部分)
Starting Control File and SPFILE Autobackup at 13-SEP-12
piece handle=+DATA/racdb/autobackup/2012_09_13/s_793904799.271.793904805 comment=NONE
Finished Control File and SPFILE Autobackup at 13-SEP-12
sql statement: alter system archive log current
Starting backup at 13-SEP-12
current log archived
released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/13/2012 17:07:11
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /opt/ora10g/racdb1_arch/1_2_792374929.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
--分析,這個原因有3
1、因為手動刪除過歸檔日誌,而未更新相關記錄導致rman無法確定其檔案狀態
解決辦法:crosscheck後刪除過期檔案即可
2、對於rac中的歸檔的備份,需要確定rman可以正常訪問到每個節點的歸檔日誌(可以人為將歸檔拷貝到相關節點目錄)
3、對於rac
解決辦法:修改rman配置parallelism和指令碼(設定的通道每個節點不夠)
參考文件:RMAN Backup Of Archivelog Files On RAC Fails With RMAN-6059 [ID 298119.1]Applies to:
Changes
 Possible modification of setting for RMAN "parallelism".
 
Cause
 This problem can be caused by changing RMAN parallelism to too low a setting
or initially not setting it high enough such that not ALL the node specific channels are allocated.
Solution
 Check your rman parallelism setting:
 
RMAN>show all;
...
 CONFIGURE DEVICE TYPE DISK PARALLELISM 1;

 Make sure parallelism is set to at least the number of channels you're
allocating. For example, if you are issuing this backup command to backup
archivelog files on a two node RAC database:

 
run {
 allocate channel d1 type disk connect 'sys/rac@node1';
 allocate channel d2 type disk connect 'sys/rac@node2';
 backup archivelog all delete input;
 release channel d1;
 release channel d2;
 }

 then set parallelism to 2:
 
RMAN>CONFIGURE DEVICE TYPE DISK PARALLELISM 2;

 If parallelism is not set at least to the number of channels allocated, not all
channels will be used  and  RMAN will not be able to access all the archivelogs specific to each node.

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26143577/viewspace-743390/,如需轉載,請註明出處,否則將追究法律責任。

相關文章