oracle rac RMAN-20242 問題解決思路

paulyibinyi發表於2012-08-06

   環境 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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章