Loading...

Full System Recovery of Oracle RAC Databases: Restoring the Oracle RAC Database

Restore the Oracle database to the same or different client in the event of a disaster.

Before You Begin

  1. Rebuild the operating system.
  2. After you rebuild the operating system, verify that the ORACLE_HOME, GRID_HOME and CRS HOME directories were restored.
  3. Create the ASM instance and the required ASM diskgroups for the database, the OCR files, and the vote disk.
  4. If you have a local backup copy of the Oracle Cluster Registry (OCR) exists, then restore the OCR backup to the OCR diskgroup. If the backup does not exist, then create a new OCR.
  5. Make sure that the listener is running and configured correctly.
  6. Make sure that the ASM instance, the ASM diskgroup and the listener are registered to the Oracle Clusterware. If needed, use the srvctl utility to register the entities.
  7. Optional: Delete the pfile and spfile that were restored when the ORACLE_HOME directory was restored to ensure that latest spfile is restored.
  8. Connect to RMAN and issue the following command, to start the Oracle instance with a dummy parameter file.

    RMAN> connect target sys/sys@<dbname>
    RMAN> startup force nomount;

Procedure

  1. From the CommCell Browser, expand Client Computers > client > Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. From the Browse window, select the data to restore in the right pane and click Recover All Selected.

    The Restore Options dialog box appears.

  5. On the General tab, do the following:
    1. From the Destination Client list, select the name of the client computer.
    2. Select the Restore Control File check box.
    3. Select the Restore SP File check box.
    4. Select the Restore Data check box.
    5. Select the Recover check box.
  6. On the  Stream tab, do the following:
    1. Select the row for the physical Oracle RAC client, and then in the Stream column, type the number of streams to use for the restore.
    2. Click Advanced.

      The Advanced Restore Options dialog box appears.

  7. On the Options tab, do the following:
    1. Select the Open DB check box.
    2. Select the Yes for Reset Logs option.
    3. Select the Switch Database mode for Restore check box.
    4. Select the Set DBID check box.
  8. On the Restore tab, select the Restore Data check box, and then select the From the Latest Backup option.
  9. On the Ctrl &SP Files tab, do the following:
    1. Select the Restore Control File check box.
    2. Select the Restore From check box and then select the From auto Backup option.
    3. Select the Restore SP File check box.
    4. Select the Restore From check box and then select the From auto Backup option.
  10. On Recover tab, choose one of the following options:
    Choice Description
    Current Time Recover to the current time
    Point-in-Time Enter the date and time.

    Note: If the time zone is different on the CommServe computer and client, in the Time Zone box, select the client computer time zone.

    SCN The System Change Number (SCN) tracks the timing of transactions in the Oracle database. The SCNs are stored in the control files and the datafile headers. You can recover the database to the last existing SCN number in the control file, which is the last consistent database state.
    Latest Backup Time Recover to the latest backup job's completion time, which gets passed to the recover operation.

    This value is the Completion Time on the General Tab of the Job Details dialog box. To view the value, right-click the job, and then select View Job Details. For instructions, see Job Controller - Getting Started.

    Latest SCN Number Recover to the latest SCN.

    The latest backup job's Next SCN number is passed to the recover operation. This is the Next SCN on the General Tab of the Job Details dialog box. To view the value, right-click the job and then select View Job Details. For instructions, see Job Controller - Getting Started.

    Relative to System Date Recover to the number of days or hours relative to the current system date. The default option is to recover relative to the days,.

    If you select the Days option, the valid values are 0-7.

    If you select the Hours option, the valid values are 0-23.

  11. Click OK to close the Advanced Restore Options dialog box.

    The Restore Options dialog box appears.

  12. On General tab, do the following:
    1. Click Script Preview to review the generated RMAN script.
      Expand All

      Example

      #******CONTROL FILE/SPFILE RESTORE SCRIPT******#
      SET DBID 1814427393;
      run {
      allocate channel ch1 type 'sbt_tape'
      PARMS="SBT_LIBRARY=/opt/snapprotect/Base/libobk.so,BLKSIZE=65536,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
      TRACE 2;
      restore spfile from autobackup ;
      startup force nomount;
      }
      exit;
      SET DBID 1814427393;
      run {
      allocate channel ch1 type 'sbt_tape'
      PARMS="SBT_LIBRARY=/opt/snapprotect/Base/libobk.so,BLKSIZE=65536,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
      TRACE 2;
      restore controlfile from autobackup ;
      }
      exit;
      ******DATA RESTORE SCRIPT******
      run {
      allocate channel ch1 type 'sbt_tape'
      PARMS="SBT_LIBRARY=/opt/snapprotect/Base/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
      TRACE 0;
      restore database ;
      } exit;
      run {
      allocate channel ch1 type 'sbt_tape'
      PARMS="SBT_LIBRARY=/opt/snapprotect/Base/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
      TRACE 0; recover database until scn 3549690 ;
      alter database open resetlogs;
      }
      exit;

    2. Verify the Status is STARTED.
    3. Click OK to submit the job.

Once the procedure is complete, the database is opened due to the "Reset Logs" option and the log sequent is reset to 1.

The data files, control and SP files and redo logs are restored to their original location. If the Flash Recovery Area (FRA) is configured, then only recent archive logs are restored and new logs are archived to the FRA location.

What To Do Next

  1. Verify that the restored database and log files are available in the original location.
  2. After the database is restored, perform a full online or offline backup.
  3. Start the database.