NetBackup™ for Oracle Administrator's Guide

Last Published:
Product(s): NetBackup (10.1.1)
  1. Introduction
    1.  
      About NetBackup for Oracle
    2.  
      NetBackup for Oracle features
    3.  
      NetBackup for Oracle terminology
    4.  
      NetBackup for Oracle operation using the Oracle Intelligent Policy
    5.  
      Logging the RMAN input and output on a client
    6.  
      NetBackup for Oracle operation using a script-based policy
    7.  
      About Oracle RMAN
    8.  
      About the Oracle recovery catalog
  2. NetBackup for Oracle QuickStart
    1.  
      Installing NetBackup for Oracle
    2.  
      Registering Oracle database instances
    3.  
      Creating an Oracle database instance group
    4.  
      Creating an Oracle policy
  3. Installing NetBackup for Oracle
    1.  
      Verifying the operating system and platform compatibility
    2.  
      NetBackup server and client requirements
    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. Oracle policy configuration
    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. Instance management for an Oracle Intelligent Policy (OIP)
      1.  
        About the NetBackup Discovery Service
      2.  
        Viewing the Oracle database instance repository
      3.  
        Manually adding an Oracle database instance to the repository
      4.  
        Registering an Oracle database instance
      5.  
        About Oracle database instance groups
      6.  
        Adding an instance to an instance group
      7.  
        Automatic Registration of an instance group
      8.  
        About instance actions
    3. 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 master server behavior
      7.  
        Instances and Databases tab
      8.  
        Backup Selections tab
      9.  
        Oracle tab
      10.  
        About using a NetBackup appliance share for Oracle backups (Oracle Copilot)
      11.  
        Configuring an OIP using a share on the NetBackup appliance (Oracle Copilot)
      12. 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
    4. 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 in the NetBackup Administration Console
      7. About configuring the run-time environment
        1.  
          About the Oracle RMAN environment
        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
    5.  
      Configuring the logon account for the NetBackup Client Service for NetBackup for Oracle
    6.  
      Testing configuration settings for NetBackup for Oracle
  5. 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 master 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 Microsoft Windows cluster environment
      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
    9.  
      Creating an instant recovery point from an Oracle Copilot image
    10.  
      Deleting an instant recovery point for Oracle Copilot instant recovery
    11.  
      Creating an instant access mount from an Oracle Copilot universal share image
    12.  
      Cleaning up the Oracle Copilot share after point in time restore of database
    13.  
      Single-step restore to ASM storage from an Oracle Copilot recovery point
    14.  
      About restoring from a data file copy to ASM storage using RMAN
  6. 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
  7. 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.  
        Replicating the images to the WORM storage server in Flex Appliance
    6.  
      Uninstalling the NetBackup Dedupe Direct for Oracle plug-in
  8. 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.  
      Minimizing timeout failures on large database restores
    13.  
      Minimizing the loading and unloading of tapes for database backups
    14.  
      Enabling the debug logs manually for NetBackup Dedupe Direct for Oracle plug-in
  9. 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
  10. 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
  11. 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
  12. 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
      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
  13. Appendix E. Register authorized locations
    1.  
      Registering authorized locations used by a NetBackup database script-based policy

Instances and Databases tab

Use the Instances and Databasese tab to select instances, instance groups, RAC databases, or the clients that the Oracle Intelligent Policy is scheduled to back up. Until you select items the first time for this policy, the panel is blank. Click New to display another panel that lists all the possible instances, instance groups, or clients.

If you add a new Oracle policy or change an existing Oracle policy, this tab appears along the top of the policy configuration dialog.

You cannot mix instances and instance groups in this list. If you select instances for a policy, then you want to select an instance group, the instances you select are deleted from the list.

The Instances and Databases tab displays all the instances or instance groups that the Oracle policy is scheduled to back up. If you add a new Oracle policy or change an existing Oracle policy, this tab is one of several tabs that appear along the top of the dialog. Click Instances to display three possible categories of items:

  • Protect Instances and Databases (OIP option). This panel displays all instances that you have selected to back up for this policy. To add new instances to this list, click New. A Select Instances panel appears that displays all registered instances. Click the check box next to the instance or instances that you want to add to the list. Instances that are already selected and in the list have their check boxes checked. If an instance does not appear in this panel because it is unregistered, you can register that instance and add it to the policy later.

    The instance selection does not take effect until you click OK.

    Table: Instances and Databases tab fields describes all the instance fields for the instances in this list.

  • Protect instance groups (OIP option). This panel displays all instance groups that you have created. To add new instances to this list, click New. A Select Instance Group panel appears that displays all instance groups that you have created. All instances that are a part of an instance group at backup time are backed up. To add an instance group to the list of groups that are displayed on this panel, click New.

    To see what instances are backed up if the policy is run for an instance group, select the group from the list, then click Preview Instances. A panel appears that shows a list of all the registered instances in the group to be backed up.

  • Clients for use with scripts (Non-OIP option). This option is not for use with OIP. If you want to use the client with scripts method of configuring an Oracle policy instead of the new instance method, select Clients for use with scripts. If you select this option, the existing backup selections and instances or instance group are erased. Also, the Options tab and the Instances and Databases tab are removed, because those options must now be set in the RMAN script that the user supplies.

  • Protect RAC databases. This option displays all RAC databases that you have selected to backup for this policy. If the panel does not display any RAC databases, click Add new in the web UI to add a RAC to this policy.

Table: Instances and Databases tab fields

Field

Description

Instance Name

The selection at the top of the panel determines the listing in the panel window.

  • Protect Instances and Databases displays all individual instances that you have chosen for this Oracle policy.

  • Protect instance groups displays all the instance groups that you have created for this policy.

  • Clients for use with scripts displays all clients that you have selected for this policy. Click New to add more clients to this list.

Database Name

The name of the selection that is referenced for this policy. The Backup Selections tab defines what is backed up for the selections. This column only appears when you select Protect Instances and Databases. The Database Name can reference:

  • A keyword that represents the entire instance: $INSTANCE

  • Single or multiple PDBs

State

Active - DB is backed up. Done in the host properties application.

Host

Specifies the host where the Oracle database resides.

OS Type

Specifies the operating system of the host. Valid values are Windows and UNIX.

ORACLE_HOME

The file path of the Oracle home directory where the instance resides.

Instance Group

Specifies the Oracle database instance group name that this instance is part of. This field is blank if the instance does not belong to an instance group.

Registered

Specifies the date and time when a user gave the instance a set of credentials. This field is blank if the instance has not been given credentials.

More Information

Oracle tab

Backup Selections tab