rman恢复问题(已解决)

zy407321952

rman恢复过程中遇到一个问题
alter database open resetlogs;
RMAN-03002: failure of alter db command at 06/07/2013 15:06:45
ORA-01194: file 2 needs more recovery to be consistent
ORA-01110: data file 2: '/opt/oracle/oradata/orcl10g/undotbs01.dbf'


网上搜了搜，发现大部分都是
SQL> recover database using backup controlfile;
ORA-00279: change 37838868 generated at 06/07/2013 10:57:41 needed for thread 1
ORA-00289: suggestion : /opt/oracle/arch_log/0000000003_0001_0817386920.log
ORA-00280: change 37838868 for thread 1 is in sequence #3



Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/opt/oracle/arch_log/0000000003_0001_0817386920.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log
'/opt/oracle/arch_log/0000000003_0001_0817386920.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
有人说是
这个文件还没归档因为是current组还没来得及切换日志(切换日志才能归档) 提供redo给它一组组尝试
SQL> recover database using backup controlfile;                        
ORA-00279: change 37838868 generated at 06/07/2013 10:57:41 needed for thread 1
ORA-00289: suggestion : /opt/oracle/arch_log/0000000003_0001_0817386920.log
ORA-00280: change 37838868 for thread 1 is in sequence #3


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/opt/oracle/oradata/orcl10g/redo01.log                                                      
ORA-00308: cannot open archived log '/opt/oracle/oradata/orcl10g/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


可是我手动指定一个redo日志也不行，redo日志并没有产生，求解！！！


问题已经解决，找回归档日志就没问题了。

renxiao2003

解决了就好，好久不搞ORACLE了，好多都还了。

zy407321952

很郁闷，同样的步骤做另一个数据库的恢复就没问题，有人知道吗？

zy407321952

回复 2# renxiao2003


    刚接触oracle，犯了好多错误，总算把rman给折腾好了，有一个完整的备份比什么都踏实！

renxiao2003

回复 4# zy407321952


    关键是要把操作手册记载下来。

zy407321952

回复 5# renxiao2003


    嗯，这肯定都记录的呢，后面异地恢复都是很容易的，不像刚开始，错误一堆，呵呵。