To restore Oracle databases, you can use:
- Phoenix snapshots
The type of Phoenix snapshots that you can use to restore Oracle databases is categorized as Warm snapshots.
- Existing Oracle RMAN backups on the Phoenix Backup Store
If you use Phoenix snapshots, the restore procedure contains two steps:
- Download the Phoenix snapshot as an Oracle RMAN backup on the Phoenix Backup Store
- 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.
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
- 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.
There are three possible restore options that you see when you try to restore Oracle databases:
- 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.
- 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:
- 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:
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.
Note: You cannot delete the most-recent snapshot of a virtual machine.
To restore a warm snapshot
- Log in to the Phoenix Management Console.
- On the menu bar, click All Organizations, and select the required organization from the drop-down list.
- On the menu bar, click Protect > Oracle.
- On the Oracle page, select the Backup Mounts tab.
- 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.
- 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.
- Choose a snapshot you want to use on the left pane.
- In the right pane, select what you want to restore. For example:
- Select the files and then click Restore.
- 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 18.104.22.168 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.
- 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.
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:
- In the Phoenix Management Console, click Jobs on the top menu-bar.
- Select the Oracle tab on the Jobs page.
- 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.
- 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:
- 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
- Connect to RMAN on the host and start the RMAN prompt on the terminal.
- 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'
- 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://<hostip>:9090/druva-phoenix/v1/mounts/<mountname>/restores/<jobidwithoutslash>
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].