控制文件的恢复

6month

重建成功了，但是下面的步骤没法走下了

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 5902516 generated at 02/28/2008 10:56:26 needed for thread 1
ORA-00289: suggestion : E:\ARCHIVELOG\ARC00116_0644597489.001
ORA-00280: change 5902516 for thread 1 is in sequence #116


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
D:\oradata\orcl\redo01.log
ORA-00310: archived log contains sequence 132; sequence 116 required
ORA-00334: archived log: 'D:\ORADATA\ORCL\REDO01.LOG'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\ORADATA\ORCL\SYSTEM01.DBF'


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 5902516 generated at 02/28/2008 10:56:26 needed for thread 1
ORA-00289: suggestion : E:\ARCHIVELOG\ARC00116_0644597489.001
ORA-00280: change 5902516 for thread 1 is in sequence #116


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
D:\oradata\orcl\redo02.log
ORA-00310: archived log contains sequence 131; sequence 116 required
ORA-00334: archived log: 'D:\ORADATA\ORCL\REDO02.LOG'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\ORADATA\ORCL\SYSTEM01.DBF'


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 5902516 generated at 02/28/2008 10:56:26 needed for thread 1
ORA-00289: suggestion : E:\ARCHIVELOG\ARC00116_0644597489.001
ORA-00280: change 5902516 for thread 1 is in sequence #116

6month

查看E:\ARCHIVELOG\ARC00116_0644597489.001是比较早点的archive 备份了，文件有，但是输入这个文件名还是不行的e

6month

我依次输入需要的archive文件直到
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
E:\ARCHIVELOG\ARC00131_0644597489.001
ORA-00279: change 6346423 generated at 03/07/2008 01:00:13 needed for thread 1
ORA-00289: suggestion : E:\ARCHIVELOG\ARC00132_0644597489.001
ORA-00280: change 6346423 for thread 1 is in sequence #132
ORA-00278: log file 'E:\ARCHIVELOG\ARC00131_0644597489.001' no longer needed
for this recovery


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
E:\ARCHIVELOG\ARC00132_0644597489.001
ORA-00308: cannot open archived log 'E:\ARCHIVELOG\ARC00132_0644597489.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
到'E:\ARCHIVELOG\ARC00132_0644597489.001'这个文件时提示找不到了，我看了archive备份的，确实到这就没有往后的文件了，后来想到那个时候把数据库的服务都停掉了，今天用了才开起来的，所以到这段时间的备份可能没有，但是有点疑惑，既然我把数据库服务都关掉了，那么archive备份难道还在继续运行么，导致现在的问题，到现在已经没有archive文件给继续恢复了，应该怎么办呢，需要把数据库恢复到以前的时间点上才行么

notmain

重建成功了的时候,要用日志文件对控制文件进行修复的.会把一些数据库的相关信息写进去.

你在修复的时候出错,是不是你的日志文件也坏了.

你把所有的日志文件都试过吗?  输入日志文件时加一下单引号.


忘记说一下,我的方法是针对没有备份的情况下重建的.你重建成功会丢失以前的备份等信息.

最好是用有

1．有控制文件备份的情况下
                        复制备份的控制文件，替换丢失的控制文件（用控制文件名命名）
SQL>startup;
SQL>recover database using backup controlfile;

看到这个提示时输入相应的日志文件路径如：
        'D:\ORACLE\ORADATA\TEST9\REDO01.LOG'
如果输入的文件有误会出现下面图片

如果出现上面错误就再重复一次
SQL> recover database using backup controlfile until cancel;
输入正确的日志后会出现


SQL>alter database open resetlogs;

[ 本帖最后由 notmain 于 2008-3-18 13:14 编辑 ]

6month

谢谢notmain兄，是我一时疏忽，忘了加双引号，现在ok
不过看到另一现象，这种恢复如果不用resetlog， 直接
recover database using backup controlfile until cancel;
按提示输入有保存的archive文件（假设都不缺失）是否也能恢复到当前状态，我的archive不全，无法继续验证下去了
我的想法不知道是否可行。。还请再指教下，非常感谢耐心解答！！