Please enter search query.
Search <book_title>...
Veritas NetBackup™ for Oracle Administrator's Guide
Last Published:
2018-09-17
Product(s):
NetBackup (8.1.2)
- Introduction
- What's new about NetBackup for Oracle
- 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- or template-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
- About the license for NetBackup 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
- 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 (Copilot)
- Configuring an OIP using a share on the NetBackup appliance (Copilot)
- About script- or template-based Oracle policies
- Adding a new script- or template-based Oracle policy
- About policy attributes
- About backup schedules, templates, and scripts
- About schedule properties
- Script- or template-based policy - Storage and Retention
- Adding clients to a policy
- About adding backup selections to an Oracle policy
- About configuring the run-time environment
- About creating templates and shell scripts
- Starting the NetBackup Backup, Archive, and Restore interface
- RMAN templates and shell scripts
- Creating RMAN templates using the NetBackup for Oracle RMAN template generation wizard
- Creating an RMAN script from a template
- About creating RMAN scripts manually
- About storing templates
- About storing 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 Microsoft Windows cluster environment
- Creating an instant recovery point from an Oracle Copilot image
- Deleting an instant recovery point for Oracle Copilot instant recovery
- Cleaning up the Copilot share after point in time restore of database
- Single-step restore to ASM storage from a Copilot recovery point
- About restoring from a data file copy to ASM storage using RMAN
- Guided Recovery
- About OpsCenter Guided Recovery
- Setting up for Guided Recovery cloning
- Guided Recovery cloning pre-operation checks
- Performing a Guided Recovery cloning operation
- Select a Master Server dialog
- Select Source Database panel
- Select Control File Backup panel
- Destination host and login panel
- Destination Parameters panel
- Selection summary panel
- Pre-clone check panel
- Job Details panel
- Guided Recovery post-clone operations
- Troubleshooting Guided Recovery
- 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
- 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 the UNIX browser interface and wizards
- Troubleshooting NetBackup for Oracle with Snapshot Client
- Minimizing timeout failures on large database restores
- Minimizing the loading and unloading of tapes for database backups
- Delays in backup job transfer and completion
- Appendix A. Real Application Clusters
- Appendix B. Best practices for protecting Oracle RAC with NetBackup
- Oracle RAC with NetBackup best practices
- About using Templates and Oracle Intelligent Policy (OIP) with RAC
- About NetBackup for Oracle operations
- Example RAC configuration: Failover name exists and backup is not load balanced
- Example RAC configuration: Failover name exists and backup is load balanced
- Example RAC configuration: Failover name is not available and backup is not load balanced
- Example RAC configuration: Failover name is not available, and backup is load balanced, one policy with custom script
- Example RAC configuration: Failover name is not available and backup is load balanced, simple script with manual policy failover
- Image catalog configuration for RAC
- Configuring the appliance within a RAC environment
- Appendix C. Deduplication best practices
- Appendix D. Snapshot Client support of SFRAC
- Appendix E. 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 F. 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 templates and 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 G. Register authorized locations
Cleaning up the Copilot share after point in time restore of database
After a point in time restore of an Oracle database, RMAN can leave files from the previous database incarnations on a Copilot share. NetBackup does not automatically clean up the files from the previous database incarnation. This procedure describes how to manually clean up the share using RMAN.
Note:
The functionality for cleaning up a Copilot share is not in the GUI. This feature is command line option only.
To clean up the Copilot share
- Open a command prompt on the NetBackup client.
- Set the NLS DATE_FORMAT to display hours, minutes, and seconds.
UNIX:
NLS_DATE_FORMAT=DD-MON-YY_HH24:MI:SS export NLS_DATE_FORMAT
Windows:
set NLS_DATE_FORMAT=DD-MON-YY_HH24:MI:SS
- Log into RMAN and if NetBackup uses the RMAN catalog, it is required to log in to the catalog.
- Use the RMAN> list incarnation of database; command to find the
Reset Timefor the current incarnation.Example:
List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 10046 10054 ORACLEC2 3019371157 PARENT 1 11-SEP-14_08:40:48 10046 10047 ORACLEC2 3019371157 PARENT 2233668 27-APR-17_10:23:22 10046 11551 ORACLEC2 3019371157 CURRENT 2323198 28-APR-17_10:41:37
- Use the list backup summary completed before "to_date()" device type disk; command to find all the backup pieces from the previous incarnation by using the reset time ("to_date()" must match NLS_DATE_FORMAT).
Example:
RMAN> list backup summary completed before "to_date('28-APR-17_10:41:37', 'DD-MON-YY_HH24:MI:SS')" device type disk; List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- ------------------ ------- ------- ---------- --- 10192 B F A DISK 27-APR-17_10:42:59 1 1 NO TAG20170427T104257 10193 B F A DISK 27-APR-17_13:16:37 1 1 NO TAG20170427T131636 10194 B F A DISK 27-APR-17_13:16:55 1 1 NO TAG20170427T131654 10195 B F A DISK 27-APR-17_13:28:52 1 1 NO TAG20170427T132851 10196 B F A DISK 27-APR-17_13:29:08 1 1 NO TAG20170427T132906 10197 B F A DISK 27-APR-17_14:00:31 1 1 NO TAG20170427T140031 10198 B F A DISK 27-APR-17_14:00:43 1 1 NO TAG20170427T140043 10199 B F A DISK 27-APR-17_14:07:31 1 1 NO TAG20170427T140730 10200 B F A DISK 27-APR-17_14:07:48 1 1 NO TAG20170427T140747 10759 B A A DISK 28-APR-17_10:28:46 1 1 NO DCS_CDB 10786 B F A DISK 28-APR-17_10:28:56 1 1 NO DCS_CDB 10814 B F A DISK 28-APR-17_10:29:08 1 1 NO DCS_CDB - Use the list backup summary completed before "to_date()" device type disk tag ''; command to find the backup pieces on the share by using the
tag(by default, thetagis the NetBackup policy name).Example:
RMAN> list backup summary completed before "to_date('28-APR-17_10:41:37', 'DD-MON-YY_HH24:MI:SS')" device type disk tag 'DCS_CDB'; List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- ------------------ ------- ------- ---------- --- 10759 B A A DISK 28-APR-17_10:28:46 1 1 NO DCS_CDB 10786 B F A DISK 28-APR-17_10:28:56 1 1 NO DCS_CDB 10814 B F A DISK 28-APR-17_10:29:08 1 1 NO DCS_CDB - Use the list backup completed before "to_date()" device type disk tag ''; command to remove the summary option to see what files need deleting.
Example:
RMAN> list backup completed before "to_date('28-APR-17_10:41:37', 'DD-MON-YY_HH24:MI:SS')" device type disk tag 'DCS_CDB'; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------ 10759 40.00K DISK 00:02:55 28-APR-17_10:28:46 BP Key: 10762 Status: AVAILABLE Compressed: NO Tag: DCS_CDB Piece Name: C:\HA_NBA_SHARE\ARCH_D-ORACLEC2_I-3019371157_SCN-2323355_26S2QF5F_DCS_CDB List of Archived Logs in backup set 10759 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------ ---------- --------- 1 19 2322734 28-APR-17_10:16:54 2323527 28-APR-17_10:25:48 1 20 2323527 28-APR-17_10:25:48 2323546 28-APR-17_10:25:49 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------ 10786 Full 80.00K DISK 00:03:02 28-APR-17_10:28:56 BP Key: 10789 Status: AVAILABLE Compressed: NO Tag: DCS_CDB Piece Name: C:\HA_NBA_SHARE\SPFILE_D-ORACLEC2_I-3019371157_T-20170428_27S2QF5I_DCS_CDB SPFILE Included: Modification time: 27-APR-17_14:57:53 SPFILE db_unique_name: ORACLEC2 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------ 10814 Full 17.17M DISK 00:03:11 28-APR-17_10:29:08 BP Key: 10816 Status: AVAILABLE Compressed: NO Tag: DCS_CDB Piece Name: C:\HA_NBA_SHARE\CF_D-ORACLEC2_I-3019371157_T-20170428_28S2QF5L_DCS_CDB Control File Included: Ckp SCN: 2323603 Ckp time: 28-APR-17_10:25:57 - Use the delete backup completed before "to_date()" device type disk tag ''; command to delete the unwanted backup pieces.
Example:
RMAN> delete backup completed before "to_date('28-APR-17_10:41:37', 'DD-MON-YY_HH24:MI:SS')" device type disk tag 'DCS_CDB'; allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=242 device type=DISK List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name ------- ------- --- --- ----------- ----------- ---------- 10762 10759 1 1 AVAILABLE DISK C:\HA_NBA_SHARE\ARCH_D-ORACLEC2_I-3019371157_ SCN-2323355_26S2QF5F_DCS_CDB 10789 10786 1 1 AVAILABLE DISK C:\HA_NBA_SHARE\SPFILE_D-ORACLEC2_I-3019371157_ T-20170428_27S2QF5I_DCS_CDB 10816 10814 1 1 AVAILABLE DISK C:\HA_NBA_SHARE\CF_D-ORACLEC2_I-3019371157_ T-20170428_28S2QF5L_DCS_CDB Do you really want to delete the above objects (enter YES or NO)? YES deleted backup piece backup piece handle=C:\HA_NBA_SHARE\ARCH_D-ORACLEC2_I-3019371157_SCN-2323355_26S2QF5F_DCS_CDB RECID=50 STAMP=942488751 deleted backup piece backup piece handle=C:\HA_NBA_SHARE\SPFILE_D-ORACLEC2_I-3019371157_T-20170428_27S2QF5I_DCS_CDB RECID=51 STAMP=942488754 deleted backup piece backup piece handle=C:\HA_NBA_SHARE\CF_D-ORACLEC2_I-3019371157_T-20170428_28S2QF5L_DCS_CDB RECID=52 STAMP=942488758 Deleted 3 objects - Use the list copy completed before "to_date()" tag ''; command to find the data file copies on the share using the same reset time and
tag.Example:
RMAN> list copy completed before "to_date('28-APR-17_10:41:37', 'DD-MON-YY_HH24:MI:SS')" tag 'DCS_CDB'; specification does not match any control file copy in the repository List of Datafile Copies ======================= Key File S Completion Time Ckp SCN Ckp Time ------- ---- - ------------------ ---------- ------------------ 10649 1 A 28-APR-17_10:25:39 2323417 28-APR-17_10:25:15 Name: C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-SYSTEM_FNO-1_1GS2QE1J_S-48_ I-3019371157_DCS_CDB Tag: DCS_CDB 10251 2 A 28-APR-17_10:15:32 2243146 27-APR-17_10:31:51 Name: C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-SYSTEM_FNO-2_1LS2QEGQ_S-53_ I-3019371157_DCS_CDB Tag: DCS_CDB Container ID: 2, PDB Name: PDB$SEED 10648 3 A 28-APR-17_10:25:39 2323417 28-APR-17_10:25:15 Name: C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-SYSAUX_FNO-3_1IS2QE8G_S-50_ I-3019371157_DCS_CDB Tag: DCS_CDB 10249 4 A 28-APR-17_10:13:19 2243146 27-APR-17_10:31:51 Name: C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-SYSAUX_FNO-4_1JS2QEBG_S-51_ I-3019371157_DCS_CDB Tag: DCS_CDB Container ID: 2, PDB Name: PDB$SEED 10647 5 A 28-APR-17_10:25:38 2323417 28-APR-17_10:25:15 Name: C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-UNDOTBS1_FNO-5_1HS2QE57_S-49_ I-3019371157_DCS_CDB Tag: DCS_CDB 10646 6 A 28-APR-17_10:25:37 2323417 28-APR-17_10:25:15 Name: C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-USERS_FNO-6_1NS2QEJV_S-55_ I-3019371157_DCS_CDB Tag: DCS_CDB - Use the delete copy completed before "to_date()" tag ''; command to delete the data file copies on the selected share.
Example:
RMAN> delete copy completed before "to_date('28-APR-17_10:41:37', 'DD-MON-YY_HH24:MI:SS')" tag 'DCS_CDB'; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=242 device type=DISK specification does not match any control file copy in the repository List of Datafile Copies ======================= Key File S Completion Time Ckp SCN Ckp Time ------- ---- - ------------------ ---------- ------------------ 10649 1 A 28-APR-17_10:25:39 2323417 28-APR-17_10:25:15 Name: C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-SYSTEM_FNO-1_1GS2QE1J_S-48_ I-3019371157_DCS_CDB Tag: DCS_CDB 10251 2 A 28-APR-17_10:15:32 2243146 27-APR-17_10:31:51 Name: C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-SYSTEM_FNO-2_1LS2QEGQ_S-53_ I-3019371157_DCS_CDB Tag: DCS_CDB Container ID: 2, PDB Name: PDB$SEED 10648 3 A 28-APR-17_10:25:39 2323417 28-APR-17_10:25:15 Name: C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-SYSAUX_FNO-3_1IS2QE8G_S-50_ I-3019371157_DCS_CDB Tag: DCS_CDB 10249 4 A 28-APR-17_10:13:19 2243146 27-APR-17_10:31:51 Name: C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-SYSAUX_FNO-4_1JS2QEBG_S-51_ I-3019371157_DCS_CDB Tag: DCS_CDB Container ID: 2, PDB Name: PDB$SEED 10647 5 A 28-APR-17_10:25:38 2323417 28-APR-17_10:25:15 Name: C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-UNDOTBS1_FNO-5_1HS2QE57_S-49_ I-3019371157_DCS_CDB Tag: DCS_CDB 10646 6 A 28-APR-17_10:25:37 2323417 28-APR-17_10:25:15 Name: C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-USERS_FNO-6_1NS2QEJV_S-55_ I-3019371157_DCS_CDB Tag: DCS_CDB Do you really want to delete the above objects (enter YES or NO)? YES deleted datafile copy datafile copy file name=C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-SYSTEM_FNO-1_1GS2QE1J_ S-48_I-3019371157_DCS_CDB RECID=36 STAMP=942488739 deleted datafile copy datafile copy file name=C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-SYSTEM_FNO-2_1LS2QEGQ_ S-53_I-3019371157_DCS_CDB RECID=29 STAMP=942488132 deleted datafile copy datafile copy file name=C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-SYSAUX_FNO-3_1IS2QE8G_ S-50_I-3019371157_DCS_CDB RECID=35 STAMP=942488739 deleted datafile copy datafile copy file name=C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-SYSAUX_FNO-4_1JS2QEBG_ S-51_I-3019371157_DCS_CDB RECID=27 STAMP=942487999 deleted datafile copy datafile copy file name=C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-UNDOTBS1_FNO-5_1HS2QE57_ S-49_I-3019371157_DCS_CDB RECID=34 STAMP=942488738 deleted datafile copy datafile copy file name=C:\HA_NBA_SHARE\DATA_D-ORACLEC2_I-3019371157_TS-USERS_FNO-6_1NS2QEJV_ S-55_I-3019371157_DCS_CDB RECID=33 STAMP=942488737 Deleted 6 objects