NetBackup™ for Oracle Administrator's Guide
- Introduction
- NetBackup for Oracle QuickStart
- Installing NetBackup for Oracle
- Verifying the operating system and platform compatibility
- NetBackup server and client requirements for NetBackup for Oracle
- 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
- Configuring RBAC for the Oracle administrator
- Managing Oracle instances and databases
- Managing Oracle credentials
- Configuring Oracle policies
- Preparing for NetBackup for Oracle configuration
- 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 primary server behavior
- Instances and databases tab
- Backup Selections tab
- Oracle tab
- Logging the RMAN input and output on a client
- 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
- Managing Oracle RAC
- 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 Windows Server Failover Cluster (WSFC)
- Oracle cloning
- NetBackup Copilot for Oracle
- About Oracle Copilot
- Configuring an OIP using a share on the NetBackup appliance (Oracle Copilot)
- Creating an instant recovery point from an Oracle Copilot image (NetBackup Appliance share)
- Deleting an instant recovery point for Oracle Copilot instant recovery
- Configuring an OIP using universal shares (Oracle Copilot)
- Managing 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 or instant access mount
- About restoring from a data file copy to ASM storage using RMAN
- Oracle Copilot with instant access
- Prerequisites when you configure an instant access Oracle database
- Things to consider before you configure an instant access mount point
- Backing up an Oracle database using Oracle Copilot policy with a universal share
- Configure an instant access mount
- View the livemount details of an instant access mount
- Configuring Auto Image Replication for Oracle instant access backups
- Delete an instant access mount
- NetBackup for Oracle terms
- Frequently asked questions
- 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
- Creating an SLP to import the Oracle backups to NetBackup on Flex WORM
- Uninstalling the NetBackup Dedupe Direct for Oracle plug-in
- Other Oracle configuration
- 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
- Error: Unable to re-create online log
- 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
Configuring an Oracle Intelligent Policy using Replication Director
Use the following procedure to configure an Oracle snapshot policy that uses Replication Director. This procedure uses the Oracle Intelligent Policy, which makes configuration easier.
To create an Oracle Intelligent Policy
- In the web UI, select Protection > Policies.
- Click Add.
- Select the Attributes tab.
- Provide a unique name for the policy.
- The following items are specific to creating an Oracle policy for snapshots with Replication Director:
Policy type
For NetBackup to perform Oracle backups, select Oracle. An Oracle tab appears.
Policy storage
Oracle combines snapshots (proxy) and stream-based backups as part of the same backup. The storage that is indicated here is used for the stream-based part of the Replication Director backup.
Select a storage lifecycle policy that is configured to contain the stream-based (non-snapshot) part of the database backup. The storage must use a storage lifecycle policy that is configured for non-snapshot backups.
Use Replication Director
Enable Use Replication Director to automatically select other options that Replication Director requires:
Perform snapshot backups: Ensures that the policy creates snapshots of the disk array.
Retain snapshots for Instant Recovery or SLP management: Ensures that the policy retains the snapshot after the backup completes.
Snapshot options button
Snapshot Type
Auto (default): The OpenStorage partner uses the best snapshot technology available to that partner to create the snapshot.
Differential: The OpenStorage partner creates a snapshot that is completely dependent on the source. This parameter is based on copy-on-write technology. The device creates a cache object to maintain the original blocks of the snapshot when the blocks are modified.
Plex: The OpenStorage Partner creates a snapshot that is completely independent of the source snapshot. This option is based on mirror-break-off technology. When a mirror device is attached to the source, the contents of the mirror device is exactly the same as the source device. When the relationship is broken between the two, the mirror device is separated from the source. The mirror device acts as a point-in-time copy.
Clone: The OpenStorage Partner creates an independent copy of the volume. The copy process can take some time as the entire copy must be complete. The snapshot that is created is independent of the source.
Maximum Snapshots
Sets the maximum number of snapshots to be retained at one time.
The default setting is one. Choose the number of snapshots that is appropriate for your environment. Note that the maximum number of snapshots on a NetApp volume is 255.
When the maximum is reached, snapshot rotation occurs: The next snapshot causes the oldest to be deleted.
Managed by SLP retention is automatically selected if the Fixed or the Expire after Copy retention is currently selected in the SLP.
- Select the Schedules tab. Create one schedule:
Type of backup: Select Full Backup. The Full Backup is used for both the snapshot (proxy) part of the database and the non-snapshot (stream-based) part of the Oracle database.
The Oracle Intelligent Policy does not support the snapshot of an Archived Redo Log Backup. To take a snapshot of the archived redo logs, use the script-based Oracle policy method.
Note:
Unless creating Block Level Incremental (BLI) backups, always select Full Backup to create snapshots of the Oracle database.
Override policy storage selection: Enable and select the SLP that is configured for snapshot replication. (A snapshot SLP is one in which the first operation is a snapshot operation.) This option must be enabled so that the schedule storage overrides the policy storage with a snapshot SLP.
Retention: The retention for the streamed data is based on the non-snapshot SLP that was indicated as the Policy storage in Step 5.
The non-snapshot SLP specified on the policy storage in Step 5 determines the retention for the streamed data.
The snapshot SLP that is specified as the schedule storage (Override policy storage selection) determines the retention for the snapshot data.
Click Add to save the schedule.
- Select the Instances and databases tab and specify the instances to back up. The policy must include at least one instance. To continue to use the Oracle Intelligent Policy method, select either Protect instances or Protect instance groups.
- Select the Backup selections tab. Select the parts of the database to back up. Note that the selection applies to all listed instances.
The following can be selected for the policies that use Replication Director:
Whole database: Backs up the entire database (default).
Partial database - Tablespaces: Backs up the tablespaces.
Partial database - Datafiles: Backs up the data files.
Fast Recovery Area (FRA): Do not select for a policy that uses Replication Director.
Database backup shares: Do not select for a policy that uses Replication Director.
Whole Database - Datafile Copy Share: Do not select for a policy that uses Replication Director.
Note:
If you back up the partial database, and later want to perform a Point-in-time rollback restore, make sure that you select all of the tablespaces or data files from a partition in the Backup selections.
For copy-back restores, this step is not a requirement.
- Select the Oracle tab to configure Oracle RMAN properties.
- When the policy configuration is complete, click Create.