|
环境:solaris8 ,oracle 8.1.6
没有备份和归档
机器突然掉电,数据库重新启动报错
有三个日志组,每组一个日志文件
1、
报错:
SVRMGR> alter database open;
alter database open
*
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 237640 change 1186662514 time 11/09/2005 19:58:10
ORA-00312: online log 3 thread 1: '/ora_expredo1/redo03.log'
2、
因为没有备份和归档,只有清空日志组,执行如下命令,但不能成功。
SQL> ALTER DATABASE CLEAR UNARCHIVEDLOGFILE GROUP 3 ;
*
ERROR at line 1:
ORA-01624: log 3 needed for crash recovery of thread 1
ORA-00312: online log 3 thread 1: '/ora_expredo1/redo03.log'
3、使用隐含参数_allow_resetlogs_corruption=true,强制打开
startup mount
recover database until cancel;
alter database open resetlogs;
报错:
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
4、重新启动数据库
SQL> startup restrict
ORACLE instance started.
Total System Global Area 890507172 bytes
Fixed Size 94116 bytes
Variable Size 68575232 bytes
Database Buffers 819200000 bytes
Redo Buffers 2637824 bytes
Database mounted.
ORA-00600: internal error code, arguments: [2662], [0], [1186518377], [0],
[1186662232], [12582914], [], []
不知道如何处理了,各位大侠多多帮助。
恢复允许丢失一些数据,但关键是数据库不能打开。
谢谢!指条明路也行 |
|