Performing SQL Restores
You can restore the following data:
- The database and control file
- The database
- The control file
- Individual tablespaces and the control file
- Individual tablespaces
You can restore the database to an instance with the same name as the source instance to the source client, or a different client.
After the restore, you can recover the database to a point other than the current time when the current database is inconsistent.
When you choose the option to recover from the latest backup time or from the latest SCN with a secondary copy, the software only considers the time or SCN from the latest job available on the secondary copy, even when the primary copy or other copies have a more recent backup job.
Before You Begin
- You can perform a restore on the agent details page, the instances page,or job details page.
- Agent details: From the navigation pane, click Solutions > DB Instances instance, in the upper right of the page, click Restore.
- Instances page: From the navigation page, click Solutions > DB Instances, in the Actions column for the instance, click the action button , and then click Restore.
- Job details: From the navigation pane, click Jobs > job ID, in the Job summary area, click Restore.
The Backup Content page appears.
- Select the backups to restore.
- To use the latest backup, in the upper-right of the page, click Show latest backups.
- To use a backup from a specific date, in the upper-right, click Show backups as of a specific date, and then select the backup.
- To use a backup from a date range, click Show backups for a date range, and then select the backup.
- Select the data that you want to restore
- To restore all of the data, select the check box next to Database name.
- To restore individual database, clear the check box next to each tablespace that you do not want to restore.
- Click Restore.
The Restore Options dialog box appears.
- From the Destination list, select the destination host for the restore.
- To restore to a disk, in the Restore to Disk box, type the full path to restore to, or click Browse and specify the path.
- To restore with exclusive access to the database, select the Drop connections to database check box.
Note: The restore fails when the software cannot gain exclusive access to the database.
- To write the restored data to the destination regardless of whether data exists, select the Unconditionally overwrite existing database or file check box.
- To restore to a new database, from the Data files list, select the new database name.
The Database name box reflects the change.
- To restore to a new path, in the Physical path box, type the full path name, or use the Browse button.
- Click Submit.
What to Do Next
You can control or view the job. For more information, see Jobs.
Last modified: 10/31/2018 7:40:53 PM