Friday 14 December 2012

Copy archive log from file system to +ASM diskgroup on Standby database


Issue:

Because of  one of the hanging ARC process on Production database, Standby database skip applying some of the archive log ,Hence subsequent archive log not applying and standby db issue gap sequence error in Alert log. 

The temporary solution of this issue is applying archivelogs manually through RMAN on standby database.

But permanent solution was killing hanged ARC process and create new Archival process on the production server.

Below steps shows how to apply archive log manually on standby database with RMAN.



Solution::

catalog archivelog '/cluster/home/oracle/o1_mf_1_245440_8dp02lsr_.arc';

Or run below command to copy it to ASM
RMAN >  copy archivelog  '/cluster/home/oracle/o1_mf_1_245440_8dp02lsr_.arc' to '+ARCHIVELOGS';

CATALOG START WITH '/cluster/home/oracle/archivelog';



 Steps:



[sysdba@dbguard:standbydb-/cluster/home/oracle]$ rman target /

Recovery Manager: Release 11.2.0.2.0 - Production on Fri Dec 14 12:12:21 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: LIVEDB (DBID=123232323)

RMAN> catalog archivelog '/cluster/home/oracle/o1_mf_1_245440_8dp02lsr_.arc';

using target database control file instead of recovery catalog
cataloged archived log
archived log file name=/cluster/home/oracle/o1_mf_1_245440_8dp02lsr_.arc RECID=44233 STAMP=802008765

RMAN> CATALOG START WITH '/cluster/home/oracle/archivelog';

searching for all files that match the pattern /cluster/home/oracle/archivelog

List of Files Unknown to the Database
=====================================
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245536_8dp4sgtp_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245533_8dp4okwt_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245534_8dp4pvoq_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245531_8dp4lwm5_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245529_8dp4b2cy_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245532_8dp4n6sk_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245537_8dp4xztn_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245535_8dp4r4cd_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245530_8dp4fmdv_.arc

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245536_8dp4sgtp_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245533_8dp4okwt_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245534_8dp4pvoq_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245531_8dp4lwm5_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245529_8dp4b2cy_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245532_8dp4n6sk_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245537_8dp4xztn_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245535_8dp4r4cd_.arc
File Name: /cluster/home/oracle/archivelog/o1_mf_1_245530_8dp4fmdv_.arc

RMAN>


Alert.log output ::

Fetching gap sequence in thread 1, gap sequence 245529-245537
Fri Dec 14 12:19:45 2012
Fetching gap sequence in thread 1, gap sequence 245529-245537
Fri Dec 14 12:19:56 2012
Fetching gap sequence in thread 1, gap sequence 245529-245537
Fri Dec 14 12:20:05 2012
RFS[1]: No standby redo logfiles available for thread 1
RFS[1]: Opened log for thread 1 sequence 245563 dbid -88056572 branch 766161863
Fri Dec 14 12:20:05 2012
Archived Log entry 44250 added for thread 1 sequence 245562 ID 0xfac03e01 dest 1:
Archived Log entry 44251 added for thread 1 sequence 245562 ID 0xfac03e01 dest 2:
Archived Log entry 44252 added for thread 1 sequence 245562 ID 0xfac03e01 dest 10:
Fri Dec 14 12:20:06 2012
Fetching gap sequence in thread 1, gap sequence 245529-245537
Fri Dec 14 12:20:16 2012
Media Recovery Log /cluster/home/oracle/archivelog/o1_mf_1_245529_8dp4b2cy_.arc
Media Recovery Log /cluster/home/oracle/archivelog/o1_mf_1_245530_8dp4fmdv_.arc
Media Recovery Log /cluster/home/oracle/archivelog/o1_mf_1_245531_8dp4lwm5_.arc
Media Recovery Log /cluster/home/oracle/archivelog/o1_mf_1_245532_8dp4n6sk_.arc
Media Recovery Log /cluster/home/oracle/archivelog/o1_mf_1_245533_8dp4okwt_.arc
Media Recovery Log /cluster/home/oracle/archivelog/o1_mf_1_245534_8dp4pvoq_.arc
Media Recovery Log /cluster/home/oracle/archivelog/o1_mf_1_245535_8dp4r4cd_.arc
Media Recovery Log /cluster/home/oracle/archivelog/o1_mf_1_245536_8dp4sgtp_.arc
Media Recovery Log /cluster/home/oracle/archivelog/o1_mf_1_245537_8dp4xztn_.arc
Media Recovery Log +ARCHIVELOGS/stbydb/archivelog/2012_12_14/thread_1_seq_245538.15434.802007853
Media Recovery Log +ARCHIVELOGS/stbydb/archivelog/2012_12_14/thread_1_seq_245539.1565

No comments: