ORA-00245: control file backup failed; target is likely on a local file system
1.問題描述
警告日誌報錯如下:
Thu Feb 18 01:59:48 2016
Errors in file/u01/PSPROD/oracle/diag/rdbms/psprod/PSPROD1/trace/PSPROD1_ora_45856.trc:
ORA-00245: control file backup failed;target is likely on a local file system
Tue Feb 16 01:59:02 2016
Errors in file/u01/PSPROD/oracle/diag/rdbms/psprod/PSPROD1/trace/PSPROD1_ora_88792.trc:
ORA-00245: control file backup failed;target is likely on a local file system
2.問題分析
本報錯出現於oracle 11.2.0.1.0及以後的版本中,應用於所有平臺
僅僅RAC環境會發生,非rac環境不需要考慮這個問題,因為11Gr2控制檔案備份機制的改變,叢集中的任何例項都要可以寫入快照檔案。當然這個檔案也就要對所有例項可見,所以這個快照檔案要設定在共享裝置上(asm磁碟組)。
我們現在看一下本機設定:
RMAN> show all;
RMAN configuration parameters for databasewith db_unique_name PSPROD are:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICETYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF; #default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; #default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' ASOF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TONONE; # default
CONFIGURE SNAPSHOTCONTROLFILE NAME TO '/u01/PSPROD/oracle/product/11.2.0.4/dbs/snapcf_PSPROD1.f';# default
RMAN>
由上可見本機是預設的未進行修改過
因此會報245的錯誤
這裡注意下本機報錯為ORA-00245,但也可能報ora-245 所以在mos上搜尋的時候最好報錯內容也搜尋下,否則可能找不到
3.解決方案
修改rman備份配置,將控制檔案快照定向到共享磁碟組
檢查修改結果:
RMAN> show all;
RMAN configuration parameters for databasewith db_unique_name PSPROD are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;# default
CONFIGURE BACKUP OPTIMIZATION OFF; #default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; #default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 5BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICETYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF; #default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; #default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' ASOF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TONONE; # default
CONFIGURE SNAPSHOTCONTROLFILE NAME TO '+DATA_ERP/PSPROD/snapcf_PSPROD1.f';
RMAN>
注:只需要在RAC的一個節點上修改即可
MOS可參考:
ORA-245: In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared location (文件 ID 1472171.1) |
|
In this Document
Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later 1. In RAC environment controlfile autobackup fails with ora-0245
Autobackup of controlfile in RMAN is failing with error:
2. In RAC environment, backup controlfile to non shared location fails
SQL> ALTER DATABASE BACKUP CONTROLFILE TO '/home/rac1122/test/control.bk' REUSE
3. In RAC environment backing up standby controlfile to non shared location fails SQL> alter database create standby controlfile as '/home/oracle/renostdbycntrl.ctl';
alter database create standby controlfile as
4. In RAC environment copy current controlfile to '${DB_BACKUP_DIR}/rac_tnctv_control.bak';
channel ch1: starting datafile copy
5. In RAC environment, Rman backup fails if snapshot controlfile is not in shared location.
RMAN-00571: ======================================================== Only affect Real application Cluster (RAC), 11.2 onward. In RAC environment any form of controlfile backup may fail with ORA-0245 if the location of the Snapshot Controlfile is not a shared location. The backup of the controlfile actualy makes a backup of the SNAPSHOT controlfile. The Snapshot controlfile is created when the controlfile is about to be backed up. The Snapshot controlfile is a read-consistent copy of the controlfile. NOTE: There is another issue in which this error occurs when the backup location is not shared, see RMAN BACKUP TO LOCAL DEVICE WITH SNAPSHOT ON SHARED FAILS ORA-00245 (Doc ID 1516654.1)
SOLUTION: This is a RAC specific 'configuration' issue and the correct configuration is as described below It is changed behaviour which requires that the snapshot controlfile in a RAC environment, is on a shared location. 1. Check the snapshot controlfile location: RMAN> show snapshot controlfile name; 2. Configure the snapshot controlfile to a shared disk: RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/snapcf_.f'; Or in case of ASM use RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+/snapcf_.f'; NA 02-07-2012 created and Published alert 07-12-2015 updated
NOTE:1516654.1 - RMAN BACKUP TO LOCAL DEVICE WITH SNAPSHOT ON SHARED FAILS ORA-00245 |
About Me
.............................................................................................................................................
● 本文作者:小麥苗,部分內容整理自網路,若有侵權請聯絡小麥苗刪除
● 本文在itpub(http://blog.itpub.net/26736162/abstract/1/)、部落格園(http://www.cnblogs.com/lhrbest)和個人微信公眾號(xiaomaimiaolhr)上有同步更新
● 本文itpub地址:http://blog.itpub.net/26736162/abstract/1/
● 本文部落格園地址:http://www.cnblogs.com/lhrbest
● 本文pdf版、個人簡介及小麥苗雲盤地址:http://blog.itpub.net/26736162/viewspace-1624453/
● 資料庫筆試面試題庫及解答:http://blog.itpub.net/26736162/viewspace-2134706/
● DBA寶典今日頭條號地址:http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826
.............................................................................................................................................
● QQ群號:230161599(滿)、618766405
● 微信群:可加我微信,我拉大家進群,非誠勿擾
● 聯絡我請加QQ好友(646634621),註明新增緣由
● 於 2018-05-01 06:00 ~ 2018-05-31 24:00 在魔都完成
● 最新修改時間:2018-05-01 06:00 ~ 2018-05-31 24:00
● 文章內容來源於小麥苗的學習筆記,部分整理自網路,若有侵權或不當之處還請諒解
● 版權所有,歡迎分享本文,轉載請保留出處
.............................................................................................................................................
● 小麥苗的微店:https://weidian.com/s/793741433?wfr=c&ifr=shopdetail
● 小麥苗出版的資料庫類叢書:http://blog.itpub.net/26736162/viewspace-2142121/
● 小麥苗OCP、OCM、高可用網路班:http://blog.itpub.net/26736162/viewspace-2148098/
.............................................................................................................................................
使用微信客戶端掃描下面的二維碼來關注小麥苗的微信公眾號(xiaomaimiaolhr)及QQ群(DBA寶典),學習最實用的資料庫技術。
小麥苗的微信公眾號 小麥苗的DBA寶典QQ群2 《DBA筆試面試寶典》讀者群 小麥苗的微店
.............................................................................................................................................
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26736162/viewspace-2155016/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00245:control file backup failed;targetis likely on local file systemAI
- ORA-00245: control file backup operation failedAI
- 【ORACLE】ORA-00245: control file backup operation failedOracleAI
- recover database using backup control fileDatabase
- remount of /system failed: Read-only file system原因及解決REMAI
- Google File System原理Go
- 【oracle】ORA-01580 error creating control backup fileOracleError
- Resource is out of sync with the file system
- Raw Device vs File Systemdev
- control file parallel writeParallel
- ORA-27054: NFS file system where the file is created or resides is ......NFSIDE
- RMAN-05517: temporary file conflicts with file used by target database(zt)Database
- Move datafile:From File System to ASMASM
- Move datafile:From ASM to File SystemASM
- Oracle ACFS ( ASM Cluster File System )OracleASM
- HP -Data Protector Restore file systemREST
- 控制檔案-control file
- control file(控制檔案)
- ORA-27054: NFS file system where the file is created or resides is not mountedNFSIDE
- I/O上的等待事件 —— control file sequential read/control file parallel write事件Parallel
- ftp 報錯 550 Failed to open fileFTPAI
- 《The Google File System》論文研讀Go
- 【HDFS】HADOOP DISTRIBUTED FILE SYSTEMHadoop
- Eclipse:Resource is out of sync with the file systemEclipse
- aix file system, io 最佳化AI
- GFS (RedHat Global File System) 介紹Redhat
- oracle重建control file的操作Oracle
- a control file contains informationAIORM
- control file parallel write等待事件Parallel事件
- yum-GPG key retrieval failed: No such file or directoryAI
- VMware vmdk錯誤: Failed to lock the file.AI
- 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
- 《Google File System》讀書筆記(1)Go筆記