当前redo file损坏，如何恢复数据库

smilebbsxp

ORA-00283: recovery session canceled due to errors
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/opt/oracle/oradata/demo/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory


数据库无法启动
关键是损坏了所有日志文件，并且在非archive状态
没有保存和备份的redo01.log文件

数据库无法drop掉当前的log文件
有无法切换，一定要在open 状态才可以

试过将ora的_allow_resetlogs_corruption=true然后启动，
执行alter database open resetlogs后提示要recover才可以，但recover database的时候提示redo01.log'错


请教如何恢复当前redo file？

smilebbsxp

？？

rollingpig

你应该有多份redolog吧

在mount状态

select * from v$logfile

如果group 1 其它member可用的话直接靠过来即可。

smilebbsxp

就是没有啊，有的话方便了

feijin

吧其他redolog cp过来
然后clear 一下呢

sshd

startup mount;
select * from v$log;
select * from v$logfile;

from there you will know which trdo group is damaged and the current status of it.

if the damaged redo group has more than one members, you drop the damaged members

if the group has only one member (or all the members are damaged), the problem become more complicated.

case 1) the status = INACTIVE, you cam simply drop the group and create anoth group
case ) status = ACTIVE or CURRENT. you can not drop the group in this case. the solution is to do an imcomplete recovery of the database to the earliest log sequence number of the damaged redo group. if you do not have a proper backup, your database is not recoverable.

smilebbsxp

原帖由 "sshd" 发表：
startup mount;
select * from v$log;
select * from v$logfile;

from there you will know which trdo group is damaged and the current status of it.

if the damaged redo group has more than one memb..........

我现在的状态是最掺的状态
当前日志没有了，因为磁盘问题，运行fsck后丢失，noarchive

sshd

you have learned your lessons ...

zalbb

用RECOVER DATABASE UNTIL CANCEL 恢复数据库尝试一下。
若是非ACTIVE的，应该可以恢复，关键是那个ACTIVE，丢了真不
太好办。

icewood

我觉得SSHD回答得很好了。