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

恢复成功

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-740010/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-740010/