Avamar : How to Restore Oracle Archivelog Sequence

To restore an Oracle archivelog sequence with Avamar, follow these steps:

1. Locate the Archivelog backup piece name and the sequence number of this backup piece using the RMAN command:

   RMAN> list backup;



2. Locate the Backup Number in Avamar GUI of the matching Archivelog backup piece that needs to be restored. Match the backup date in Avamar and the RMAN list backup output.

3. Update the Avtar flag file (Options 1 & 2) or in the send statement (Option 3) by adding the following parameters. Put the value of the Backup Number in that parameter, then save the flag file. This example uses a Backup Number 25:

   --incpartials
--labelnum=25



4. Verify the Avtar flag file works properly with this command:

   /usr/local/avamar/bin/avtar --backups --flagfile=/usr/local/avamar/var/avtar-flags.txt



5. Correct any issues before proceeding to use it with the restore.

6. Below are two example scripts:

7. Per both scripts, set the values in these two parameters per the environment, “--prefix=oraver/sid/” i.e. 12c = 12, 11g = 11g. Then the --flagfile= parameter should point to the valid avtar flag file, the below path and name is just an example:

   --prefix=12/orcl/



8. Restore one sequence number:

   run { allocate channel c1 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so"; send '"--prefix=12/orcl/" "--flagfile=/usr/local/avamar/var/avtar-flags.txt" "--bindir=/usr/local/avamar/bin" "--logfile=/tmp/archivelog_restore.log"'; set archivelog destination to '/tmp/'; # <-- set this path to whatever you wish. This is the target path where RMAN will restore the files too. restore archivelog sequence 10; release channel c1; }



9. Restore a sequence of archivelogs:

   run { allocate channel c1 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so"; send '"--prefix=12/orcl/" "--flagfile=/usr/local/avamar/var/avtar-flags.txt" "--bindir=/usr/local/avamar/bin" "--logfile=/tmp/archivelog_restore.log"'; set archivelog destination to '/tmp/'; # <-- set this path to whatever you wish. This is the target path where RMAN will restore the files too. restore archivelog from sequence 10 until sequence 20; release channel c1; }



10. Restore one sequence number with --labelnumber in send statement instead of avtar flag file:

    run { allocate channel c1 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so"; send '"--prefix=12/orcl/" "--flagfile=/usr/local/avamar/var/avtar-flags.txt" "--bindir=/usr/local/avamar/bin" "--logfile=/tmp/archivelog_restore.log" "--labelnumber=25"'; set archivelog destination to '/tmp/'; # <-- set this path to whatever you wish. This is the target path where RMAN will restore the files too. restore archivelog sequence 10; release channel c1; }



11. If for some reason a problem is encountered, collect the following information:

    • Contents of the flag file
    • The RMAN output from the restore
    • The log configured with --logfile= in the send statement
    • Output of command run from RMAN 'list backup archive all' showing desired sequence for restore