NetBackup™ for Oracle Administrator's Guide

Last Published:
Product(s): NetBackup (10.3.0.1, 10.3)
  1. Introduction
    1.  
      About NetBackup for Oracle
    2.  
      NetBackup for Oracle features
  2. NetBackup for Oracle QuickStart
    1.  
      Install NetBackup for Oracle
    2.  
      Register Oracle database instances
    3.  
      Add an Oracle database instance group
    4.  
      Create an Oracle policy
  3. Installing NetBackup for Oracle
    1.  
      Verifying the operating system and platform compatibility
    2.  
      NetBackup server and client requirements for NetBackup for Oracle
    3.  
      Requirements for using NetBackup for Oracle in a NetBackup cluster
    4.  
      License for NetBackup for Oracle
    5.  
      About accurate licensing for Oracle
    6. About linking Oracle RMAN with NetBackup for UNIX
      1.  
        Verifying environment variables and shutting down Oracle
      2. Linking Oracle RMAN with NetBackup on UNIX platforms
        1.  
          Manually linking AIX (64-bit)
        2.  
          Manually linking HP Itanium (64-bit)
        3.  
          Manually linking Linux x86 (64-bit)
        4.  
          Manually linking IBM pSeries or zSeries
        5.  
          Manually linking Solaris x86 (64-bit)
        6.  
          Manually linking Solaris SPARC (64-bit)
  4. Configuring RBAC for the Oracle administrator
    1.  
      RBAC roles for the Oracle administrator
  5. Managing Oracle instances and databases
    1. About Oracle discovery
      1.  
        Configure discovery of Oracle clients
    2. Managing Oracle instances
      1.  
        Viewing the Oracle repository
      2.  
        Register an Oracle database instance
      3.  
        Manually add an Oracle instance
      4.  
        Manually discover instances
      5.  
        Edit Oracle instance details
      6.  
        Automatically register new instances with an instance group
      7.  
        Remove an Oracle instance
    3. Manage Oracle databases and pluggable databases
      1.  
        View Oracle database details
      2.  
        View pluggable database details
    4. About Oracle database instance groups
      1.  
        Add an instance to an instance group
    5.  
      Clean up Oracle instance and databases
    6.  
      Authorizing a DBA to register instances or instance groups with the nboraadm command
  6. Managing Oracle credentials
    1.  
      About Oracle credentials
    2.  
      Oracle credential types in the NetBackup Credential Management (CMS)
    3.  
      Add a credential to use for cloning an Oracle database
    4.  
      Edit or delete a named credential
    5.  
      Manage credentials for an instance or an Oracle RAC database
  7. Configuring Oracle policies
    1. Preparing for NetBackup for Oracle configuration
      1.  
        About Oracle policy configuration
      2.  
        Oracle Home User permissions when NetBackup SAN Client is used
      3.  
        Oracle backup policy types
      4.  
        Configuring the Maximum jobs per client
    2. About Oracle Intelligent Policies (OIP)
      1.  
        Creating an Oracle Intelligent Policy (OIP)
      2.  
        Oracle database upgrade effect on Oracle Intelligent Policies
      3.  
        Configuring NetBackup for Oracle automatic backup schedules
      4.  
        About NetBackup for Oracle schedule properties using Oracle Intelligent Policy
      5.  
        Oracle Intelligent Policy - Storage and Retention
      6.  
        About Oracle Intelligent Policy primary server behavior
      7.  
        Instances and databases tab
      8.  
        Backup Selections tab
      9.  
        Oracle tab
      10.  
        Logging the RMAN input and output on a client
    3. About script-based Oracle policies
      1.  
        Adding a new script-based Oracle policy
      2.  
        About policy attributes
      3.  
        About schedule properties
      4.  
        Script-based policy - Storage and Retention
      5.  
        Adding clients to a policy
      6. About adding backup selections to an Oracle policy
        1.  
          Adding a script to the backup selections list
      7. About configuring the run-time environment
        1.  
          About the Oracle RMAN environment in NetBackup for Oracle
        2.  
          About the environment variables set by NetBackup for Oracle
        3.  
          About the RMAN SEND command variables
        4.  
          About the bp.conf file on UNIX systems
      8. About creating shell scripts
        1.  
          RMAN shell scripts
        2. About creating RMAN scripts manually
          1.  
            About the NetBackup for Oracle sample scripts
          2.  
            Using the NetBackup for Oracle sample scripts
          3.  
            About the set duplex command
        3.  
          About storing shell scripts
    4.  
      Configuring the logon account for the NetBackup Client Service for NetBackup for Oracle
    5.  
      Testing configuration settings for NetBackup for Oracle
  8. Managing Oracle RAC
    1.  
      Oracle Real Application Clusters (RAC)
    2.  
      Add an Oracle Real Application Cluster (RAC)
    3.  
      Edit or delete an Oracle RAC database
  9. Performing backups and restores of Oracle
    1.  
      Overview of using NetBackup for Oracle
    2.  
      Maintaining the RMAN repository
    3.  
      Querying the RMAN repository
    4. About NetBackup for Oracle backups
      1.  
        Running the NetBackup for Oracle shell script
      2.  
        Running RMAN
    5.  
      Browsing backups using the bplist command
    6. Managing expired backup images
      1.  
        About preventing the direct expiration of backup images
    7. About NetBackup for Oracle restores
      1.  
        About an Oracle recovery shell script on the client
      2.  
        About catalog names with RAC and Data Guard aware intelligent policies
      3.  
        Running RMAN on the client
      4.  
        About Oracle multistream restore for proxy backup
      5. Redirecting a restore to a different client
        1.  
          Preparing the primary server for an alternate restore
        2.  
          About performing a redirected restore with RMAN
        3.  
          Example - Performing a redirected restore of Oracle
    8. Using NetBackup for Oracle in a Windows Server Failover Cluster (WSFC)
      1.  
        About backups of an Oracle clustered database on Windows
      2.  
        Bringing the database instance offline on Windows
      3.  
        Bringing the database instance online on Windows
      4.  
        User-directed backup or restore from the Windows client
  10. Oracle cloning
    1.  
      About cloning an Oracle database or a pluggable database
    2.  
      Create a custom RBAC role for Oracle cloning
    3.  
      Clone an Oracle database
    4.  
      Clone a pluggable database
    5.  
      Cloning a database from an Oracle Intelligent Policy (OIP) that is Data Guard aware
    6.  
      Additional functionality in NetBackup APIs
  11. NetBackup Copilot for Oracle
    1.  
      About Oracle Copilot
    2.  
      Configuring an OIP using a share on the NetBackup appliance (Oracle Copilot)
    3.  
      Creating an instant recovery point from an Oracle Copilot image (NetBackup Appliance share)
    4.  
      Deleting an instant recovery point for Oracle Copilot instant recovery
    5. Configuring an OIP using universal shares (Oracle Copilot)
      1.  
        Recommendations when you configure an Oracle Copilot with universal shares
      2.  
        Troubleshooting issues related to Oracle Copilot with universal shares
    6.  
      Managing an instant access mount from an Oracle Copilot universal share image
    7.  
      Cleaning up the Oracle Copilot share after point in time restore of database
    8.  
      Single-step restore to ASM storage from an Oracle Copilot recovery point or instant access mount
    9.  
      About restoring from a data file copy to ASM storage using RMAN
  12. Oracle Copilot with instant access
    1. Prerequisites when you configure an instant access Oracle database
      1.  
        Hardware configuration requirement of instant access
    2.  
      Things to consider before you configure an instant access mount point
    3.  
      Backing up an Oracle database using Oracle Copilot policy with a universal share
    4.  
      Configure an instant access mount
    5.  
      View the livemount details of an instant access mount
    6.  
      Configuring Auto Image Replication for Oracle instant access backups
    7.  
      Delete an instant access mount
    8.  
      NetBackup for Oracle terms
    9.  
      Frequently asked questions
  13. NetBackup for Oracle with Snapshot Client
    1. About NetBackup for Oracle with Snapshot Client
      1.  
        Proxy copy
      2.  
        NetBackup for Oracle stream-based operations
      3.  
        NetBackup for Oracle file-based operations
    2. How NetBackup for Oracle with Snapshot Client works
      1.  
        About the NetBackup for Oracle backup and restore operations
      2.  
        Database objects supported by advanced backup methods
      3.  
        About NetBackup multistreaming
      4.  
        RMAN multiple channels
      5.  
        Restoring data files to a new location
      6.  
        Redirecting a restore to a different client
      7.  
        Symbolic links and raw data files (UNIX)
      8.  
        Quick I/O data files (UNIX)
      9.  
        RMAN incremental backups
      10.  
        Proxy backup examples
    3. About configuring Snapshot Client with NetBackup for Oracle
      1.  
        Configuration requirements for snapshot backups with NetBackup for Oracle
      2.  
        Configuring a snapshot policy for NetBackup for Oracle
      3.  
        Configuring a snapshot policy using a share on the NetBackup appliance (Oracle Copilot)
    4. Restoring NetBackup for Oracle from a snapshot backup
      1.  
        About restoring individual files from a NetBackup for Oracle snapshot backup
      2. About NetBackup for Oracle restores of volumes and file systems using snapshot rollback
        1.  
          Performing a snapshot rollback restore using a script or RMAN command
        2.  
          Performing a NetBackup for Oracle point-in-time rollback restore from a SnapVault backup (UNIX)
    5. About configuring NetBackup for Oracle block-level incremental backups on UNIX
      1.  
        How BLI works with NetBackup for Oracle (UNIX)
      2.  
        About the Storage Checkpoint facility and NetBackup for Oracle
      3.  
        Configuration requirements for BLI backups with NetBackup for Oracle
      4. Configuring policies for BLI backups with NetBackup for Oracle
        1.  
          About the types of NetBackup for Oracle BLI backups
    6. About Snapshot Client effects
      1.  
        How Snapshot Client software affects backup types
      2.  
        How Snapshot Client software affects schedule properties
      3.  
        How Snapshot Client software affects scripts
      4.  
        Oracle with Snapshot Client environment variables
    7. About Oracle support for Replication Director
      1.  
        Configuring an Oracle Intelligent Policy using Replication Director
      2.  
        Configuring a script-based Oracle policy
  14. NetBackup Dedupe Direct for Oracle
    1.  
      About NetBackup Dedupe Direct for Oracle plug-in
    2.  
      Verifying the operating system and platform compatibility
    3.  
      Before you install NetBackup Dedupe Direct for Oracle plug-in
    4.  
      Installing NetBackup Dedupe Direct for Oracle plug-in on the Oracle database server
    5. Using NetBackup Dedupe Direct for Oracle plug-in
      1.  
        Configuring the NetBackup Dedupe Direct for Oracle plug-in
      2.  
        NetBackup Dedupe Direct for Oracle rman.cfg file parameters
      3.  
        Configuring External Certificate Authority (ECA)
      4.  
        ECA msdp_app.cfg file parameters
      5.  
        Configuring Oracle RAC
      6.  
        Disabling Oracle stream handler
      7.  
        Performing the RMAN backup directly to MSDP server
      8.  
        Performing the RMAN restore directly from the MSDP storage server
      9.  
        Creating an SLP to import the Oracle backups to NetBackup on Flex WORM
    6.  
      Uninstalling the NetBackup Dedupe Direct for Oracle plug-in
  15. Other Oracle configuration
    1.  
      Load balance Oracle RAC instances
    2.  
      Configure an Oracle Wallet with RAC within NetBackup
  16. Troubleshooting
    1.  
      About troubleshooting NetBackup for Oracle
    2.  
      About NetBackup for Oracle troubleshooting steps
    3.  
      NetBackup debug logs and reports
    4.  
      Enabling the debug logs manually (Windows)
    5.  
      Enabling the debug logs manually (UNIX)
    6.  
      About the NetBackup for Oracle log files
    7.  
      Setting the debug level on a Windows client
    8.  
      Setting the debug level on a UNIX client
    9.  
      About RMAN utility logs
    10. Troubleshooting RMAN backup or restore errors
      1.  
        Verifying the RMAN script on UNIX
      2.  
        Troubleshooting each stage of the backup or restore
    11.  
      Troubleshooting NetBackup for Oracle with Snapshot Client
    12.  
      Error: Unable to re-create online log
    13.  
      Minimizing timeout failures on large database restores
    14.  
      Minimizing the loading and unloading of tapes for database backups
    15.  
      Enabling the debug logs manually for NetBackup Dedupe Direct for Oracle plug-in
  17. Appendix A. Deduplication best practices
    1.  
      Optimizing and deduplicating stream-based and proxy copy Oracle backups
    2.  
      Oracle stream handler
    3.  
      Configuring a stream-based Oracle backup
    4.  
      Example RMAN script for a stream-based backup
    5.  
      Editing the RMAN script and configuring NetBackup for Oracle for a proxy copy backup
    6.  
      Example RMAN script for a proxy copy backup
  18. Appendix B. Snapshot Client support of SFRAC
    1.  
      About Snapshot Client support of SFRAC
    2.  
      NetBackup configuration for an SFRAC environment
    3.  
      Configuring the SFRAC environment for a backup operation
    4.  
      Performing a rollback restore in an SFRAC environment
    5.  
      Troubleshooting NetBackup in an SFRAC environment
  19. Appendix C. Script-based Block-Level Incremental (BLI) Backups without RMAN on UNIX and Linux systems
    1.  
      About script-based Block-Level Incremental (BLI) Backups without RMAN
    2.  
      About BLI backup and restore operations
    3. Verifying installation requirements for BLI backups without RMAN
      1.  
        File system and Storage Checkpoint space management
    4. Creating NetBackup policies for script-based BLI backup
      1.  
        Number of policies required for BLI backup
      2.  
        About BLI policy attributes
      3.  
        About the BLI client list
      4.  
        Backup selections list for BLI backups
      5.  
        About schedules for BLI backup policies
      6.  
        Example Oracle BLI backup policy
      7.  
        Setting the maximum jobs per client global attribute
      8.  
        About BLI backup methods
      9. Creating notify scripts for BLI backups
        1.  
          Identify the POLICY_IN_CONTROL for BLI backups
        2.  
          Oracle environment variables for BLI scripts
        3.  
          About BLI notify scripts for other policies
        4.  
          Sample setup_bli_scripts session
    5. Performing backups and restores
      1.  
        About NetBackup for Oracle agent automatic backups
      2.  
        About NetBackup for Oracle manual backups
      3.  
        Backing up Quick I/O files
      4.  
        Restoring BLI backup images
      5.  
        About NetBackup backup and restore logs
    6. About troubleshooting backup or restore errors
      1.  
        Troubleshooting stages of backup and restore operations
      2.  
        NetBackup restore and backup status codes
      3.  
        Improving NetBackup backup performance
      4.  
        About BLI backup and database recovery
  20. Appendix D. XML Archiver
    1. NetBackup for Oracle XML export and XML import
      1.  
        NetBackup for Oracle XML export and import archiving features
      2.  
        XML export archive process
      3.  
        Sequence of operation: XML export archive
      4.  
        XML import restore process
      5.  
        Sequence of operation: XML import restore
    2.  
      About the environment variables set by a user in the XML export parameter file
    3. About XML export shell scripts
      1.  
        Creating XML export scripts manually
    4. Performing an XML export archive
      1.  
        Running the NetBackup for Oracle XML export script on the client
      2.  
        Running bporaexp on the client as an Oracle user
      3.  
        Writing to a directory versus writing to a storage unit
      4.  
        About bporaexp parameters
    5.  
      Browsing XML export archives using bporaimp parameters
    6.  
      Browsing XML export archives using bplist
    7. Restoring an XML export archive
      1.  
        Running an XML import script on the client
      2.  
        Running bporaimp on the client in NetBackup for Oracle
      3.  
        About bporaimp parameters
      4. About redirecting a restore of an XML export archive to a different client
        1.  
          Redirecting a restore of an XML export archive to a new client using bporaimp
        2.  
          Example - Using bporaimp for a redirected restore
    8. Troubleshooting XML export or XML import errors
      1.  
        Checking the logs to determine the source of an error
      2.  
        Troubleshooting each stage of the XML export or XML import
    9.  
      Additional XML export and import logs
  21. Appendix E. Register authorized locations
    1.  
      Registering authorized locations used by a NetBackup database script-based policy

NetBackup for Oracle features

The following table shows the NetBackup for Oracle main features:

Table: NetBackup for Oracle features

Feature

Description

Integration with NetBackup role-based access control (RBAC)

The NetBackup web UI provides RBAC capability to control which NetBackup users can manage Oracle clone operations in NetBackup. The user does not need to be a NetBackup administrator to manage Oracle clone operations.

Oracle instance management

NetBackup automatically discovers Oracle instances in the environment. You can also perform manual discovery.

After instances are registered, the Oracle administrator can create a policy to protect Oracle assets.

Oracle DBAs can use the nboraadm command on the NetBackup client to manage instances, instance groups, and their credentials. This command is very useful in environments where the Oracle credentials are known only by the DBAs and not by the NetBackup administrators.

Oracle Intelligent Policies

The Oracle Intelligent Policy (OIP) protects multiple Oracle instances that are spread over multiple clients. You select instances for a policy from a list of instances that are automatically discovered in the NetBackup environment. OIP does not require you to know how RMAN functions or how to use scripts. The feature is instance-based and not scripting based.

Scheduling facilities

NetBackup scheduling facilities on the primary server can be used to schedule automatic and unattended Oracle backups.

This feature also lets you choose the times when these operations can occur. For example, to prevent interference with normal daytime operations, you can schedule your database backups to occur only at night.

Transparent Oracle and regular file system backup and restore operations

All backups and restores run simultaneously and transparently without any action from the NetBackup administrator. The database administrator can run database backup and restore operations through NetBackup. An administrator or any other authorized user can use NetBackup to run database backups and restores.

If you use the command line interface or scripts, you must use script-based Oracle policies. These policies use Oracle's Recovery Manager (RMAN) as if NetBackup were not present.

Centralized and networked backup operations

From the NetBackup primary server, you can schedule database backups or start them manually for any client or instance. The Oracle databases can also reside on the hosts that are different from the devices on which NetBackup stores the backups.

Recovery points

The web UI provides recovery points from which you can easily create a clone from a database or pluggable database. If instant access is configured, you can also create an instant access database from a recovery point.

Sharing the same storage units that are used for other file backups

You can share the same devices and media that are used for other backups or give Oracle exclusive use of certain devices and media. NetBackup for Oracle can use the Media Manager, disk, or Media Server Deduplication Pool (MSDP) storage units.

Compression

Compression increases backup performance over the network and reduces the size of the backup image that NetBackup writes to the storage unit.

Multiplexed backups and restores

NetBackup for Oracle lets you take advantage of NetBackup's multiplexing capabilities. Multiplexing directs multiple data streams to one backup device, thereby reducing the time necessary to complete the operation.

Parallel backup and restore operations

NetBackup for Oracle supports the parallel backup and restore RMAN capabilities. For example, you can run more than one tape device at a time for a single Oracle backup or restore. This capability reduces the time necessary to complete the operation.

Support on a NetBackup appliance for backup to an appliance share (NetBackup Copilot for Oracle)

Note:

This feature requires a NetBackup appliance that runs software version 2.7.1 or later.

Oracle Copilot enhances the Oracle Intelligent Policy by giving you options for protecting an Oracle database using a share on a NetBackup appliance. This feature gives you better control of backups when an Oracle database backup is placed in a database share by the DBA. This feature also lets you choose a database share as the destination for the first backup copy. The backup copy is a full set of database data file copies created, incrementally updated, and protected by NetBackup. You must create a share on the appliance for this option using the NetBackup Appliance Shell Menu.

Oracle backups only work on an NFS share on the NetBackup appliance.

For more information about how to set up the share, see Creating a share from the NetBackup Appliance Shell Menu in the NetBackup 52xx and 5330 Appliance Administrator's Guide.

Immediate backup for Oracle DBA

The Oracle DBA can start an immediate backup from the client using the nboraadm -immediate command. The Oracle DBA can start the backup instead of waiting for the backup to be initiated based on the NetBackup schedule. This command option is useful if the Oracle DBA wants to perform a backup before maintenance. The command must be initiated from the client where the instance resides.

Support for Container and Pluggable databases

Oracle 12c introduced the container databases (CDB) and pluggable databases (PDB). The Oracle Intelligent Policy is enhanced and allows a backup to include single or multiple PDBs.

This feature also lets you select one or more Oracle 12c instances along with non-Oracle 12c instances in OIP.

Full Oracle Real Application Clusters (RAC) support in Oracle Intelligent Policies

In the NetBackup web UI you can create an Oracle policy to support Oracle RAC. (The NetBackup Administration Console does not support an Oracle RAC policy.)

Oracle RAC load balanced backups

NetBackup can be set up to load balance the Oracle instances. Use this feature to distribute the backup load across all of the instances and to exclude specific Oracle instances from backups. This feature is not available in the NetBackup Administration Console.

NetBackup Dedupe Direct for Oracle

NetBackup Dedupe Direct for Oracle offers a lightweight plug-in for RMAN backups to MSDP storage.

The Oracle database administrator can control the whole protection and life-cycle stages without NetBackup client. It also enables client-side deduplication to minimize network traffic and improves overall backup speed.

Support for Replication Director

Replication director can be used to create snapshots of the Oracle database. The snapshots can then be replicated to other NetApp disk arrays or backup the snapshot to a storage unit. To use Replication Director, the Oracle database must exist on a NetApp NAS disk array. Replication Director is not supported on SAN storage at this time.

Oracle snapshot backups that use Replication Director are supported on UNIX and Linux platforms only.