NetBackup™ for Oracle Administrator's Guide
- Introduction
- About NetBackup for Oracle
- NetBackup for Oracle features
- NetBackup for Oracle terminology
- NetBackup for Oracle operation using the Oracle Intelligent Policy
- Logging the RMAN input and output on a client
- NetBackup for Oracle operation using a script-based policy
- About Oracle RMAN
- About the Oracle recovery catalog
- NetBackup for Oracle QuickStart
- Installing NetBackup for Oracle
- Verifying the operating system and platform compatibility
- NetBackup server and client requirements
- Requirements for using NetBackup for Oracle in a NetBackup cluster
- License for NetBackup for Oracle
- About accurate licensing for Oracle
- About linking Oracle RMAN with NetBackup for UNIX
- Oracle policy configuration
- Preparing for NetBackup for Oracle configuration
- Instance management for an Oracle Intelligent Policy (OIP)
- About the NetBackup Discovery Service
- Viewing the Oracle database instance repository
- Manually adding an Oracle database instance to the repository
- Registering an Oracle database instance
- About Oracle database instance groups
- Adding an instance to an instance group
- Automatic Registration of an instance group
- About instance actions
- About Oracle Intelligent Policies (OIP)
- Creating an Oracle Intelligent Policy (OIP)
- Oracle database upgrade effect on Oracle Intelligent Policies
- Configuring NetBackup for Oracle automatic backup schedules
- About NetBackup for Oracle schedule properties using Oracle Intelligent Policy
- Oracle Intelligent Policy - Storage and Retention
- About Oracle Intelligent Policy master server behavior
- Instances and Databases tab
- Backup Selections tab
- Oracle tab
- About using a NetBackup appliance share for Oracle backups (Oracle Copilot)
- Configuring an OIP using a share on the NetBackup appliance (Oracle Copilot)
- Configuring an OIP using universal shares (Oracle Copilot)
- About script-based Oracle policies
- Configuring the logon account for the NetBackup Client Service for NetBackup for Oracle
- Testing configuration settings for NetBackup for Oracle
- Performing backups and restores of Oracle
- Overview of using NetBackup for Oracle
- Maintaining the RMAN repository
- Querying the RMAN repository
- About NetBackup for Oracle backups
- Browsing backups using the bplist command
- Managing expired backup images
- About NetBackup for Oracle restores
- Using NetBackup for Oracle in a Microsoft Windows cluster environment
- Creating an instant recovery point from an Oracle Copilot image
- Deleting an instant recovery point for Oracle Copilot instant recovery
- Creating an instant access mount from an Oracle Copilot universal share image
- Cleaning up the Oracle Copilot share after point in time restore of database
- Single-step restore to ASM storage from an Oracle Copilot recovery point
- About restoring from a data file copy to ASM storage using RMAN
- NetBackup for Oracle with Snapshot Client
- About NetBackup for Oracle with Snapshot Client
- How NetBackup for Oracle with Snapshot Client works
- About the NetBackup for Oracle backup and restore operations
- Database objects supported by advanced backup methods
- About NetBackup multistreaming
- RMAN multiple channels
- Restoring data files to a new location
- Redirecting a restore to a different client
- Symbolic links and raw data files (UNIX)
- Quick I/O data files (UNIX)
- RMAN incremental backups
- Proxy backup examples
- About configuring Snapshot Client with NetBackup for Oracle
- Restoring NetBackup for Oracle from a snapshot backup
- About configuring NetBackup for Oracle block-level incremental backups on UNIX
- About Snapshot Client effects
- About Oracle support for Replication Director
- NetBackup Dedupe Direct for Oracle
- About NetBackup Dedupe Direct for Oracle plug-in
- Verifying the operating system and platform compatibility
- Before you install NetBackup Dedupe Direct for Oracle plug-in
- Installing NetBackup Dedupe Direct for Oracle plug-in on the Oracle database server
- Using NetBackup Dedupe Direct for Oracle plug-in
- Configuring the NetBackup Dedupe Direct for Oracle plug-in
- NetBackup Dedupe Direct for Oracle rman.cfg file parameters
- Configuring External Certificate Authority (ECA)
- ECA msdp_app.cfg file parameters
- Configuring Oracle RAC
- Disabling Oracle stream handler
- Performing the RMAN backup directly to MSDP server
- Performing the RMAN restore directly from the MSDP storage server
- Replicating the images to the WORM storage server in Flex Appliance
- Uninstalling the NetBackup Dedupe Direct for Oracle plug-in
- Troubleshooting
- About troubleshooting NetBackup for Oracle
- About NetBackup for Oracle troubleshooting steps
- NetBackup debug logs and reports
- Enabling the debug logs manually (Windows)
- Enabling the debug logs manually (UNIX)
- About the NetBackup for Oracle log files
- Setting the debug level on a Windows client
- Setting the debug level on a UNIX client
- About RMAN utility logs
- Troubleshooting RMAN backup or restore errors
- Troubleshooting NetBackup for Oracle with Snapshot Client
- Minimizing timeout failures on large database restores
- Minimizing the loading and unloading of tapes for database backups
- Enabling the debug logs manually for NetBackup Dedupe Direct for Oracle plug-in
- Appendix A. Deduplication best practices
- Optimizing and deduplicating stream-based and proxy copy Oracle backups
- Oracle stream handler
- Configuring a stream-based Oracle backup
- Example RMAN script for a stream-based backup
- Editing the RMAN script and configuring NetBackup for Oracle for a proxy copy backup
- Example RMAN script for a proxy copy backup
- Appendix B. Snapshot Client support of SFRAC
- Appendix C. Script-based Block-Level Incremental (BLI) Backups without RMAN on UNIX and Linux systems
- About script-based Block-Level Incremental (BLI) Backups without RMAN
- About BLI backup and restore operations
- Verifying installation requirements for BLI backups without RMAN
- Creating NetBackup policies for script-based BLI backup
- Number of policies required for BLI backup
- About BLI policy attributes
- About the BLI client list
- Backup selections list for BLI backups
- About schedules for BLI backup policies
- Example Oracle BLI backup policy
- Setting the maximum jobs per client global attribute
- About BLI backup methods
- Creating notify scripts for BLI backups
- Performing backups and restores
- About troubleshooting backup or restore errors
- Appendix D. XML Archiver
- NetBackup for Oracle XML export and XML import
- About the environment variables set by a user in the XML export parameter file
- About XML export shell scripts
- Performing an XML export archive
- Browsing XML export archives using bporaimp parameters
- Browsing XML export archives using bplist
- Restoring an XML export archive
- Troubleshooting XML export or XML import errors
- Additional XML export and import logs
- Appendix E. Register authorized locations
NetBackup for Oracle features
The following table shows the NetBackup for Oracle main features:
Table: NetBackup for Oracle features
Feature | Description |
|---|---|
Media and device management | All devices that the Media Manager supports are available to NetBackup for Oracle. |
Scheduling facilities | NetBackup scheduling facilities on the master 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. |
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. |
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. |
Oracle Instance management | An Oracle instance discovery service automatically polls the clients throughout the NetBackup environment every five minutes. The service collects the discovered instances in an instance repository. The user can view the instances on the NetBackup Administration Console or by using the nboraadm command. You can create the instance groups that each contain a set of instances that are registered with a common set of credentials. A default instance group can be created for the newly discovered instances that are then automatically registered into this group. You select Oracle instances and instance groups to be part of an Oracle backup policy. You can create the policy for the default instance group to make sure that all newly created instances are automatically protected. 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. |
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. |
Centralized and networked backup operations | From the NetBackup master 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. |
Graphical user interfaces | NetBackup provides the following graphical user interfaces for client users and administrators:
|
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. |
Compression | Compression increases backup performance over the network and reduces the size of the backup image that NetBackup writes to the storage unit. |
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. |
Support on a NetBackup appliance for backup to an appliance share (NetBackup Copilot for Oracle) | Note: This feature requires a NetBackup appliance running 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 | NetBackup supports Oracle RAC when you set up an Oracle policy in the NetBackup web UI. The NetBackup Administration Console does not have support for Oracle RAC policy setup. However, this manual contains all information for creating an Oracle RAC policy that applies to the policy creation in the web UI. The NetBackup Web UI Administrator's Guide contains the instructions to add an Oracle RAC. |
Oracle RAC load balanced backups | The NetBackup web UI has the ability to load balance the Oracle RAC database during a backup. The NetBackup Web UI Administrator's Guide contains the information for load balancing. |
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. |