Restore an Oracle database from a physical backup - Database Backup

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.

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.

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 Install a backup gateway.

Limits

Physical backups of Oracle databases depend on the Recovery Manager (RMAN) tool and control files to manage backup metadata. Therefore, to ensure the reliability of backup and restoration, you must take note of the following items when you use DBS to physically back up an Oracle database:

You cannot configure two or more backup schedules for one Oracle database. Otherwise, restoration exceptions occur.
If you restore an Oracle database by point in time, do not delete the latest full backup set before the specified point in time. Otherwise, restoration exceptions occur.

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 backup schedule that you want to manage 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 of the Create Restore Task wizard, 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 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.
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. Note If the incremental backup feature is enabled, DBS allows you to restore the data to a point in time from the completion of the first full backup to the completion of the last incremental backup. If the incremental backup feature is disabled, DBS allows you to restore the data to a point in time when a full backup is complete.
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 about how to install a backup gateway, see Install a backup gateway.
	Database Type	The type of the database that you want to back up. 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 that is 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 instance or five to six times the size of the DBS full backup set. Data is compressed when DBS performs backups. You can view the size of the full backup set in the DBS console. Log on to the DBS console. In the left-side navigation pane, click Backup Schedules. On the Backup Schedules page, find the backup schedule of the source database and click the name of the backup schedule. In the left-side navigation pane, choose Backup Tasks > Full Data. On the page that appears, you can view the size of the full backup set. For more information, see View a backup schedule.
	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.
	Compliance warranty regarding cross-border data transfers	Read and agree to the compliance commitment by selecting the check box.

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.
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.
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.

References

Back up an Oracle database