Skip to main content

How can we help you?

Druva Documentation

Restore an Oracle database to a point-in-time

Phoenix Editions: File:/tick.png Business File:/cross.png Enterprise File:/tick.png Elite

 

When Oracle databases run in the ARCHIVELOG mode, the databases make copies of all online redo logs after the databases are filled. Druva Phoenix backs up such archive logs, and you can use it to restore your databases to any point-in-time between the available range of the archived logs. It is a useful, lightweight approach to backup and restore. Archive log backups are incrementally triggered after a full backup job has completed, and a restore point exists. The archive log is backed up every few minutes based on your settings. 

Druva Phoenix uses the restore point and the archive logs that were logged, to perform a point-in-time restore. When you restore the database using archive logs, databases are restored to the nearest, last available committed transaction before the specified point-in-time. 

When you initiate a restore operation, the backup data is downloaded to the requested restore location. The DBA can run RMAN commands to fetch backup data downloaded to the restore location and recover the database on the required Oracle server host.  For more information, see Recover database from the downloaded backup data.

The following video illustrates the process.  

Procedure

  1. Log in to the Phoenix Management Console. 
  2. On the menu bar, click All Organizations, and select the required organization from the drop-down list.
  3. On the menu bar, click Protect > Oracle > Direct to Cloud
  4. In the left navigation pane, click Configured Databases.
  5. On the Configured Databases page, select the database that you want to restore and click Restore.
    Note: To quickly search and select a database, you can use the search box on the top-right corner of the Configured Databases page to filter the listed database. Type the name of the database, Oracle server, or the availability group in the search tab to narrow down on the database that you want to select.
  6. On the Restore Database page, click Point-in-Time Restore.
    SBTRestorePIT1.PNG
  7. In the Select Date and Time section, the Available Time Range section displays all available snapshots with the daily retention.
  8. Specify a date and time to which you want Druva Phoenix to restore the databases. Click the Calendar icon to select a date of the restore point and select the restore point from the available range of restore points for the selected date. The timestamps of the archive logs are displayed according to the Oracle server time zone. For example, the timestamps for servers located in New York and London are displayed according to EST and UTC time zones, respectively.
    Databases will be restored to the last available committed transaction before the specified point in time.
  9. Click Show Databases.
    The Databases section displays all the available databases for restore based on the selected date and time.
  10. In the Database Files section, select the database or individual database elements that you want to restore.
  11. Click Restore.
    Note: If a backup job for the database selected for snapshot restore is already running, Druva Phoenix prompts a message to cancel the backup job and trigger restore.
  12. If you selected the database check box, Druva Phoenix provides the following two restore target options to restore the complete database. 
    1. Restore to original Oracle server: Allows you to restore the complete database automatically to the original Oracle server from where it was backed up.
      SBTAutoRestore1.PNG
      1. Click Restore to original Oracle server and click Finish
        Druva Phoenix prompts you with a warning message that the original database on your Oracle server will be replaced with the restored data. Click Yes on the confirmation dialog.
        Druva Phoenix terminates connections to the database on the original server host and then replaces the database with the restored database.
    2. Restore database files: Allows you to download the requested database files to the selected server and location. The database needs to be manually recovered on the server. For more details, see Recover database from the downloaded backup data.
      1. In the Destination Server list, select the Oracle server host to download the backup data to. By default, the original Oracle server host is selected where the database was backed up. When you restore a database to its original location, Druva Phoenix replaces the database on the Oracle server host with the restored database. 
      2. In the Restore Location box, browse to the location on the selected server where you want to download the backup data or type the absolute path to the restore location.
      3. Click Finish.
  13. If you selected check box(es) of the individual database element(s) to restore, Druva Phoenix provides only the Restore database files option to download the requested database files to the selected server and location. The database need(s) to be manually recovered on the required server.
    Restore_manual1.PNG
    1. In the Destination Server list, select the Oracle server host to download the backup data to. By default, the original Oracle server host is selected where the database was backed up. When you restore a database to its original location, Druva Phoenix replaces the database on the Oracle server host with the restored database. 
    2. In the Restore Location box, browse to the location on the selected server where you want to download the backup data or type the absolute path to the restore location.
    3. Click Finish

The backup data is downloaded to the location you specify. After you click Finish, Druva Phoenix generates a restore job. You can track the progress of the job by viewing the progress log. For more information, see View progress logs

Next steps

After the restore job is successful, the DBA can run RMAN scripts to fetch backup data downloaded to the restore location and recover the database on the required Oracle server host. For more information, see Recover database from the downloaded backup data.