HEMESH ORAWORLD: 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

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

=======================