##########################
## Error
##########################
RMAN-20242: specification does not match any archived log in the repository
### Full Error
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=11657 instance=oralin1 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/07/2014 15:20:43
RMAN-20242: specification does not match any archived log in the repository
##########################
# Error Occurred
##########################
Error occured while trying to restore an archive log in 11.2.0.3.0 version of RAC database.
##########################
## Command Executed
##########################
restore archivelog logseq 5481;
**************************************** Step By Step Analysis ******************************************************
#########################################
# 1) Check Archive log Status
#########################################
set lines 200
col name for a75
col thread# for 9999
col creator for a8
col completion_time for a20
Select name,creator,thread#,sequence#,applied,status,to_char(first_time,'DD-MON-YYYY HH24:MI:SS') "first_time",to_char(completion_time,'DD-MON-YYYY HH24:MI:SS') "completion_time",resetlogs_id,archived,backup_count
from v$archived_log where sequence#>=5481 and thread#=2 order by sequence# desc;
NAME CREATOR THREAD# SEQUENCE# APPLIED S completion_time RESETLOGS_ID ARC BACKUP_COUNT
-------------------------------------------------------------------------------- -------- ------- ---------- --------- - -------------------- ------------ --- ------------
+RECO/oralin/archivelog/2014_07_07/thread_2_seq_5484.411.852301159 ARCH 2 5484 NO A 07-JUL-2014 14:19:32 825774564 YES 0
+RECO/oralin/archivelog/2014_07_07/thread_2_seq_5483.683.852301111 ARCH 2 5483 NO A 07-JUL-2014 14:18:46 825774564 YES 0
ARCH 2 5482 NO D 07-JUL-2014 12:01:56 825774564 YES 0
ARCH 2 5481 NO D 07-JUL-2014 12:01:54 825774564 YES 1
=====================================================================================================================
#########################################
# 2) Reason for Failure
#########################################
Error is occuring when a restore of archive logs is done. v$archived_log shows backup_count as 1 which means the archive log 5481 sequence is backed up once.
=====================================================================================================================
##########################
## Solution
##########################
Step 1) shows backup has been taken, but RMAN says that backup is not available.
Well the database in which i'm playing is a RAC database. When it comes to rac cluster database we have to use thread# with the sequence number.
restore archivelog logseq 5481 thread 2;
RMAN> restore archivelog logseq 5481 thread 2;
Starting restore at 07-JUL-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=566 instance=oralin3 device type=DISK
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=5481
channel ORA_DISK_1: reading from backup piece /opt/backup/arch/erwin_ch2_29_oralin_oralin_20140707_1096_1_1_arch
channel ORA_DISK_1: piece handle=/opt/backup/arch/erwin_ch2_29_oralin_oralin_20140707_1096_1_1_arch tag=%TAG
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
Finished restore at 07-JUL-14
RMAN>
=====================================================================================================================
Comments Are Always welcome
=====================================================================================================================
No comments:
Post a Comment