Skip to main content
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:

  • Phoenix snapshots
    The types of Phoenix snapshots that you can use to restore Oracle databases are categorized as:
    • Warm snapshots
    • Cold snapshots
  • Existing Oracle RMAN backups on the Phoenix Backup Store

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

  1. Download the 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. 

Warm snapshots

The warm snapshots are:

  • Created when the Phoenix Backup Store uploads the Oracle RMAN backups to the Phoenix Cloud and Phoenix applies a time-stamp on the snapshot and turns a snapshot into a restore point
  • Restore points that are less than 90 days old
  • Downloaded to a folder on the Phoenix Backup Store from the Phoenix 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 Phoenix Cloud for six months. The warm snapshots are the snapshots that were uploaded in the last 90 days and retained in the Phoenix Cloud according to the retention policy. The snapshots that are older than 90 days are called Cold snapshots.

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

  1. Below image shows the options to restore database files if Phoenix can map a database to its files. Files that are configured for backup but Phoenix cannot map the files to a database are stored under the Additional Files folder. For more information about how Phoenix can map files to a database in a snapshot, review the template script workflow in the Phoenix Backup Store API reference
    oracle_flr.png
  2. Below image shows the options to restore database files if the database mapping information is not available to Phoenix or if Phoenix is unable to build the mapping between the database and its files:
    oracle_flr_2-1.png
  3. Below image shows the options to restore the snapshot if it was created using an older version of the Phoenix Backup Store. Ensure that you update your Phoenix Backup Store to the latest available version.  You cannot restore individual files from a snapshot created using older versions of the Phoenix Backup Store:
    oracle_flr_3.png

When Phoenix creates a snapshot of the Oracle RMAN backup and uploads it to the Phoenix 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. 

To restore a warm snapshot

  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.
  4. On the Oracle page, select the Backup Mounts tab.
  5. Under the Backup Mounts tab, select the mount that backed up the database that you want to restore and then click Restore.
    The Restore dialog appears with the list of snapshots.
  6. In the left pane, expand the Warm list to see all the warm snapshots. The warm snapshots are listed with time stamps and serve as the restore points that you can use.
  7. Choose a snapshot you want to use on the left pane.
  8. In the right pane, select what you want to restore. For example:
    •  You can either select all files in the snapshot 
      oracle_flr.png
    • Or, you can click on the options in the right pane and select specific files under a particular folder or database
      Oracle_flr_workflow.png
  9. Select the files and then click Restore
  10. 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 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-whitelisted IP for restore The option to add IP addresses that are not a part of the whitelist. 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
  11. After you provide the details above, click Restore. 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.

Cold snapshots

The cold snapshots are:

  • Created when the Phoenix Backup Store uploads the Oracle RMAN backups to the Phoenix Cloud 
  • The restore points that are more than 90 days old
  • Defreezed before they can be used as restore points
  • Downloaded to a folder on the Phoenix Backup Store from the Phoenix 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 Phoenix Cloud for six months. The snapshots that are older than 90 days and retained in the Phoenix Cloud based on the retention policy are called Cold snapshots. 

When Phoenix creates a snapshot of the Oracle RMAN backup and uploads it to the Phoenix 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. When a snapshot is stored on the cloud with a time stamp, it serves as a restore point. You can identify and select the snapshot using its time stamp and restore the database. 

Before you can use a Cold snapshot, you have to defreeze it. After you defreeze a snapshot, it listed as a Thawed snapshot. Select the Thawed snapshot to restore the Oracle RMAN backup.

To defreeze a cold snapshot

  1. Log on to 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.
  4. On the Oracle page, select the Backup Mounts tab.
  5. Under the Backup Mounts tab, select the mount that backed up the database that you want to restore and then click Restore.
    The Restore dialog appears with the list of snapshots.
  6. In the left pane, expand the Cold list to see all the cold snapshots. 
  7. Select the cold snapshot you want to use and click Defreeze Snapshot

It may take a while before the cold snapshot is available as a thawed snapshot. You receive an email from Druva once the thawed snapshot is available to use. The email also provides information about the period for which the snapshot will remain in the thawed state. The snapshot reverts to the cold state after the period specified in the email is over. 

To restore a cold snapshot

  1. Log on to 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.
  4. On the Oracle page, select the Backup Mounts tab.
  5. Under the Backup Mounts tab, select the mount that backed up the database that you want to restore and then click Restore.
    The Restore dialog appears with the list of snapshots.
  6. In the left pane, expand the Thawed list to see all the thawed snapshots. 
  7. Choose a snapshot you want to use on the left pane.
  8. In the right pane, select what you want to restore. For example:
    •  You can either select all files in the snapshot 
      oracle_flr-cold-1.png
    • Or, you can click on the options in the right pane and select specific files under a particular folder or database
      Oracle_flr_workflow-thawed-1.png
  9. Select the files and then click Restore
  10. 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 The IP addresses of Oracle servers that can access the folder on which the Oracle RMAN backup will be restored. You cannot edit this list. 
    Use non-whitelisted IP for restore The option to add IP addresses that are not a part of the whitelist. You can enable this option and provide IP addresses of the servers that can access the Phoenix Backup Store.

    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
  11. After you provide the details above, click Restore. The cold 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.

Restore the Oracle RMAN backup downloaded from the Phoenix Cloud

After you restore a cold or a warm snapshot from the Phoenix 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. In the Phoenix Management Console, click Jobs on the top menu-bar.
  2. Select the Oracle tab on the Jobs page.
  3. Click the Job ID under the Oracle tab to see the job details. The tab provides filters that you can use to identify the restore job that you want to select. Click the Job ID to get the details of the restore job. The Job Details dialog appears. 
  4. 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 Phoenix 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 Phoenix Cloud, make the following DELETE request to the Phoenix Backup Store API.

curl -X DELETE http://<Phoenix_Backup_Store_IP>:9090/mnt/restores/<backupmount_name>/<restore_job_id>/data

For example:

curl -X DELETE http://192.0.2.1:9090/mnt/restores/testmount/242135/data

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]