oracle日志文件恢复

northeast1

你的是nozrchivelog mode，没有归档日志，而你用的方法需要归档模式，所以只能用上次的冷备份恢复

精华区的一哥们在非归档下竟然恢复成功，奇怪
_allow_resetlogs_corrupton 什么作用？那位高手知道

z_cactic
一般会员

注册日期: 2001 Oct
来自: hangzhou
发帖数量: 31
论坛积分:1283
哈哈，好了，谢谢大家的指导，我是这样做的：
1，参数_allow_resetlogs_corrupton = true
2，startup mount
3，alter database clear logfile group 3，提示
ORA-01624: log 3 needed for crash recovery of thread 1，说明这个语句 失 败
4，recover database until cancel ，我的数据库是在noarchivelog下的
5，alter database open resetlogs，提示内部出错。
6，shutdown
7，startup.it is ok.

bbdog

难道就没有别的办法了吗？

sqlcode

上次Oracle培训中FAQ里讲到了redolog的问题
那个工程师说： 参数_allow_resetlogs_corrupton = true 。。。。。。 这个是最后的办法了

如果还是不行，如果是NOARCHIVELOG,而且也没有近期的物理备份，那就。。。哭吧！

bbdog

我现在的问题是打不开_allow_resetlogs_corrupton = true 选项，是放在INIT.ORA里面，还是
放在INIT<SID>.ORA里面呢？

史柯

ORA-02231: missing or invalid option to ALTER DATABASE
SVRMGR> recover database until cancel;
ORA-00279: Change 91170877 generated at 11/29/01 11:24:01 needed for thread 1
ORA-00289: Suggestion : /u/oracle/app/oracle/product/7.3.2/dbs/arch1_178213.dbf
ORA-00280: Change 91170877 for thread 1 is in sequence #178213
Specify log: {<RET>=suggested | filename | AUTO | CANCEL

在此输入你的联机日志路径，若有多个，一个一个试试。完成以后用ALTER DATABASE OPEN RESETLOGS；打开数据库

bbdog

SVRMGR> recover database until cancel;;
ORA-00279: Change 91170877 generated at 11/29/01 11:24:01 needed for thread 1
ORA-00289: Suggestion : /u/oracle/app/oracle/product/7.3.2/dbs/arch1_178213.dbf
ORA-00280: Change 91170877 for thread 1 is in sequence #178213
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/u1/oracle/data1/oradata/cxxt/redocxxt01.log
ORA-00283: Recovery session canceled due to errors
ORA-00356: inconsistent lengths in change description
ORA-00353: log corruption near block 95 change 91170957 time 11/29/01 11:24:07
ORA-00334: archived log: '/u1/oracle/data1/oradata/cxxt/redocxxt01.log'
SVRMGR> recover database until cancel;
ORA-00279: Change 91170877 generated at 11/29/01 11:24:01 needed for thread 1
ORA-00289: Suggestion : /u/oracle/app/oracle/product/7.3.2/dbs/arch1_178213.dbf
ORA-00280: Change 91170877 for thread 1 is in sequence #178213
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/u1/oracle/data2/oradata/cxxt/redocxxt02.log
ORA-00310: archived log contains sequence 178211; sequence 178213 required
ORA-00334: archived log: '/u1/oracle/data2/oradata/cxxt/redocxxt02.log'
SVRMGR> recover database until cancel;
ORA-00279: Change 91170877 generated at 11/29/01 11:24:01 needed for thread 1
ORA-00289: Suggestion : /u/oracle/app/oracle/product/7.3.2/dbs/arch1_178213.dbf
ORA-00280: Change 91170877 for thread 1 is in sequence #178213
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/u1/oracle/data3/oradata/cxxt/redocxxt03.log
ORA-00310: archived log contains sequence 178212; sequence 178213 required
ORA-00334: archived log: '/u1/oracle/data3/oradata/cxxt/redocxxt03.log'
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u/oracle/data1/oradata/cxxt/system01.dbf'
还是不行