Perform a Full Database Backup with Oracle RMAN

This guide outlines the process for performing a Full Database Backup using Zmanda Pro backupmanager.

Log in to Backupmanager

Log in to the backupmanager utility and enter the necessary information:

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

Configure Full Database Backup

Configure the options to perform a Full Database Backup of an Oracle Database.

Step 1: Run Configure Command, and When prompted, enter the Device Name as registered on the server:

$ backupmanager rman configure
config data loaded successfully
Enter the Device Name (default: VSP-ZMD-US-DEN-VM-DEVL-1T-18598): VSP-ZMD-US-DEN-VM-DEVL-1T-1859

Step 2: Follow the steps to configure a protected item for a Full Database Backup.

  1. Select Add Protected Item

Select an action?
> Add Protected Item
  Exit
  1. Enter the name of the Protected Item

Enter the Protected Item Name: prod-database

Step 3: Post Creation of a successful protected item, navigate to authentication and perform the following steps:

  1. Select Authentication from the menu items

Use the arrow keys to navigate:
[Back]
> Authentication
Scripts
Storage Information
Save
Exit
  1. Add the Database Configuration as a part of the Authentication:

Oracle RMAN Configu ration
[Back]
> Add Database Configuration

Fill in the following details:

Database Name: ORCL
Database DBID: 15763899663
Database Username: sys
Database Password:
Database Host: VSP-ZMD-US-DEN-VM-DEVL-1T-18598
Database Port: 1521
Database Service Name: ORCL
Database Role: sysdbal

Step 4: Navigate to Scripts to add a an automatic script to perform a full database backup using a RMAN Script.

Each Oracle RMAN Protected Item configuration includes a default script with a pre-configured channel. This channel prompts for storage mapping information, ensuring proper data routing during backup operations for that default script.

  1. Select Add Script option:

Script Management
[Back]
> Add Script
Select Script
  1. Enter a desired script name for the RMAN Script that backupmanager will generate, the following script will be used to perform a full database backup.

Enter script name: <script-name>
  1. Select the script type as Automatic:

Select script type ?
> Automatic
Custom
  1. Select the type of Backup the script will perform, in this instance it would be "Full Backup"

Select backup type?
> Full Backup
Level 0 Incremental Backup
Level 1 Incremental Backup
Level 1 Cumulative Incremental
  1. Configure the number of channels that would be used in the script.

Enter number of channels (1-10): <number-of-channels>
  1. Enter the same channel identifier, staging path, staging type and storage mapping for each channel to be specified in the script.

Enter identifier for channel 1: c1

Enter the staging path for channel 1: /mnt/oracte/staging

Select staging type for channel 1: ?
> local
  nfs
  
Stage Storage mapping is the storage where we backup the oracle backup pieces from each channel's staging area.
Use the arrow keys to navigate: 
 StorageVault_Local b1f79a8d-f6bf-4956-8f72-f249354ad641
> SFTPStorageTemplate bde06ccO-a461-4958-a424-990a29437384
  1. Verify the channel configurations.

  1. Select "Yes" to include archive log as part of your backup. Please ensure to have the database you are backing up in ARCHIVELOG mode if you are selecting yes.

Recommendation: It is recommended to include archive log as part of this backup.
Use the arrow keys to navigate: ↓ ↑ → ← 
Include archive log?
  > Yes
  No

Step 5: Configure Storage Vault Information

The storage vault you're setting up now will store your backup inventory. Remember to specify this same vault when initiating a restore operation later.

Select a destination
 StorageVault_Local b1f79a8d-f6bf-4956-8f72-f249354ad641
> SFTPStorageTemplate bde06ccO-a461-4958-a424-990a29437384

Step 6: Navigate to "Save" to save the configured options.

Do you want to save the configuration
> Yes
  No

Step 7: Exit the backupmanager utility.

Thank you for using the Zmanda Pro Backup Manager!

Backup

Perform the following steps to perform a Full Database Backup using Zmanda Pro Backupmanager of an Oracle Database.

1. Client-Triggered Backup

Follow these steps to perform a backup on the client machine to instantly initiate a backup.

Step 1: Initiate the Backup Command

On the client machine, execute the following command in the terminal which you have configured as part of backupmanager configuration:

backupmanager rman backup --pi-name <Protected Item Name> --script-name <Script Name>

Example:

backupmanager rman backup --pi-name prod_database --script-name <-script-name>

Step 2: Monitor Backup Progress

Once the backup is initiated, you can monitor its progress directly in the terminal. Watch for any warnings or errors during the backup process. For more information about Progress Reporting, please refer to the documentation here.

Step 3: Check Backup Report

After the backup is complete, you can review the detailed backup report on the Zmanda Pro server web portal. This report will provide comprehensive information about the backup operation.

2. Server-Triggered Backup

Follow these steps to schedule and initiate a backup from the Zmanda Pro web portal:

Step 1: Log into Zmanda Pro Web Portal

Access the Zmanda Pro web portal using your credentials.

Step 2: Navigate to Backup Configurations

Click on the "Protected Item" section under settings to view all existing backup configurations.

Step 3: Backup

Step 3.1: Schedule a Backup

  1. Navigate to the protected item configured under settings section of Zmanda Pro Server User Web portal, and click on it.

  2. Go to the "Schedule" tab within the protected item configuration.

  1. Click on the backup rule named after the script you configured, then add or modify the schedule as needed. For more information about scheduling, please refer to the documentation here.

  1. Save the backup rule and protected item settings.

Step 3.2: On Demand Server Triggered Backup

  1. In the Zmanda Pro Server Web Portal, navigate to the Backup section.

  2. Under the Run Backup modal, click on the Scheduled tab and select the schedule you wish to run as an on-demand backup.

Step 4: Monitor Scheduled Backup Execution

Once a backup is scheduled or triggered on demand, you can monitor its progress in the job logs located in the History section of the Zmanda Web User Portal. Upon successful completion, the status of the Protected Item will display as "Success." Additionally, ensure that all associated autogenerated Protected Item job logs also show a successful status.

Step 5: Review Backup Report

After the backup is complete, you can access the detailed backup report for the Protected Item on the Zmanda Pro server web portal, by accessing job report for the Main Protected Item. This report will provide comprehensive information about the backup operation.

Last updated