修改隐藏参数使用resetlogs强制打开数据库

《修改隐藏参数使用resetlogs强制打开数据库》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、刚才一会之前跟Stephen启动一个库，报错，我还没怎么留意。等跑回到自己的座位上再启动，报错了：SQL>startupORACLEinstancestarted.TotalSystemGlobalArea2204696576bytesFixedSize                 2215224bytesVariableSize           1241514696bytesDatabaseBuffers         956301312bytesRedoBuffers               4665344bytesD

2、atabasemounted.ORA-19821:anintentionallycorruptlogfilewasfound--# 竟然说目前一个redo日志挂了？再看下警告日志：SQL>selecta.value

3、

4、'/alert_'

5、

6、b.instance_name

7、

8、'.log'fromv$diag_infoa,v$instancebwherename='DiagTrace';A.VALUE

9、

10、'/ALERT_'

11、

12、B.INSTANCE_NAME

13、

14、'.LOG'-----------------------------------

15、-------------------------------------------------------------------------------------/u01/app/oracle/diag/rdbms/test/test/trace/alert_test.logSQL>hosttail-50/u01/app/oracle/diag/rdbms/test/test/trace/alert_test.logDIA0startedwithpid=8,OSid=32092WedSep1209:52:282012MMANst

16、artedwithpid=9,OSid=32094WedSep1209:52:282012DBW0startedwithpid=10,OSid=32096WedSep1209:52:282012LGWRstartedwithpid=11,OSid=32098WedSep1209:52:282012CKPTstartedwithpid=12,OSid=32100WedSep1209:52:282012SMONstartedwithpid=13,OSid=32102WedSep1209:52:282012RECOstartedwithpid

17、=14,OSid=32104WedSep1209:52:282012RBALstartedwithpid=15,OSid=32106WedSep1209:52:282012ASMBstartedwithpid=16,OSid=32108WedSep1209:52:282012MMONstartedwithpid=17,OSid=32110NOTE:initiatingMARKstartupStartingbackgroundprocessMARKstartingup1dispatcher(s)fornetworkaddress'(ADD

18、RESS=(PARTIAL=YES)(PROTOCOL=TCP))'...WedSep1209:52:282012MMNLstartedwithpid=18,OSid=32114WedSep1209:52:282012MARKstartedwithpid=19,OSid=32116NOTE:MARKhassubscribedstartingup1sharedserver(s)...ORACLE_BASEfromenvironment=/u01/app/oracleWedSep1209:52:292012ALTERDATABASE  MO

19、UNTNOTE:Loadedlibrary:/opt/oracle/extapi/64/asm/orcl/1/libasm.soNOTE:Loadedlibrary:SystemSUCCESS:diskgroupDATAwasmountedNOTE:dependencybetweendatabasetestanddiskgroupresourceora.DATA.dgisestablishedSuccessfulmountofredothread1,withmountid2091946205DatabasemountedinExclus

20、iveModeLostwriteprotectiondisabledCompleted:ALTERDATABASE  MOUNTWedSep1209:52:362012ALTERDATABASEOPENBe