Oracle数据库安全和备份恢复案例实践.pptx

Oracle Database Security 控制文件与文件头的转储与分析 alter session set events immediate trace name controlf ,level 12; alter session set events immediate trace name file_hdrs,level 12; systemstate 的转储与分析 oradebug dump systemstate 10,20,安全ppt,Whats Oracle RBA,RBA Redo Byte Address Log File Sequence Number ( 4 Bytes) Log File Block Number (4 Bytes) Redo Record Start Offset ( 2 Bytes) 参考链接 ,21,安全ppt,Controlfile inconsistent,SQL startup pfile=initora9i.ora ORACLE instance started. Total System Global Area 126950956 bytes Fixed Size 454188 bytes Variable Size 92274688 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes ORA-00214: controlfile D:ORACLEORADATASXXHDTSCONTROL03.CTL version 2623 inconsistent with file D:ORACLEORADATASXXHDTSCONTROL02.CTL version 2619,断电后导致控制文件不一致,22,安全ppt,How to verify controlfile?,控制文件的一致性判断,23,安全ppt,How to verify controlfile?,控制文件的一致性判断,24,安全ppt,File to recovery,SQL startup pfile=initora9i.ora ORACLE instance started. Total System Global Area 126950956 bytes Fixed Size 454188 bytes Variable Size 92274688 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes Database mounted. ORA-01113: file 2 needs media recovery ORA-01110: data file 2: D:ORACLEORADATASXXHDTSUNDOTBS01.DBF,数据文件恢复提示,25,安全ppt,Why Undo tablespace?,SQL alter session set events 10046 trace name context forever,level 12; Session altered. SQL alter database open; alter database open * ERROR at line 1: ORA-01113: file 2 needs media recovery ORA-01110: data file 2: D:ORACLEORADATASXXHDTSUNDOTBS01.DBF ,通过跟踪获进行深入探索,26,安全ppt,Why Undo tablespace?,UNDO的恢复判断,27,安全ppt,Why Undo tablespace?,UNDO的恢复判断 Direct Path read Datafile header,28,安全ppt,Why Undo tablespace?,UNDO的恢复判断 Checkpoint SCN / RBA,29,安全ppt,Why Undo tablespace?,30,安全ppt,ORA-600 2758,What is mean ORA-600 2758?,31,安全ppt,Why Ora-00600 ？,Checkpoint SCN & RBA,32,安全ppt,Why Ora-00600 ？,After Undo Recovery,33,安全ppt,Why Ora-00600 ？,Checkpoint RBA Wrong,34,安全ppt,Why Ora-00600 ？,Tablespace Checkpoint Wrong,35,安全ppt,Where RBA Ended?,36,安全ppt,Make RBA Back,Database can open smoothly,37,安全ppt,Did you see alert carefully?,Logseq / block / scn,38,安全ppt,Q&A,39,安全ppt,。