ORA-00214 錯誤產生原因與解決方法
原因
Typical scenarios in which you may receive an ORA-00214 include:
1. You have restored the control file from backup, but forgot
to copy it onto all of the mirrored copies of the control file
as listed in the "CONTROL_FILES" parameter in the "init.ora&
quot; file
for this instance (or config.ora in an ifile configuration).
2. You have moved one or more copies of the control file to a
different location while the database was up and running.
3. You accidentally overwrote one of the copies of the control file
with an old copy.
4. The database or the system crashed while the mirrored copies of
the control file were being updated, causing them to be out of sync.
5. You are restoring a database backup that was improperly taken
with the database up and running ("fuzzy" backup).
解決方法
fix:
The solution consists in opening the database with a single good copy
of the control file and then shutting the database down and copying
that version of the control file onto the other mirrored copies.
That will cause the next startup to succeed. The steps to be followed
are:
1. If the database is still up, do a shutdown abort now.
2. Edit the init.ora file for this instance (or config.ora in an ifile
configuration).
Find the CONTROL_FILES parameter and modify it to include
just ONE copy of the control file that you have reasons to
believe is up-to-date. For example, if you only have two
mirrored copies X and Y of the control file:
CONTROL_FILES = (X, Y)
and you know you have accidentally overwritten X with an old
copy, make
CONTROL_FILES = (Y)
If you are not sure about it, choose any one of the control file
copies and remove or comment out all the other copies from the
CONTROL_FILES parameter.
3. Start up the database in restricted mode.
STARTUP RESTRICT
If the database comes up fine, move on to Step 4.
If instead you get ORA-1122, ORA-1110, and ORA-1207, go back to
Step 2 and make the CONTROL_FILES parameter point to another one
of the mirrored copies. If you have already tried each and
every one of the mirrored copies unsuccessfully, you must create
a new control file for the database. See the Solution Reference
to PR entry 1012929.6 ("How to Recreate the Control File").
If you get ORA-1113 and ORA-1110 pointing to one of the datafiles,
it means the copy of the control file you picked is good, but
the referenced datafile must be recovered before the database can be
opened. Try issuing a RECOVER DATABASE command and applying the
logs you are prompted for. You may have to resort to the online
logs to complete media recovery. For further details, see the
Solution Reference to PR entry 1012943.6 on ORA-1113. Once the
datafile is recovered, issue an ALTER DATABASE OPEN.
4. Shut the database down (normal or immediate).
5. Make all copies of the control file consistent.
Copy the good mirrored copy of the control file that you just used
to bring the database up onto all other copies, as originally listed
in the CONTROL_FILES parameter of your init.ora file (or config.ora
in an ifile configuration).
6. Restore the CONTROL_FILES parameter to its original value.
Edit the init.ora file for this instance (or config.ora in an ifile
configuration) to make the CONTROL_FILES parameter include
all mirrored copies of the control file again.
7. Start up the database.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-664418/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00214錯誤解決
- Windows、Linux下檔案操作(寫、刪除)錯誤的產生原因、及解決方法WindowsLinux
- Linux環境下段錯誤的產生原因及除錯方法小結Linux除錯
- impdp操作產生大量UNDO的原因及解決方法
- Linux中產生zombie的原因詳解及解決方法!Linux
- 海外常見的http錯誤程式碼原因與解決HTTP
- 寬頻連線錯誤769原因與解決辦法
- 深入探討ORA-04031的產生原因及解決方法
- ora-371錯誤的原因和解決方法
- 一個不知道產生錯誤原因的javascript的問題。JavaScript
- Excel2007公式常見顯示錯誤原因與解決方法教程Excel公式
- mysql 發生系統錯誤1067的解決方法MySql
- Redis擊穿、穿透、雪崩產生原因以及解決思路Redis穿透
- Nginx502錯誤原因和解決方法總結Nginx
- vsftpd 錯誤:530 and 500 錯誤解決方法FTP
- MySQL常見錯誤分析與解決方法總結MySql
- mysql與php錯誤解決MySqlPHP
- undefined reference to錯誤的解決方法Undefined
- AFNetworkingErrorDomain 錯誤解決方法ErrorAI
- PHP錯誤“Thisfilehasexpired”的解決方法PHP
- vi/vim配置篇:亂碼產生的原因及解決
- 恆創科技:網站401錯誤的常見原因及解決方法網站
- dbfread報錯ValueError錯誤解決方法Error
- 深度學習中“過擬合”的產生原因和解決方法深度學習
- ORA-39006錯誤原因及解決辦法
- photoshop匯出png發生未知錯誤的解決方案,ps匯出發生未知錯誤怎麼解決
- cursor: pin S產生原理及解決方法
- Windows 下 Laravel Mix 資源編譯過程以及產生的錯誤解決WindowsLaravel編譯
- 解決 ln -s 軟連結產生的Too many levels of symbolic links錯誤Symbol
- HTTP 錯誤 500.19- Internal Server Error 錯誤解決方法HTTPServerError
- 【Oracle】ORA-00054 錯誤解決方法Oracle
- 錯誤Namenodeisinsafemode的解決方法
- Android錯誤解決方法集錦Android
- hadoop日常錯誤解決方法整理Hadoop
- ORA-04098錯誤解決方法
- ORA-25154錯誤解決方法
- npm WARN unmet dependency錯誤解決方法NPM
- No bean named 'xxx' is defined錯誤,原因及解決方案Bean