How to find Archives in RMAN Backup Pieces and Restore Them on Disk


Many times when we are trying to do a recovery or cloning process, we need archives to perform the media recovery. If those archives are backup in RMAN backup pieces, we might need to restore them back and use them for our recovery.

Find the backup pieces in which our archives exist.


Command:

rman target /
list backup of archivelog sequence between 28423 and 28436;



Restore Archives from backup pieces to Disk.

Command:

rman target /
restore archivelog from logseq=28423 until logseq=28436;

This command will restore the archive to the default archive location of the database.

If we want to restore to a separate location, please use

rman target /
run
{
set archivelog destination to '/oracle/stage';
restore archivelog from logseq=28423 until logseq=28436;
}

The archive sequence should be changed based on your environment sequence number.





If you like please follow and comment