环境 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

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博客

oracle rac RMAN-20242 问题解决思路

最新文章