Restore an Oracle standalone database - Database Backup - Alibaba Cloud Documentation Center

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

Log on to the Database Backup (DBS) console.
In the left-side navigation pane, click Backup Schedules. In the top navigation bar, select a region.
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.
On the Configure Task page, click Restore Database in the upper-right corner.

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.
Set Time Restored To	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.

In the Configure Objects to Restore step, set the Restore Mode parameter to Restore Entire Instance and click Precheck.
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
===============