Skip to main content

How can we help you?

Druva Documentation

Restore databases

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

 

To restore Oracle databases, you can use:

  • Druva Phoenix snapshots
    You can use warm and cold type of Druva Phoenix snapshots to restore Oracle databases.
  • Existing Oracle RMAN backups on the Phoenix Backup Store

If you use Druva Phoenix snapshots, the restore procedure contains two steps:

  1. Download the Druva Phoenix snapshot as an Oracle RMAN backup on the Phoenix Backup Store
  2. Restore the Oracle RMAN backup from the Phoenix Backup Store to the Oracle instance using RMAN

You can also use existing Oracle RMAN backups on a Phoenix Backup Store backup mount to restore data on the Oracle instances. 

Snapshot types

Warm Snapshots

The warm snapshots are:

  • Created when the Phoenix Backup Store uploads the Oracle RMAN backups to the Druva Cloud and Druva Phoenix applies a time-stamp on the snapshot and turns a snapshot into a restore point
  • Downloaded to a folder on the Phoenix Backup Store from the Druva Cloud and then restored to the Oracle server using RMAN

For example, the Phoenix Backup Store turns the Oracle RMAN backups into snapshots and uploads them to the Druva Cloud for six months.

There are two possible restore options that you see when you try to restore Oracle databases:

  1. The following screenshot shows the options to restore database files if Druva Phoenix can map a database to its files. Files that are configured for backup but Druva Phoenix cannot map the files to a database are stored under the Additional Files folder. For more information about how Druva Phoenix can map files to a database in a snapshot, review the template script workflow in the Phoenix Backup Store API reference
    PBS_Restore_Option1.png
  2. The following screenshot shows the options to restore database files if the database mapping information is not available to Druva Phoenix or if it is unable to build the mapping between the database and its files:
    PBS_Restore_Option2.png

When Druva Phoenix creates a snapshot of the Oracle RMAN backup and uploads it to the Druva Cloud, it applies the time stamp to the snapshot. The time stamp is the date and time when the Phoenix Backup Store creates a snapshot of the Oracle RMAN backup, and uploads the snapshot to the cloud. You can identify and select the snapshot using its time stamp and restore the data. 

Note: You cannot delete the most-recent snapshot of the Oracle RMAN backup.

Cold snapshots

Cold snapshots are point-in-time copies of backup data older than the warm tier duration specified in the retention period. These snapshots are stored in the Amazon Glacier Deep Archive. To restore data from cold snapshots, data needs to be first retrieved from Amazon Glacier Deep Archive before a restore can be triggered. At the time of restore, data from the cold tier is retrieved, moved temporarily to the warm tier, and then restored. Once you click Restore and initiate the restoration process, the data retrieval from cold tier and its restore from the warm tier happen automatically. Warmed up data is deleted from the warm tier after 10 days.

To restore warm and cold snapshot

  1. Log in to the Phoenix Management Console.
  2. From the top menu, select the organization where you have registered the Phoenix Backup Store.
    The Organization page appears. 
  3. On the Organization page, click Protect > Oracle > Phoenix Backup Store
    The Phoenix Backup Stores page appears.
  4. In the left pane, click the Backup Mounts tab.
  5. In the Backup Mount column, select the mount (that backed up the database) that you want to restore and click Restore.
    The Restore dialog appears with the list of snapshots.
  6. In the Snapshot Viewer section, click the snapshot timestamp list to list the available warm and cold snapshots and select the snapshot. The warm and cold snapshots are listed with timestamps and serve as the restore points that you can use.
    PBS_Snapshot_Viewer.PNG
    For example, the following screenshot depicts a cold snapshot:
    PBS_Restore_ColdSnapshots.PNG
  7. In the Name column, select the required files and the database to be restored and click RestorePBSRestore_AdditionalFiles.PNG
  8. In the Restore Data dialog, provide the following:
    Field Description
    Phoenix Backup Store The store where you want to restore the Oracle RMAN backup. By default, the original Phoenix Backup Store is selected. However, you can select another registered Phoenix Backup Store.

    You cannot select the Phoenix Backup Stores that do not meet the minimum requirements. 
    Restore IP Addresses The IP addresses of Oracle servers that can access the mount on which the Oracle RMAN backup will be restored. You cannot edit this list. 
    Use non-allowlist IP addresses for restore The list of IP addresses that are not a part of the allowlist. You can enable this option and provide IP addresses of the servers that can access the mount.

    To allow multiple IP addresses, either use a comma or a wildcard. For example, if you enter 192.0.*.*, all the servers with the IP addresses starting 192.0.0.0 through 192.0.255.255 can access the Phoenix Backup Store. If you want to allow servers with specific IP addresses to access the Phoenix Backup Store, enter the IP addresses using a comma. For example, you want two servers with IP addresses 192.0.2.0 and 198.51.100.1 to access the Phoenix Backup Store. To allow access to the Phoenix Backup Store, enter 192.0.2.0, 198.51.100.1
  9. After you provide the details above, click Finish.

A restore job is triggered.  The warm snapshot is unpacked and downloaded as an Oracle RMAN backup on the Phoenix Backup Store, and you can restore it to the Oracle instance using RMAN. You can track the progress of this restore job on the Jobs page.

Restore the Oracle RMAN backup downloaded from the Druva Cloud

After you restore a cold or a warm snapshot from the Druva Cloud, the snapshot is downloaded as the Oracle RMAN backup on a folder on the Phoenix Backup Store. To get the path to the folder:

  1. Log in to the Phoenix Management Console.
  2. From the top menu, select the organization where you have registered the Phoenix Backup Store.
    The Organization page appears. 
  3. On the Organization page, click Protect > Oracle > Phoenix Backup Store
    The Phoenix Backup Stores page appears.
  4. In the left pane, click the Jobs tab. The Jobs page appears. 
    The page provides filters that you can use to identify the restore job that you want to select.
  5. Click the Job ID to get the details of the restore job.  
  6. On the Details tab, copy the path that the Destination Location field provides. The path that this field provides is the location of the folder on which the Oracle RMAN backup is downloaded. 

After the Oracle RMAN backup is downloaded to the selected Phoenix Backup Store, perform the following steps:

  1. Map the Phoenix Backup Store folder on which the Oracle RMAN backup is downloaded from the Druva Cloud to the RMAN host. The Oracle RMAN backup is downloaded to the /mnt/restores/<backupmount_name>/<restore_job_id>/data on the Phoenix Backup Store where:
    • The mount-name is the name of the mount you selected to restore.
    • Job id is the ID of the restore job. You can get the job ID from the jobs page. 
      For example, if the mount name is testmount and the restore job ID 242135, the location of the data looks like:  /mnt/restores/testmount/242135/data
  2. Connect to RMAN on the host and start the RMAN prompt on the terminal.
  3. Run the following RMAN command to set RMAN catalog to the mapped folder. For example, if the data location on the Phoenix Backup Store (/mnt/restores/testmount/242135/data) is mapped to the /local/restores/242135 folder on the RMAN host, run the following command:
    catalog start with '/local/restores/242135'
    
  4. Use RMAN commands to restore databases to the Oracle instance using the Oracle RMAN backup available in the folder. 

To delete the folder on the Phoenix Backup Store that stores the Oracle RMAN backup downloaded from the Druva Cloud, make the following DELETE request to the Phoenix Backup Store API.

curl -X DELETE http://<hostip>:9090/druva-phoenix/v1/mounts/<mountname>/restores/<jobidwithoutslash>

For example:

curl -X DELETE http://192.0.2.1:9090/druva-phoenix/v1/mounts/testmount/restores/242135

For more information, see Phoenix Backup Store REST API reference.  

Restore an existing Oracle RMAN backup on a Phoenix Backup Store mount

To restore databases, you can use the existing Oracle RMAN backups on a backup mount of a Phoenix Backup Store.

To get the path to the mount on the Phoenix Backup Store, run the phoenix_get_mount_details.sh script on the Linux RMAN host with the IP address of the Phoenix Backup Store server and the mount name as the parameters. For example:

./phoenix_get_mount_details.sh 192.0.2.1 testmount

The output of the phoenix_get_mount_details.sh script is the path to the backup mount. Sample output of the RMAN script:

Remote mountpath is 192.0.2.1:/Phoenix/testmount/oracle_data
Mount options : rw,user,retrans=5,timeo=1200

You can use the details that the script provides to map the backup mount to the Linux RMAN host. To map the backup mount on a Windows RMAN host, see Map a network drive [External link to Microsoft documentation]

After you map the backup mount to the RMAN host, run the RMAN commands to restore databases using the Oracle RMAN backups on the backup mount. 

For more information about RMAN and Oracle database backup and recovery, see Database Backup and Recovery User's guide [External link to Oracle documentation]