--直接尝试打开数据库 SQL> RECOVER DATABASE ; 完成介质恢复。 SQL> alter database open ; alter database open * 第 1 行出现错误: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-01578: ORACLE data block corrupted (file # 1, block # 4575) ORA-01110: data file 1: 'H:\ORACLE\SYSTEM01.DBF' 进程 ID: 2572 会话 ID: 85 序列号: 1 --跳过坏块event打开库 SQL> startup mount pfile= 'h:/oracle/pfile.txt' ORACLE 例程已经启动。 Total System Global Area 2137886720 bytes Fixed Size 2282944 bytes Variable Size 520096320 bytes Database Buffers 1610612736 bytes Redo Buffers 4894720 bytes 数据库装载完毕。 SQL> show parameter event; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ event string 43810 trace name context forev er, level 10, 10231 trace name context forever, level 10, 10 232 trace name context forever , level 10, 10233 trace name c ontext forever, level 10, 1004 1 trace name context forever, level 10 xml_db_events string enable SQL> alter database open ; alter database open * 第 1 行出现错误: ORA-01113: 文件 1 需要介质恢复 ORA-01110: 数据文件 1: 'H:\ORACLE\SYSTEM01.DBF' SQL> recover database ; 完成介质恢复。 SQL> alter database open ; alter database open * 第 1 行出现错误: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [kokiasg1], [], [], [], [], [], [], [], [], [], [], [] 进程 ID: 9316 会话 ID: 4 序列号: 3 --upgrade方式打开数据库 SQL> startup mount pfile= 'h:/oracle/pfile.txt' ORACLE 例程已经启动。 Total System Global Area 2137886720 bytes Fixed Size 2282944 bytes Variable Size 520096320 bytes Database Buffers 1610612736 bytes Redo Buffers 4894720 bytes 数据库装载完毕。 SQL> alter database open upgrade 2 ; alter database open upgrade * 第 1 行出现错误: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [kokiasg1], [], [], [], [], [], [], [], [], [], [], [] 进程 ID: 7976 会话 ID: 4 序列号: 3 |