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.
Post a Comment
Post a Comment