oracle rac RMAN-20242问题解决思路
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
恢复成功