ORACLE 11g 斷電重啟報錯的相關(guān)修復.doc

ORACLE 11g 斷電重啟報錯的相關(guān)修復由于服務(wù)器突然斷電，造成oracle連接的時候報錯。用客戶端連接的時候報的錯誤信息如下：ORA-01033: ORACLE initialization or shutdown in progress做了一下操作SQL shutdown abortORACLE 例程已經(jīng)關(guān)閉。SQL startup mountORA-12514: TNS: 監(jiān)聽程序當前無法識別連接描述符中請求的服務(wù)這個時候請大家把listener.ora里面的上方加上，具體的原因請大家看后面文章的解釋。SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = JCZ) (ORACLE_HOME = C:appAdministratorproduct11.2.0dbhome_1) (SID_NAME = JCZ) ) )繼續(xù)向下操作執(zhí)行startup命令是報：ORA-01589: 要打開數(shù)據(jù)庫則必須使用 RESETLOGS 或 NORESETLOGS 選項解決如下： SQL shutdown abortORACLE 例程已經(jīng)關(guān)閉。SQL startupORACLE 例程已經(jīng)啟動。Total System Global Area 711430144 bytesFixed Size 1374584 bytesVariable Size 444597896 bytesDatabase Buffers 260046848 bytesRedo Buffers 5410816 bytes數(shù)據(jù)庫裝載完畢。ORA-01589: 要打開數(shù)據(jù)庫則必須使用 RESETLOGS 或 NORESETLOGS 選項SQL alter database open resetlogs;alter database open resetlogs*第 1 行出現(xiàn)錯誤:ORA-01152: 文件 1 沒有從過舊的備份中還原ORA-01110: 數(shù)據(jù)文件 1: C:APPADMINISTRATORORADATAJCZSYSTEM01.DBFSQL recover database using backup controlfile;ORA-00279: 更改 24153794 (在 07/20/2012 09:28:29 生成) 對于線程 1 是必需的ORA-00289: 建議:C:APPADMINISTRATORFLASH_RECOVERY_AREAJCZARCHIVELOG2012_07_23O1_MF_1_939_%U_.ARCORA-00280: 更改 24153794 (用于線程 1) 在序列 #939 中指定日志: =suggested | filename | AUTO | CANCELC:appAdministratororadatajczREDO03.LOG已應用的日志。完成介質(zhì)恢復。SQL alert database open resetlogs;SP2-0734: 未知的命令開頭 alert data. - 忽略了剩余的行。SQL alter database open resetlogs;數(shù)據(jù)庫已更改。SQL參考的部分文章：Oracle9以上如果報錯ORA-12514: TNS: 監(jiān)聽程序當前無法識別連接描述符中請求的服務(wù)近日在配置Oracle 10G的流復制環(huán)境時，遇到一個問題，關(guān)閉數(shù)據(jù)庫（shutdown immediate）后，通過SQL Plus連接數(shù)據(jù)庫:conn sys/hisorc0 as sysdba，出現(xiàn)如下錯誤： ORA-12514: TNS: 監(jiān)聽程序當前無法識別連接描述符中請求的服務(wù)通過重啟服務(wù)的方式啟動數(shù)據(jù)庫，再次連接卻能成功登錄，也就是說在關(guān)閉數(shù)據(jù)庫狀態(tài)下無法連接服務(wù)器。 開始以為是系統(tǒng)環(huán)境變量Oracle_SID的配置問題，因為機器有多個實例，一陣折騰后還是不能連接。后來查資料得知： Oracle9i以后，后臺進程PMON自動在監(jiān)聽器中注冊在系統(tǒng)參數(shù)SERVICE_NAMES中定義的服務(wù)名，SERVICE_NAMES默認為DB_NAME+DOMAIN_NAME。監(jiān)聽配置文件listener.ora中可以不必指定監(jiān)聽的服務(wù)名。但是，當數(shù)據(jù)庫處于關(guān)閉狀態(tài)下PMON進程沒有啟動，也就不會自動注冊監(jiān)聽的實例名，所以使用sqlplus sys/hisorc0 as sysdba 會出現(xiàn)ORA-12514錯誤。如果在listener.ora文件中指定監(jiān)聽的實例名，則即使數(shù)據(jù)庫處于關(guān)閉狀態(tài)，仍然可以連接。listener.oraSID_LIST_LISTENER =(SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = G:oracleproduct10.2.0db_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = G:oracleproduct10.2.0db_1) (SID_NAME = ORCL) )LISTENER =(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = zyk)(PORT = 1521) )以上粗體部件為增加的內(nèi)容，修改后重啟監(jiān)聽服務(wù)后即可。附：通過在lsnrctl中輸入set display verbose，然后再通過命令service查看，服務(wù)狀態(tài)為READY表示PMON自動注冊的服務(wù)名，而UNKNOWN則表示該服務(wù)是手工在LISTENER.ORA中配置的數(shù)據(jù)庫服務(wù)。服務(wù)器莫名其妙的報這個錯，之前一直正常，從google獲取解決方案，解決之，記錄如下：1. Open the /network/admin/listener.ora file in the host,and you will see: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:oracleproduct10.2.0db_1) (PROGRAM = extproc) ) ) 2. Add the following lines after the 7th line in the above (SID_DESC = (GLOBAL_DBNAME = ORACLE) (ORACLE_HOME = D:oracleproduct10.2.0db_1) (SID_NAME = ORACLE) ) 3. At last the content of the file become to the following section:SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:oracleproduct10.2.0db_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORACLE) (ORACLE_HOME = D:oracleproduct10.2.0db_1) (SID_NAME = ORACLE) ) ) 4. Save the file and restart the TNSListener service in the host. Thats OK! ORA-01589錯誤的解決方法(2011-12-06 15:47:08)轉(zhuǎn)載標簽：雜談分類：ORACLESQL*Plus: Release 9.2.0.1.0 - Production on 星期四4月 17 15:01:26 2008Copyright (c) 1982, 2002,OracleCorporation.All rights reserved.SQL conn / as sysdba;已連接。SQL shutdown immediate;ORA-01109: database未打開已經(jīng)卸載數(shù)據(jù)庫。ORACLE 例程已經(jīng)關(guān)閉。SQL startupORACLE 例程已經(jīng)啟動。Total System Global Area135338868 bytesFixed Size453492 bytesVariable Size109051904 bytesDatabase Buffers25165824 bytesRedo Buffers667648 bytes數(shù)據(jù)庫裝載完畢。ORA-01589: 要打開數(shù)據(jù)庫則必須使用 RESETLOGS 或 NORESETLOGS 選項SQL alter database open resetlogs;alter database open resetlogs*ERROR 位于第 1 行:ORA-01113: 文件 1 需要介質(zhì)恢復ORA-01110: 數(shù)據(jù)文件 1: D:/ORACLE/ORADATA/ORCL/SYSTEM01.DBFSQLrecover database using backup controlfile;ORA-00279: 更改 1254931418 (在 06/09/2011 01:12:51 生成) 對于線程 1 是必需的ORA-00289: 建議: D:/ORACLE/ORA92/RDBMS/ARC00001.001ORA-00280: 更改 1254931418 對于線程 1 是按序列 # 1 進行的指定日志: =suggested | filename | AUTO | CANCELd:/oracle/oradata/eygle/redo01.logORA-00308: 無法打開存檔日志 d:/oracle/oradata/eygle/redo01.logORA-27041: 無法打開文件OSD-04002: ?？?O/S-Error: (OS 3) ？?？?？?指定日志: =suggested | filename | AUTO | CANCELd:/oracle/oradata/orcl/redo01.logORA-00339: 歸檔日志未包含任何重做ORA-00334: 歸檔日志: D:/ORACLE/ORADATA/ORCL/REDO01.LOGSQL recover database using backup controlfile;ORA-00279: 更改 1254931418 (在 06/09/2011 01:12:51 生成) 對于線程 1 是必需的ORA-00289: 建議: D:/ORACLE/ORA92/RDBMS/ARC00001.001ORA-00280: 更改 1254931418 對于線程 1 是按序列 # 1 進行的指定日志: =suggested | filename | AUTO | CANCELd:/oracle/oradata/orcl/redo02.logORA-00339: 歸檔日志未包含任何重做ORA-00334: 歸檔日志: D:/ORACLE/ORADATA/ORCL/REDO02.LOGSQL recover database using backup controlfile;ORA-00279: 更改 1254931418 (在 06/09/