Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Oracle (Linux) › Restoring and Recovering Data › Restore Manager

Restore Manager

You can perform the various restore jobs using the Restore manager. For more information about the Restore Manager, see the Administration Guide.

The Oracle Restore Options tab on the Restore Manager provides the following restore and recovery options:

• Oracle DB User Information
• Use RMAN catalog [Recommended]
• Number of Channels (Streams)
• Restore From Latest Backup
• Restore From Backup Made On
• Restore From Backup Tag

Note: These restore options are detailed in the Restore Options section of this chapter.

• Recovery Types:

  Important! When using one of these recovery methods, all logs are reset to the last registered date in the control file, so any data recovered after this date will be lost and cannot be retrieved.

  • Until SCN (Whole DB Only)
  • Until Log Sequence Number (Whole DB Only)
  • Until Time (Whole DB Only)

  Note: Because the logs have been reset, you must perform a full offline backup to ensure that you have a record of the database at that precise moment in time.

  • No Recovery - Selecting this option restores the data but does not perform any recovery. You must recover the database yourself and then put it back online. You generally use this option when you already know that a restore cannot be recovered, such as when additional restore jobs are required or you need to set up before starting the recovery process.
  • Until the End of Logs - RMAN recovers the database, tablespaces, and data files up to the current time.
  • Until SCN (Whole DB Only) - RMAN recovers the database up to the specified System Change Number (that is, a checkpoint number). This recovery is valid for the entire database only. The database is opened with the resetlogs option.
  • Until Log Sequence Number (Whole DB Only) - RMAN recovers the database up to the specified Archived Log Sequence. This recovery is valid for the entire database only. The database is opened with the resetlogs option.
  • Until Time (Whole DB Only) - RMAN recovers the database up to the specified point in time. This recovery is valid for the entire database only. The database is opened with the resetlogs option.
  • Put Restore Object(s) Online after Recovery - When selected, this option puts the tablespaces and data files online and opens the database after the recovery has been performed.

In addition, the Advanced Oracle Restore Options tab includes the following options:

• Archived Logs Selection:
  • Do Not Restore - Selecting this option does not restore any of the archived logs.

    Note: This option is checked automatically.

  • Time Based - This option restores the archived logs based on the time they were created, and not on the time they were backed up. If you are using this option, you must also enter a value either in the From Time field or in the Until Time field.
  • Thread - This option lets you specify the thread number used to identify the Oracle instance. The default value of the thread is 1 for the Oracle instance in exclusive mode.
  • SCN Based - This option restores the range of archived logs by SCN (System Change Number).
  • Log Sequence Based - This option restores the archived logs by the archived log sequence number.
• Include Control File - Select this option if you want to restore the control files. Keep in mind that you should restore the control files only if they are corrupted or lost.

  Important! Restoring a control file resets all the logs causing you to lose the most recent data once the database is started. There is no way to recover this data.

• Block Size (Oracle 9i) - If you use this option, the size of the data blocks must match the block size used during backup; otherwise, the restore will fail.
• List Backup Sets for Selected Objects - When selected, it sends a request to list all backup sets that include the objects you selected.

  Note: This option does not restore the selected objects. To restore the selected objects, you must submit another restore job.

• Validate Backup Set Number - This option asks RMAN to validate the integrity of a backup without actually restoring it.
• Load RMAN Script - Use this option to enter the path of your RMAN script.

  Important! Using this option overrides all options you may have selected in the Restore Manager.