實驗1:Control File 故障


1.環境模擬

select * from v$controlfile;

利用O.S.的指令修改Control file的內容

select * from v$datafile;

發現Control file Error

ERROR at line 1:
ORA-00227: corrupt block detected in controlfile: (block 1, # blocks 1)
ORA-00202: controlfile: '/oradata/sent/ctl/control01.ctl'


shutdown immediate;
失敗


shutdown abort;

將其他好的control file複製到原來的位置上

Oracle DB的listener.log清理