免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1155 | 回复: 0
打印 上一主题 下一主题

RMAN恢复数据库失败的问题 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2003-12-11 19:05 |只看该作者 |倒序浏览
在用RMAN恢复数据文件时错误提示如下。从List of Archived Logs Included中看,并没有seq=5、seq=6的内容,为何提示:
no backup of log thread 1 seq 6 scn 7889845 found
no backup of log thread 1 seq 5 scn 7779110 found

rman的错误提示:

RMAN-03022: compiling command: recover(4)
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover(4)
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 6 scn 7889845 found to restore
RMAN-06025: no backup of log thread 1 seq 5 scn 7779110 found to restore



alert.log日志:

Full restore complete of datafile 2 /dev/vx/rdsk/oradg/lv_tools01
  checkpoint is 7889778
Full restore complete of datafile 3 /dev/vx/rdsk/oradg/lv_rbs
  checkpoint is 7889778
Thu Dec 11 18:35:49 2003
alter database recover datafile list
clear
Thu Dec 11 18:35:49 2003
Completed: alter database recover datafile list
clear
Thu Dec 11 18:35:49 2003
alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6
Media Recovery Datafile: 1
Media Recovery Datafile: 2
Media Recovery Datafile: 3
Media Recovery Datafile: 4
Media Recovery Datafile: 5
Media Recovery Datafile: 6
Completed: alter database recover datafile list
1 , 2 , 3 ,
Thu Dec 11 18:35:49 2003
alter database recover if needed
start until cancel using backup controlfile
Media Recovery Start
Media Recovery Log
ORA-279 signalled during: alter database recover if needed
start until canc...
Thu Dec 11 18:35:50 2003
alter database recover cancel
ORA-1547 signalled during: alter database recover cancel...

另外:
List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    1       7024952    7025145    19-NOV-03       19-NOV-03
    1    2       7025145    7246974    19-NOV-03       24-NOV-03
    1    3       7246974    7547981    24-NOV-03       01-DEC-03
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP