ORA-00245: control file backup operation failed
從Oracle11gR2 開始,在備份控制檔案時,不在需要鎖住controlfile enqueue。對於非RAC 的資料庫, 沒有任何改變,但對於RAC 資料庫,因為控制檔案備份機制的改變,叢集中的任何instance 可以需要寫入到快照控制檔案,因此snapshot controlfile需要對所有例項是可見的。
在RAC 環境下,如果snapshot controlfile 不在共享的位置,控制檔案任何形式的都可能報ORA-245的錯誤。
快照控制檔案必須能被所有節點訪問,如果快照控制不是存放在共享裝置上,那麼在RMAN 進行控制檔案的快照備份時就會報錯。
解決方法
4.1. 檢查快照控制檔案位置
RMAN> show snapshot controlfile name;
4.2 配置snapshot controlfile 到共享位置
RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME TO '/snapcf_.f';
如果使用了ASM,就指定到對應的ASM disk group:
RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME TO '+/snapcf_.f';
-------------------------------------------------------------------------------------------------------------------------------------------------------
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATADG1/snapcf_xxx.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATADG1/snapcf_xxxx.f';
new RMAN configuration parameters are successfully stored
-------------------------------------------------------------------------------------------------------------------------------------------------------
參考文件:
In RAC environment from 11.2 onwards BackupOr Snapshot controlfile needs to be in shared location [ID 1472171.1]
RMAN backup fails with Ora-00245 AndRman-08132 [ID 1365484.1]
RMAN BACKUP TO LOCAL DEVICE WITH SNAPSHOTON SHARED FAILS ORA-00245 [ID 1516654.1]
在RAC 環境下,如果snapshot controlfile 不在共享的位置,控制檔案任何形式的都可能報ORA-245的錯誤。
快照控制檔案必須能被所有節點訪問,如果快照控制不是存放在共享裝置上,那麼在RMAN 進行控制檔案的快照備份時就會報錯。
解決方法
4.1. 檢查快照控制檔案位置
RMAN> show snapshot controlfile name;
4.2 配置snapshot controlfile 到共享位置
RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME TO '
如果使用了ASM,就指定到對應的ASM disk group:
RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME TO '+
-------------------------------------------------------------------------------------------------------------------------------------------------------
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATADG1/snapcf_xxx.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATADG1/snapcf_xxxx.f';
new RMAN configuration parameters are successfully stored
-------------------------------------------------------------------------------------------------------------------------------------------------------
參考文件:
In RAC environment from 11.2 onwards BackupOr Snapshot controlfile needs to be in shared location [ID 1472171.1]
RMAN backup fails with Ora-00245 AndRman-08132 [ID 1365484.1]
RMAN BACKUP TO LOCAL DEVICE WITH SNAPSHOTON SHARED FAILS ORA-00245 [ID 1516654.1]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26764973/viewspace-1654121/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【ORACLE】ORA-00245: control file backup operation failedOracleAI
- ORA-00245:control file backup failed;targetis likely on local file systemAI
- ORA-00245: control file backup failed; target is likely on a local file systemAI
- recover database using backup control fileDatabase
- ASM file metadata operationASM
- 【oracle】ORA-01580 error creating control backup fileOracleError
- maridb Error 'Operation DROP USER failed forErrorAI
- RMAN backup fails with Ora-00245 And Rman-08132 [ID 1365484.1]AI
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- Failed to get D-Bus connection: Operation not permittedAIMIT
- control file parallel writeParallel
- docker安裝matlab mount failed: Operation not permitted.DockerMatlabAIMIT
- Oracle 18.3 Resize operation completed for file#Oracle
- ulimit: core file size: cannot modify limit: Operation not permittedMIT
- Linux中的file_operation結構Linux
- 控制檔案-control file
- control file(控制檔案)
- I/O上的等待事件 —— control file sequential read/control file parallel write事件Parallel
- Apache無法啟動解決 the requested operation has failedApacheAI
- ORA-13516: AWR Operation failed: CATPROC not validAI
- oracle重建control file的操作Oracle
- a control file contains informationAIORM
- control file parallel write等待事件Parallel事件
- ftp 報錯 550 Failed to open fileFTPAI
- ORA-27300: OS system dependent operation:fork failed with statusAI
- ORA-27300: OS system dependent operation: CreateThread failedthreadAI
- SCRIPT TO GENERATE SQL*LOADER CONTROL FILESQL
- 重建控制檔案 recreate control file
- control file parallel write事件小記Parallel事件
- control file sequential read等待事件事件
- Database Clone by rebuilding control file.DatabaseRebuild
- oracle檔案管理之 control fileOracle
- centos 重啟掛載錯誤 failed to mount /backupCentOSAI
- yum-GPG key retrieval failed: No such file or directoryAI
- VMware vmdk錯誤: Failed to lock the file.AI
- ORA-27300: OS system dependent operation:fork failed with status: 12AI
- JBAS014613: Operation ("add") failed啟動報錯AI
- ORA-27300: OS system dependent operation:fork failed with status: 11AI