Oracle创建新undo表空间最佳实践(包含段检查)
在处理一则ORA-600[4194]案例时,参考MOS文档:StepbysteptoresolveORA-600419441934197ondatabasecrash(文档ID1428786.1)
1.对于ORA600[4194]的解释
2.创建新undo表空间最佳实践(包含段检查)
1.对于ORA600[4194]的解释:
Thefollowingerrorisoccurringinthealert.logrightbeforethedatabasecrashes.
ORA-00600:internalerrorcode,arguments:[4194],[#],[#],[],[],[],[],[]
Thiserrorindicatesthatamismatchhasbeendetectedbetweenredorecordsandrollback(undo)records.
ARGUMENTS:
Arg[a]-MaximumUndorecordnumberinUndoblock
Arg[b]-UndorecordnumberfromRedoblock
Sinceweareaddinganewundorecordtoourundoblock,wewouldexpectthatthenewrecordnumberisequaltothemaximumrecordnumberintheundoblockplusone.BeforeOraclecanaddanewundorecordtotheundoblockitvalidatesthatthisiscorrect.Ifthisvalidationfails,thenanORA-600[4194]willbetriggered.
可以看到,此错误是因为redo和undo的记录不匹配。常见于异常断电等场景。
2.创建新undo表空间最佳实践(包含段检查)
Bestpracticetocreateanewundotablespace. hismethodincludessegmentcheck. Createpfilefromspfiletoedit SQL>Createpfile='/tmp/initsid.ora'fromspfile; Shutdowntheinstance setthefollowingparametersinthepfile/tmp/initsid.ora undo_management=manual event='10513tracenamecontextforever,level2' SQL>>startuprestrictpfile='/tmp/initsid.ora' SQL>selecttablespace_name,status,segment_namefromdba_rollback_segswherestatus!='OFFLINE'; Thisiscritical-wearelookingforallundosegmentstobeoffline-Systemwillalwaysbeonline. Ifanyare'PARTLYAVAILABLE'or'NEEDSRECOVERY'-PleaseopenanissuewithOracleSupportorupdatethecurrentSR.TherearemanyoptionsfromthismomentandOracleSupportAnalystcanofferdifferentsolutionsforthebadundosegments. Ifallofflinethencontinuetothenextstep Createnewundotablespace-example SQL>createundotablespacedatafile size2000M; Dropoldundotablespace SQL>droptablespace includingcontentsanddatafiles; SQL>shutdownimmediate; SQL>startupnomount;-->UsingyourOriginalspfile .Modifythespfilewiththenewundotablespacename SQL>Altersystemsetundo_tablespace=' 'scope=spfile; .SQL>shutdownimmediate; .SQL>startup;-->Usingspfile
总结
以上所述是小编给大家介绍的Oracle创建新undo表空间最佳实践(包含段检查),希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持!
如果你觉得本文对你有帮助,欢迎转载,烦请注明出处,谢谢!