rac rman備份因歸檔不可訪問出錯RMAN-06059 RMAN-03002 ORA-19625
--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
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
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:
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.
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:
Check your rman parallelism setting:
RMAN>show all;
...
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
...
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 手工刪除歸檔日誌導致RMAN備份時報ORA-19625錯誤
- RAC環境歸檔NFS掛載方式RMAN備份錯誤NFS
- oracle10g rac(rhel4)_rman備份歸檔出錯_backup archivelog allOracleHive
- 【故障處理】手工刪除歸檔日誌導致RMAN備份時報ORA-19625錯誤
- 更換歸檔日誌引數路徑導致RMAN備份時報ORA-19625錯誤
- 備份歸檔日誌報錯ORA-19625: crosscheck archivelog allROSHive
- RMAN說,我能備份(5)--RMAN備份歸檔檔案
- 刪除歸檔物理檔案備份失敗!ORA-19625
- rman全庫備份備份歸檔日誌檔案
- RMAN備份歸檔日誌多份 %c
- 使用RMAN增量備份處理Dataguard因歸檔丟失造成的gap
- RMAN備份歸檔日誌指令碼指令碼
- 非歸檔資料庫RMAN備份資料庫
- Oracle RMAN 備份控制檔案報錯問題Oracle
- 手動刪除了歸檔日誌後,rman備份出現問題解決
- 使用RMAN備份RAC本地目錄中不是用NFS的歸檔日誌NFS
- rman備份但丟失一個資料檔案,但有歸檔備份
- rman開啟備份優化對備份歸檔的影響優化
- RMAN備份、恢復實驗室 之 備份篇 【歸檔模式】模式
- rman備份後為什麼要同時備份歸檔日誌
- Rman Crosscheck刪除失效歸檔-備份恢復ROS
- RMAN恢復(rman只備份資料庫,但不備份歸檔,歸檔透過簡單的rsync或scp來傳送到異地備份)資料庫
- RAC環境備份歸檔日誌和RMAN恢復啟動資料庫資料庫
- RMAN備份資料檔案+控制檔案+歸檔日誌
- 請問RMAN備份異機還原,備份之後的歸檔日誌在RMAN中怎麼處理?
- rman備份rac的總結
- Oracle設定多個歸檔路徑生成多份歸檔日誌,Rman備份時也只備份其中的一份歸檔日誌Oracle
- TSM備份時因歸檔日誌丟失而導致備份失敗
- 用RMAN備份歸檔日誌時檢查歸檔日誌是否存在
- dg丟失歸檔,使用rman增量備份恢復
- RMAN備份整庫和歸檔日誌的方法
- ORACLE NBU調取oracle rman指令碼備份歸檔不自動刪除歸檔Oracle指令碼
- rman在歸檔與非歸檔時備份資料庫的簡單示例資料庫
- rman 非歸檔模式下停庫備份與恢復模式
- RMAN備份及恢復歸檔日誌的語法
- RMAN-ERROR:因為找不到過期和丟失的歸檔日誌而備份失敗Error
- 如何刪除控制檔案中過去rman備份到磁帶的歸檔備份集
- IIS釋出後有些檔案不可訪問