How to restore archive logs from rman backup in RAC

Restore archvie logs to different path

RMAN> run
{
set archivelog destination to '/ora_backup/rman/arch/';
restore archivelog from logseq=8619 until logseq=8632 thread=2;
}
2> 3> 4> 5>
executing command: SET ARCHIVELOG DESTINATION
Starting restore at 06-NOV-12
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting archive log restore to user-specified destination
archive log destination=/ora_backup/rman/arch/
channel ORA_DISK_2: starting archive log restore to user-specified destination
archive log destination=/ora_backup/rman/arch/
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=8619
channel ORA_DISK_2: restoring archive log
archive log thread=2 sequence=8626
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=8620
channel ORA_DISK_1: reading from backup piece /ora_backup/rman/al_798530720_18289_p1
channel ORA_DISK_2: restoring archive log
archive log thread=2 sequence=8627
channel ORA_DISK_2: restoring archive log
archive log thread=2 sequence=8628
channel ORA_DISK_2: restoring archive log
archive log thread=2 sequence=8629
channel ORA_DISK_2: restoring archive log
archive log thread=2 sequence=8630
channel ORA_DISK_2: restoring archive log
archive log thread=2 sequence=8631
channel ORA_DISK_2: restoring archive log
archive log thread=2 sequence=8632
channel ORA_DISK_2: reading from backup piece /ora_backup/rman/al_798617464_18300_p1
channel ORA_DISK_1: restored backup piece 1
piece handle=/ora_backup/rman/al_798530720_18289_p1 tag=TAG20121105T060519
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_2: restored backup piece 1
piece handle=/ora_backup/rman/al_798617464_18300_p1 tag=TAG20121106T061103
channel ORA_DISK_2: restore complete, elapsed time: 00:00:56
Finished restore at 06-NOV-12
RMAN>

 

 

Some other useful commands related this are

Step 1: uncatalog the required archivelogs from RMAN prompt

RMAN>CHANGE ARCHIVELOG FROM LOGSEQ=60 UNTIL LOGSEQ=70 UNCATALOG;

Once the archivelogs have been successfully uncataloged, you are now able to successfully restore the archive logs to a new location.

RMAN>run{
set archivelog destination to '/tmp/arch';
restore archivelog from logseq=60 until logseq=70;
}

Cataloging archivelogs again by added them to the RMAN repository

RMAN>CATALOG ARCHIVELOG '/opt/log/1_60_archivelog.log';

Cataloging multiple copies in a directory
RMAN>CATALOG START WITH '/opt/log';
Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in rman. Bookmark the permalink.

2 Responses to How to restore archive logs from rman backup in RAC

  1. Hi!

    I need to do this on a Physical Standby wihtout causing any problems to Production. Will this command change the archive log destination on the Production server or just for the RMAN restore session?

    Best Regards,
    Pedro Ferreira

    • Sher khan says:

      This will restore the Archive logs on the Pysical standby and will not have any affect to the production.

      Restore will not have problem because this just copy past , once it restore the next step is to apply which is dangerous if not familiar .

      Thanks,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s