由于断电后开机登入DBA发现oracle数据库启动不了在mount状态下,点open报错提示
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 8 change 34566089 time 09/21/2007
ORA-00312: online log 2 thread 1:'D;\oracle\oradata\ms\redo02.log'
因为没有备份,我用的是不完全恢复具体如下:
select group#,sequence#,archived,status from v$log;
alter database clear unarchived logfile group 2;清除失败!
shutdown immediate
在init.ora中加入参数_allow_resetlogs_corruption = true
startup mount;
recover database until cancel
cancel
alter database open resetlogs;
它提示数据库已变更,然后我死活就是连接不上,查看服务都启动了,重启oracle服务也不报错,SQL>connect usename/password@ms as sysdba;就是连不上.
请高手给小弟解决下,不胜感激!!!
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 8 change 34566089 time 09/21/2007
ORA-00312: online log 2 thread 1:'D;\oracle\oradata\ms\redo02.log'
因为没有备份,我用的是不完全恢复具体如下:
select group#,sequence#,archived,status from v$log;
alter database clear unarchived logfile group 2;清除失败!
shutdown immediate
在init.ora中加入参数_allow_resetlogs_corruption = true
startup mount;
recover database until cancel
cancel
alter database open resetlogs;
它提示数据库已变更,然后我死活就是连接不上,查看服务都启动了,重启oracle服务也不报错,SQL>connect usename/password@ms as sysdba;就是连不上.
请高手给小弟解决下,不胜感激!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货