oracle rac RMAN-20242问题解决思路

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:1619

oracle rac RMAN-20242问题解决思路

环境 aix 730
数据库版本 oracle 10.2.0.5 +asm+RAC
在做数据库归档日志恢复时,提示以下错误:
Starting restore at 2012-08-06 14:40:12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1994 instance=ora2 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/06/2012 14:40:13
RMAN-20242: specification does not match any archive log in the recovery catalog

解决方法: 恢复归档日志一定要跟线程号
[oracle@p730a:/oracle/app/oracle]$rman target /
Recovery Manager: Release 10.2.0.5.0 - Production on Mon Aug 6 14:42:18 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ORA (DBID=2743318089)
RMAN> restore archivelog from logseq 97249 until logseq 97254 thread 2;
Starting restore at 2012-08-06 14:43:21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1727 instance=ora1 devtype=DISK
archive log thread 2 sequence 97254 is already on disk as file +DGRECOVER/ora/archivelog/2012_08_05/thread_2_seq_97254.1943.790473651
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=97249
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=97250

恢复成功

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】