Database Backup (DBS) allows you to restore an Oracle database to a different server, to a different directory on the source server, or to the original directory on the source server. This topic describes how to restore an Oracle database from a physical backup.

Prerequisites

  • The database is backed up. For more information, see Back up an Oracle database.

  • A server is prepared to receive physical backup files. A backup gateway is installed on the server. For more information, see Add a backup gateway.

Restoration methods

Restoration method Description Configuration notes
Restore data to a different server Data is restored from the source server to another server. Select the backup gateway of the destination server.
Restore data to a different directory on the source server Data is restored from the source server to a different directory on the source server. Select the backup gateway of the source server and specify a different value for the Destination Directory parameter.
Restore data to the original directory on the source server Data from the source database is restored to the original directory on the source server. Select the backup gateway of the source server and specify the original value for the Destination Directory parameter. By default, if you do not specify this parameter, the original directory is used.

Procedure

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules.
  3. On the Backup Schedules page, find the ID of your backup schedule and click Manage in the Actions column.
  4. On the Configure Task page, click Restore Database in the upper-right corner.
  5. In the Set Time Restored To step, set the parameters that are described in the following table and click Next.
    Section Parameter Description
    N/A Task Name

    The name of the restore task. DBS generates a task name. We recommend that you set a descriptive name that is easy to identify. Task names do not have to be unique.

    Set Time Restored To Time Range Available to Restore

    The time range from the point in time when the first full backup set is created to the point in time when the latest full backup set is created. The database can be restored to a point in time within the time range.

    Restore To
    The point in time to which you want to restore the source database. The value must be within the time range that is specified by the Time Range Available to Restore parameter.
    Note After incremental backup is enabled, DBS allows you to restore the database to a point in time from the backup sets of the database.
    Configure Destination Database Instance Region The region where the backup gateway of the destination server resides.
    Backup Gateway The backup gateway that is installed to restore data. For more information about how to install a backup gateway, see Add a backup gateway.
    Database Type The type of the database that you want to restore. Default value: Oracle.
    Address The endpoint used to connect to the database that you want to restore. Default value: localhost.
    Port Number The port used to connect to the database that you want to restore. Default value: 1521.
    SID The system identifier (SID) of the database that you want to restore.
    Note You can customize a parameter file in the ORACLE_HOME/dbs directory based on the SID. If no parameter file exists, DBS automatically creates a minimum available parameter file for you to restore the Oracle database.
    Destination Directory The directory used to restore the database.
    Note To ensure that you have enough space for restoration, we recommend that you reserve at least 1.3 times the size of the source database or five to six times the size of the DBS full backup set. Data is compressed when it is being backed up by using DBS.
    Database program directory The program directory of the database that you want to restore. In this example, set this parameter to the absolute path that is specified by the ORACLE_HOME variable.
  6. In the Configure Objects to Restore step, set the Restore Mode parameter to Restore Entire Instance and click Precheck in the lower-right corner of the page.
    Note To restore an Oracle database from a physical backup, you must restore the entire instance.
  7. After the Precheck Passed message appears in the Precheck dialog box, click Start Task and wait until the database is restored.
    Note The amount of time used to restore a database depends on the specifications of the backup schedule and the size of the database. Higher specifications offer a higher restore speed. For more information, see Performance tests on backup and restoration.
  8. Optional:Log on to the restored database and execute the following SQL statement to start the database:
    ALTER database OPEN RESETLOGS;

    Your Oracle database is restored.