数据库还原

seedog123

OS：aix 6.1
oracle 11.2.0.3


     在做数据库异机异目录的数据库还原，在recover的时候报归档目录找不到，我故意没有备份归档日志。除了用隐形参数外，"_allow_resetlogs_corruption"=true 还有什么办法不用归档而打开数据库？？


报错信息：
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata/system.290.776286319'
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/23/2012 07:19:05
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 2 with sequence 10957 and starting SCN of 5314767797 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 10956 and starting SCN of 5314676997 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 10955 and starting SCN of 5314600275 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 10954 and starting SCN of 5314516715 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 10953 and starting SCN of 5314432029 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 10952 and starting SCN of 5314355048 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 10951 and starting SCN of 5314262569 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 10950 and starting SCN of 5314176174 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 10949 and starting SCN of 5314102298 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 10948 and starting SCN of 5314039228 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 10947 and starting SCN of 5313988545 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 10946 and starting SCN of 5313932922 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 10945 and starting SCN of 5313838809 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 10944 and starting SCN of 5313733134 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 15011 and starting SCN of 5314744485 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 15010 and starting SCN of 5314665178 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 15009 and starting SCN of 5314574856 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 15008 and starting SCN of 5314484555 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 15007 and starting SCN of 5314404092 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 15006 and starting SCN of 5314323939 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 15005 and starting SCN of 5314249699 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 15004 and starting SCN of 5314179795 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 15003 and starting SCN of 5314081608 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 15002 and starting SCN of 5313936695 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 15001 and starting SCN of 5313871075 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 15000 and starting SCN of 5313815689 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 14999 and starting SCN of 5313742049 found to restore
Recovery Manager complete.

[ 本帖最后由 seedog123 于 2012-5-23 19:23 编辑 ]

Maclean Liu(刘相兵

action plan:

执行 Script:收集Oracle备份恢复信息  http://www.oracledatabase12g.com ... BF%A1%E6%81%AF.html 中的全部脚本 并上传结果

seedog123

附件已上传

xifenfei

_allow_resetlogs_corruption
这个参数不是万能的

seedog123

对的，问题原因是找不到在备份的时候，产生的归档日志。

Maclean Liu(刘相兵

datafile header's checkpoint change# = 5358659210   24-MAY-2012 15:20:50

没有可用的 Incr backup

1.  restore出缺失的 archivelog 解决该问题
2. 若以上archivelog已无法获得，那么尝试使用 隐藏参数 open database
3. 考虑使用bbed修改 datafile header以绕过 相关archivelog的需求， 属于特殊恢复手段，在 datafile 较多的情况下不适用