Restore an Oracle RMAN backup using Backup Manager

This guide outlines the process for performing a Restore to a New Database Instance using Backup Manager.

Login to Backup Manager

Login to backupmanager utility and enter the prompted information:

$ backupmanager login
Enter Zmanda Pro URL: <https://your-zmanda-pro-server.com>
Enter Username: your_username
Enter Password: ************

Restore

Perform the following steps to perform Restore of an Oracle Database backup taken by Zmanda Pro Backupmanager.

Step 1: Initiate the Restore Command

To restore a database from a previously taken backup, use the following command and provide the required details:

$ backupmanager rman restore --pi-name <Protected Item Name> --storage-vault <Storage Vault Name>

For example:

$ backupmanager rman restore --pi-name Dev_Sanity --storage-vault Mount

Step 2: When prompted, enter the device name. The system will display the default device name, which you can use or modify as needed:

Enter the Device Name (default: VSP-ZMD-US-DEN-VM-DEVL-IT-18872): VSP-ZMD-US-DEN-VM-DEVL-IT-18872

Step 3: Database Configuration Verification

Once the device name is entered, the system will display the current database configuration. Ensure if you are restoring the correct Database:

Database Configuration:
+-----------------------+---------------------------------+
| PROPERTY              | VALUE                           |
+-----------------------+---------------------------------+
| Database Name         | ORCLCDB                         |
| Database DBID         | 2933840609                      |
| Database Username     | SYS                             |
| Database Password     | ********                        |
| Database Host         | VSP-ZMD-US-DEN-VM-DEVL-IT-18872 |
| Database Port         | 1521                            |
| Database Service Name | orclcdb                         |
| Database Role         | SYSDBA                          |
+-----------------------+---------------------------------+

Step 4: Backup Run Information

Backupmanager will load all available backups associated with the protected item and storage vault, ready to be restored:

loading backup information......

Once loaded you will be presented with a list of available backup runs. Use the arrow keys to select the backup run you wish to restore from:

Use the arrow keys to navigate: ↓ ↑ → ←  and / toggles search
Select Backup Run
  > 2024-09-25 11-05 Incremental Level 1
  2024-09-25 11-11 Incremental Level 1
  2024-09-25 11-15 Cumulative Incremental Level 1
  2024-09-25 11-19 Cumulative Incremental Level 1
  2024-09-26 06-33 Incremental Level 1
  2024-09-26 06-50 Incremental Level 1
  2024-09-26 06-55 Cumulative Incremental Level 1
  2024-09-26 06-57 Cumulative Incremental Level 1

For any active selection of a backup run backupmanager will display information about the selected run, including the SCN and sequence details:

---------- Backup Run Info ----------
Backup Time:   2024-09-25 11-05
Restorable till SCN: 12967458
Restorable till Sequence: 668
Run ID: 0fde5690-7b2e-11ef-b973-005056b2b096
Backup Level: Incremental Level 1

Once a backup run is selected, you will be displayed with the selected backup run info

Backup Run Info :
+--------------------------------+--------------------------------------+---------------+---------------------+------------+--------+-----------+----------+
| START TIME                     | RUN ID                               | BACKUP STATUS | BACKUP LEVEL        | BACKUP SCN | THREAD | RUN TYPE  | SEQUENCE |
+--------------------------------+--------------------------------------+---------------+---------------------+------------+--------+-----------+----------+
| 2024-09-25 11:05:24.482304666  | 0fde5690-7b2e-11ef-b973-005056b2b096 | success       | Incremental Level 1 | 12967458   | 1      | automatic | 668      |
| +0000 UTC                      |                                      |               |                     |            |        |           |          |
+--------------------------------+--------------------------------------+---------------+---------------------+------------+--------+-----------+----------+

Step 5: Choose Restore Location:

• Restore to Original Directory: Restores the data to the original directory from which it was backed up.

• Restore to Custom Directory: Allows you to specify a custom directory for the restore.

Use the arrow keys to navigate: ↓ ↑ → ← 
Where do you want to restore?
  > Restore to Original Directory
  Restore to Custom Directory

For this Instance lets choose Restore to Original Directory.

Step 6: Create and Set Directory Permission:

Do you want to create the restore directory if it does not exist?
  > Yes
  No

Allow zmanda pro backupmanager to update the restore directory user/group to oracle database user/group when required? (WARNING: RMAN Cataloging feature will not work if the restore directory is not accessible by oracle database user/group)
  > Yes
  No

Step 7: Catalog Backup Pieces

Do you want to catalog all the backup pieces to the current controlfile on the target database?
  > Yes
  No

Cataloging will be applied to the current control file on the target database, post this if you are planning | | to restore the control file | | from the backup, the cataloged | | information will be lost and | | you will have to catalog again | | manually upon the restored | | control file in RMAN

Step 8: Monitor the Restore Process

Once the restore process starts, restore details and progress will be displayed:

Restore Details
===============
- Duration: 00:15
- Estimated Size: 1.44 GB
- Number of Files: 2
- Average Speed: 14.60 MB/s

Status: Restore In Progress

Progress: 219.01 MB Data Restored [==========                                        ] 20.0%

Note: If the file already exists at the restore location, the progress may show 0 bytes restored. This is normal and no action is needed.

Step 9: Post-Restore Cataloging

If you have chosen "Yes" for cataloging process, it will be run after the restore completes. Here's an example of the cataloging summary:

Catalog process completed. Summary:
- Total backup pieces unknown to the database: 2
- Total backup pieces successfully cataloged: 2

Step 10: Restore Completion

Upon successful completion, the restore locations will be displayed:

Restore location: /home/oracle/staging/pro_database/c1
Restore location: /home/oracle/staging/pro_database/c3
Restore location: /home/oracle/staging/pro_database/c2
Restore location: /home/oracle/staging/pro_database/c4
SUCCESS: Restore operation completed.