Restore archive logs from backup

How to restore archive logs from rman backup

To restore the archive logs from RMAN backup, we need to reset the default location of archivelogs otherwise RMAN restore it’s on default location, to change archivelogs location we used SET ARCHIVELOG DESTINATION command.

You also know how to use RMAN in NOARCHIVELOG MODE

Steps to restore archive logs from RMAN backup:

  1. Your Database must be in mounted open or open mode.
  2. start RMAN and connect with the target database.
  3. Execute the below steps in the RUN command.
SQL> select open_mode from v$database;
 
open_mode
--------------
READ WRITE

SQL> exit

Now start RMAN and connect with the target database.

$rman target/

In this example, we are going to restore only 10 archive logs from logseq 200 to logseq 210.

RMAN> RUN {
              #New location for archive logs.
              set archivelog destination to '/u01/arc_restore';
              #Restore archive logs as per sequence number.
              restore archivelog from logseq 200 until logseq 210;
              }

from logseq – Is the starting log sequence#
until logseq – Is the end log sequence#

If you want to restore all archivelogs from backup use below command inside run command.

RMAN> restore archivelog all;

To restore a single archive log, suppose I want to restore log number 215.

RMAN> restore archivelog from logseq=215;

How to uncatalog the required archive logs from the RMAN prompt?

RMAN>change archivelog from logseq=60 until logseq=80 uncatalog;

Watch below video for the same.

You Can subscribe my YouTube channel

Share

4 thoughts on “How to restore archive logs from rman backup”

Leave a Comment

Share