All Products
Search
Document Center

Database Backup:Restore an Oracle standalone database

Last Updated:Nov 21, 2023

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

Prerequisites

The destination server is prepared for the restoration. For more information, see Prepare for the restoration of a standalone Oracle database.

Procedure

  1. Log on to the Database Backup (DBS) console.

  2. In the left-side navigation pane, click Backup Schedules. In the top navigation bar, select a region.

  3. On the Backup Schedules page, find the ID of the backup schedule that you want to use to create a restore task, 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, configure 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 automatically generates a task name. We recommend that you specify a name that can help you identify the task. Task names do not need to be unique.

    Set Time Restored To

    Time Range Available to Restore

    The time range available to restore the source database. DBS displays the available 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.

    Configure Destination Database

    Instance Region

    The region in which the backup gateway of the destination server resides.

    Backup Gateway

    The backup gateway of the destination server. For more information, see Install a backup gateway.

    Note

    This backup gateway is installed on the destination server.

    Data Source 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 number that is 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/db 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. For more information, see the "Create a database restoration directory" section of the Prepare for the restoration of a standalone Oracle database topic.

    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. For more information, see the "Obtain the directory of the database client" section of the Prepare for the restoration of a standalone Oracle database topic.

    Compliance warranty regarding cross-border data transfers

    Read the statement of compliance and select I have read and agree to the preceding compliance commitment.

  6. In the Configure Objects to Restore step, set the Restore Mode parameter to Restore Entire Instance and click Precheck.

  7. After the Precheck Passed message appears in the Precheck dialog box, 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
===============