资源描述:
《修改隐藏参数使用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