Managing Oracle Backups and Restores Using Hybrid File Store

Updated

You can use Hybrid File Store as a repository for your Oracle backups.

After you perform the initial Hybrid File Store configuration, you can mount the Hybrid File Store share on the Oracle client, and then perform backup and restore operations by using the RMAN command line interface.

The Commvault solution supports the standard RMAN interface. Examples are provided. Database administrators can configure the RMAN backup and restore commands as long as the syntax meets the Oracle syntax. For more information, see the Oracle summary of RMAN commands, Summary of RMAN Commands.

Backups

You can perform the following backups:

Full

Incremental

Partial

Perform all backups from the command line in the Hybrid File Store mount path by using the Oracle RMAN command. Database administrators can configure the RMAN commands.

Before You Begin

  1. If you have not already done so, perform the Hybrid File Store configuration. For more information, see Getting Started with Hybrid File Store.

  2. Mount the Hybrid File Store share on the Oracle client. The Oracle backup will be stored on this share.

Full Backup

  • On the command line, type the following command:

    run {

    allocate channel oem_disk_backup1 device type disk;

    allocate channel oem_disk_backup2 device type disk;

    allocate channel oem_disk_backup3 device type disk;

    allocate channel oem_disk_backup4 device type disk;

    BACKUP FORMAT '<nfs_object_store_mounted_path>/<some_RMAN_FORMAT>' DATABASE PLUS ARCHIVELOG FORMAT '/<nfs_object_store_mounted_path>/<some_RMAN_FORMAT>';

    }

    EOF

    where:

    DATABASE: The database that you want to back up.

    nfs_object_store_mounted_path: The Hybrid File Store mount path where the backup will be stored.

    some_RMAN_FORMAT: The RMAN pattern to use for backup piece names.

Incremental Backup

  • On the command line, type the following command:

    run {

    allocate channel oem_disk_backup1 device type disk;

    allocate channel oem_disk_backup2 device type disk;

    allocate channel oem_disk_backup3 device type disk;

    allocate channel oem_disk_backup4 device type disk;

    BACKUP INCREMENTAL_LEVEL=1 FORMAT '<nfs_object_store_mounted_path>/<some_RMAN_FORMAT>' DATABASE PLUS ARCHIVELOG FORMAT '/<nfs_object_store_mounted_path>/<some_RMAN_FORMAT>';

    }

    EOF

    where:

    DATABASE: The database that you want to back up.

    nfs_object_store_mounted_path: The Hybrid File Store mount path where the backup will be stored.

    some_RMAN_FORMAT: The RMAN pattern to use for backup piece names.

Restores

You can perform any type of RMAN restore including the following types:

  • Full Database

  • Table-level for Oracle 12c

  • Partial (tablespaces or datafile)

  • Cross-machine

  • Duplicate

  • Image copy

Perform all restores from the command line in the Hybrid File Store mount path by using the Oracle RMAN commands.

Before you perform the restore operation, mount the share that contains the Oracle backup.

Before You Begin

Mount the Hybrid File Store share that contains the Oracle backup on the Oracle client. If the backup is not on your current share, you might need to contact the administrator so that they can create a point-in-time share that contains the Oracle backup.

Full Database Restore

  • On the command line, type the following command:

    run {

    allocate channel oem_disk_backup1 device type disk;

    allocate channel oem_disk_backup2 device type disk;

    allocate channel oem_disk_backup3 device type disk;

    allocate channel oem_disk_backup4 device type disk;

    restore database;

    recover database;

    }

    where:

    DATABASE: The database that you want to restore.

Partial Database Restore

  • On the command line, type the following command:

    run {

    allocate channel oem_disk_backup1 device type disk;

    allocate channel oem_disk_backup2 device type disk;

    allocate channel oem_disk_backup3 device type disk;

    allocate channel oem_disk_backup4 device type disk;

    restore (tablespace 'FOR_CATALOG' )

    recover tablespace 'FOR_CATALOG' ;

    }

    where:

    tablespace: The tablespace that you want to restore.

Duplicate a Database

Perform a backup-based duplicate database from Hybrid File Store. Perform the operation with or without a connection to the target database.

  • On the command line, type the following command:

    run {

    allocate channel oem_disk_backup1 device type disk;

    allocate channel oem_disk_backup2 device type disk;

    allocate channel oem_disk_backup3 device type disk;

    allocate channel oem_disk_backup4 device type disk;

    duplicate target database to <destination_database>

    }

    where:

    destination_database: The duplicate database

Image Copy

  • On the command line, type the following command:

    run {

    allocate channel ch1 type disk format '<nfs_object_store_mounted_path>/<some_RMAN_FORMAT>';

    allocate channel ch2 type disk format '<nfs_object_store_mounted_path>/<some_RMAN_FORMAT>';

    backup incremental level 1 for recover of copy with tag ‘MERGE_TAG’ database reuse;

    recover copy of database with tag ‘MERGE_TAG’;

    release channel ch1 ;

    release channel ch2 ;

    }

    where:

    DATABASE: The database that you want to copy.

    MERGE_TAG: The backup tag for the copy.

    nfs_object_store_mounted_path: The Hybrid File Store mount path that contains the Oracle backup.