Please enter search query.
Search <book_title>...
NetBackup™ for Oracle Administrator's Guide
Last Published:
2022-12-21
Product(s):
NetBackup (10.1.1)
- 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
Cleaning up the Oracle 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 an Oracle 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 an Oracle Copilot share is not in the GUI. This feature is command line option only.
To clean up the Oracle 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