NetBackup™ for Oracle Administrator's Guide
- Introduction
- Installing NetBackup for Oracle
- Planning the installation of NetBackup for Oracle
- Verifying the operating system and platform compatibility
- License for NetBackup for Oracle
- NetBackup server and client requirements for NetBackup for Oracle
- Requirements for using NetBackup for Oracle in a NetBackup cluster
- About linking Oracle RMAN with NetBackup for UNIX
- Configuring RBAC for the Oracle administrator
- Managing Oracle discovery and databases
- About Oracle discovery
- Managing Oracle databases
- View and edit Oracle database details
- Associate an RMAN catalog with a database
- Remove an RMAN catalog from a database
- Activate or deactivate a database
- Remove a database or pluggable database
- Manually add a database
- Manually add an Oracle instance
- Edit Oracle instance details
- Copy a RAC instance
- Remove an Oracle instance
- Load balance Oracle RAC instances
- Managing RMAN catalogs
- Manage a Data Guard
- Managing Oracle credentials
- About Oracle credentials
- Oracle credential types in the NetBackup Credential management
- Add a credential for an Oracle database or RMAN catalog
- View the credential name that is applied to an asset
- Edit or delete a named credential
- Register credentials for an Oracle database or RMAN catalog
- Manually validate database credentials
- Configure an Oracle Wallet with RAC within NetBackup
- Configuring Oracle policies
- Preparing for NetBackup for Oracle configuration
- About Oracle Intelligent Policies (OIP)
- Create 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
- Create a Data Guard policy
- Create bpstart_notify and bpend_notify scripts for an Oracle Intelligent Policy (OIP)
- Logging the RMAN input and output on a client
- About script-based Oracle policies
- Adding a new script-based Oracle policy
- About policy attributes
- Schedule properties for Oracle script-based policies
- Script-based policy - Storage and Retention
- Add clients to a policy
- About adding backup selections to an Oracle policy
- About configuring the run-time environment
- About creating shell scripts
- 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 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 the 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
- Troubleshooting
- About troubleshooting NetBackup for Oracle
- About NetBackup for Oracle troubleshooting steps
- NetBackup debug logs and reports
- Enabling the debug logs manually (Windows) (NetBackup for Oracle)
- Enabling the debug logs manually (UNIX) (NetBackup for Oracle)
- 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 time-out 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
Oracle with Snapshot Client environment variables
You can use environment variables to change the number of streams the proxy copy session uses or to specify an alternate backup schedule.
The following list shows the variables that you can set that are specific to NetBackup for Oracle with Snapshot Client:
NB_ORA_PC_SCHED | The NetBackup for Oracle schedule NetBackup uses for a proxy copy file-based backup. (This schedule can be Full, Differential Incremental, or Cumulative Incremental backup type). For scheduled backups, this variable is passed from the scheduler. |
NB_ORA_PC_STREAMS | Specifies the number of backup streams that NetBackup starts simultaneously in each proxy copy session. When a backup starts, NetBackup groups all data files into a specified number of backup streams that are based on the file sizes. NetBackup tries to create streams of equal size. The default value for NB_ORA_PC_STREAMS is 1. Only a user can set this variable. |
For NetBackup for Oracle with Snapshot Client, the order of precedence for environment variables is the same as for standard NetBackup for Oracle. Refer to the instructions for how to configure the NetBackup and the user variables.
NetBackup for Oracle installs sample scripts in the following location:
Windows:
install_path\NetBackup\dbext\oracle\samples\rman
UNIX:
/usr/openv/netbackup/ext/db_ext/oracle/samples/rman
The following are the scripts for NetBackup for Oracle with Snapshot Client that show how to configure the required variables:
Windows: hot_database_backup_proxy.cmd UNIX: hot_database_backup_proxy.sh | This script sets the environment and calls RMAN with the appropriate command to perform a whole database proxy backup. When NetBackup runs a schedule, it sets the environment variables that NetBackup for Oracle with Snapshot Client uses. The script shows how to use the RMAN send command to pass the NetBackup for Oracle with Snapshot Client variables with a vendor-specific quoted string. |
Windows: hot_tablespace_backup_proxy.cmd UNIX: hot_tablespace_backup_proxy.sh | This script sets the environment and calls RMAN with the appropriate command to perform a tablespace proxy backup. |
If you use scripts, use the send command to pass the environment variables to the agent. The following example uses the send command to specify the values for NB_ORA_PC_SCHED and NB_ORA_PC_STREAMS:
run {
allocate channel t1 type 'SBT_TAPE';
send 'NB_ORA_PC_SCHED= sched, NB_ORA_PC_STREAMS= number';
backup proxy
(database format 'bk_%U_%t');
}For more information, see the sample scripts that are provided with the agent.