oracle create controlfile報 ORA-01503 ORA-01565 ORA-27037
如果一個很常規的操作報錯找不到原因,並且在mos中搜尋不到,那很可能就是犯了低階錯誤,呵,下面就是.
在重建控制檔案
CREATE CONTROLFILE REUSE DATABASE "DBTEST" NORESETLOGS ARCHIVELOG
...
時報以下錯誤:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/data/u02/oradata/dbtest/system01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
這個報錯的資訊告訴你,create controlfile的時候要去讀資料檔案的資訊,而此時如果資料檔案不存在,或不可訪問就會報這個錯.
剛開始不確定create controlfile時會去讀資料檔案資訊,所以懷疑是報錯資訊不準確,一直以為是create controlfile語句的語法錯誤.
最後查create controlfile的說明,看到
DATAFILE Clause
Specify the data files of the database. You must list all data files. These files must all exist, although they may be restored backups that require media recovery.
Do not include in the DATAFILE clause any data files in read-only tablespaces. You can add these types of files to the database later. Also, do not include in this clause any temporary data files (temp files).
才發現,原來create controlfile時資料檔案就要存在了,而且是可訪問的.
在重建控制檔案
CREATE CONTROLFILE REUSE DATABASE "DBTEST" NORESETLOGS ARCHIVELOG
...
時報以下錯誤:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/data/u02/oradata/dbtest/system01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
這個報錯的資訊告訴你,create controlfile的時候要去讀資料檔案的資訊,而此時如果資料檔案不存在,或不可訪問就會報這個錯.
剛開始不確定create controlfile時會去讀資料檔案資訊,所以懷疑是報錯資訊不準確,一直以為是create controlfile語句的語法錯誤.
最後查create controlfile的說明,看到
DATAFILE Clause
Specify the data files of the database. You must list all data files. These files must all exist, although they may be restored backups that require media recovery.
Do not include in the DATAFILE clause any data files in read-only tablespaces. You can add these types of files to the database later. Also, do not include in this clause any temporary data files (temp files).
才發現,原來create controlfile時資料檔案就要存在了,而且是可訪問的.
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28539951/viewspace-2089459/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle create a new database using backup controlfile to traceOracleDatabase
- create controlfile for new SID
- create pfile時報ORA-27037問題的處理
- Oracle Expdp報 ORA-19505, ORA-27037 No such file or directoryOracle
- oracle controlfile理解Oracle
- oracle controlfile template;Oracle
- Oracle 控制檔案(CONTROLFILE)Oracle
- oracle重建controlfile指令碼Oracle指令碼
- create directory in OracleOracle
- Oracle啟動報錯（ORA-01990，ORA-27037）處理方法Oracle
- Oracle 控制檔案(CONTROLFILE) -- <2>Oracle
- Oracle 控制檔案(CONTROLFILE)- <1>Oracle
- oracle controlfile檔案之三Oracle
- oracle-新增 controlfile 以及重建spfileOracle
- Oracle Internals Notes : Controlfile DumpsOracle
- Oracle Create Table as SelectOracle
- 重新 create oracle RepositoryOracle
- 【故障處理】告警日誌報“ORA-01565 Unable To open Spfile”
- Oracle基礎 06 控制檔案 controlfileOracle
- 檢視oracle中controlfile的內容Oracle
- oracle create function 例項2OracleFunction
- [Oracle] Raw device上Create TablespaceOracledev
- create or replace view 報許可權不足View
- pg_basebackup 報錯could not create directory
- ORACLE 19C RAC FOR RHEL7 打補丁報錯OPatchException: Unable to create patchObjectOracleExceptionObject
- oracle之 利用 controlfile trace檔案重建控制檔案Oracle
- Oracle OCP IZ0-053 Q64(Rman controlfile)Oracle
- VBA從Excel中生成Oracle create tableExcelOracle
- oracle create function的兩個例項OracleFunction
- Create Logical Standby For Oracle 10GOracle 10g
- oracle_datagrard 之Create筆記2Oracle筆記
- oracle_datagrard 之Create筆記1Oracle筆記
- Using Create directory & UTL_FILE in OracleOracle
- Restore standby database controlfile in ASM (refreshing standby controlfile)RESTDatabaseASM
- Oracle 11G 隱含引數“_controlfile_autobackup_delay”Oracle
- Oracle OCP 1Z0 053 Q554(Backup Controlfile)Oracle
- [WK-T]ORACLE 10G RAC+ASM增加controlfileOracle 10gASM
- oracle中create directory建在/home/oracle下可能存在的風險Oracle