Thursday, February 28, 2013

Copy Archivelogs from ASM to disk via RMAN

Copy archivelogs from ASM to desired disk via RMAN (as oracle user):
#This makes backup of the file so it is not basic copy.

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=testdb1

rman

RMAN> connect target /

# This gives you latest logs in the end of the listing:
RMAN> LIST ARCHIVELOG ALL;

# And then copy desired:
RMAN> copy archivelog '+TEST_TESTDB_ARCH0/TESTDB/ARCHIVELOG/thread_2_seq_144809.675.808567493' to '/backup/export/thread_2_seq_144809.675.808567493';

Starting backup at 20120228-101014
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=2 sequence=144809 RECID=380790 STAMP=808567494
output file name=/backup/export/thread_2_seq_144809.675.808567493 RECID=380792 STAMP=808567817
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03
Finished backup at 20120228-101018

No comments:

Post a Comment