Loading...

Managing Oracle Backups and Restores Using NFS ObjectStore

You can use NFS ObjectStore as a repository for your Oracle backups.

After you perform the initial NFS ObjectStore configuration, you can mount the NFS ObjectStore 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 NFS ObjectStore 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 NFS ObjectStore configuration. For more information, see Getting Started with NFS ObjectStore.
  2. Mount the NFS ObjectStore 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 NFS ObjectStore 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 NFS ObjectStore 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 NFS ObjectStore 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 NFS ObjectStore 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 NFS ObjectStore. 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 NFS ObjectStore mount path that contains the Oracle backup.

Last modified: 7/17/2018 8:29:03 PM