This topic describes how to use Database Backup (DBS) to restore an Oracle standalone instance.

Prerequisites

The destination device is prepared for the restoration. For more information, see Preparations to restore Oracle standalone databases.

Procedure

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules.
  3. On the Backup Schedules page, click Manage in the Actions column corresponding to a backup schedule.
  4. On the Configure Task page, click Restore Database in the upper-right corner.
  5. In the Set Time Restored To step of the Create Restore Task wizard, set the parameters as described in the following table and click Next.
    Section Parameter Description
    N/A Task Name The name of the restoration task. DBS generates a task name. We recommend that you set a descriptive name that makes the task easy to identify. Task names do not have to be unique.
    Set Time Restored To Time Range Available to Restore The time range available to restore the source instance. DBS displays the available time range.
    Restore To The point in time to which you want to restore the source instance. The value must be within the time range that is specified by the Time Range Available to Restore parameter.
    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.
    Note This backup gateway is installed on the destination server.
    Database Type The type of the database that you want to restore. Default value: Oracle.
    Address The endpoint used to connect to the destination database. Default value: localhost.
    Port Number The port used to connect to the destination database. Default value: 1521.
    SID The system identifier (SID) of the destination database.
    Note You can customize the parameter file in the ORACLE_HOME/dbs directory based on the SID name. If no parameter files exist, DBS automatically creates a minimum available parameter file for you to restore the Oracle database.
    Destination Directory The directory to which you want to restore the database. For more information, see Preparations to restore Oracle standalone databases.
    Database program directory The absolute path of ORACLE_HOME. For more information, see Preparations to restore Oracle standalone databases.
  6. In the Configure Objects to Restore step, set Restore Mode to Restore Entire Instance and click Precheck.
  7. If the Precheck Passed message appears, click Start Task.

What to do next

By default, the Oracle database that is restored by DBS is in the mount state. You can run the following command to change the status to open:
root > su - oracle
oracle> export ORACLE_SID=orcl;
oracle>sqlplus / as sysdba
sqlplus> alter database open resetlogs;
You can run the following command to check whether the database is enabled:
root > su - oracle
oracle> export ORACLE_SID=orcl;
oracle>sqlplus / as sysdba
sqlplus> select status from v$instance;
The following response indicates that the database is enabled:
===============
STATUS
------------
OPEN
===============