Dell Avamar for Oracle 19.10 User Guide

Performing a disaster recovery

With an effective data backup plan in place, you can successfully recover an Oracle server from a complete loss.

1. Replace hardware if required.
   The hostname and IP address must be same as that of the original server.
2. Install the same version of the Avamar file system client and Avamar Plug-in for Oracle. Installation provides instructions.
3. Register and activate the client with the same Avamar server.
   NOTE:To resolve registration problems, retire the client and reregister it with the Avamar server.
   The Avamar Administration Guide provides instructions for registering, retiring, and activating clients.
4. Install the same version of the Oracle software that was previously installed.
5. Set up the Oracle database:
   1. Ensure that you set the ORACLE_HOME to the same location as it was set to previously.
   2. Create the Oracle database with the same SID name that was used previously.
      Ensure that the ORACLE_SID, oradata, and flash_recovery_area pathnames are exactly the same as in the previous configuration.
6. Start the database in the nomount mode by typing the following command:
   startup nomount
7. Restore the server parameter file (spfile) by using the following RMAN script:

   connect target "/";
   set dbid=DBID;
   run{
   restore spfile to '/HOME/ORACLE/spfiletestdb.ora' from autobackup
   MAXSEQ=SEQ
   until time = "TO_DATE('DATE','YYYYMMDD')";
   }

   where:

   • DBID is the database ID.
   • /HOME/ORACLE is the path for the spfile file.
   • SEQ is the highest sequence number for the control file autobackup search.
   • DATE, YYYYMMDD is the backup date.
8. Restore the Oracle database by completing the steps in Restoring a database to a different client.