Search <book_title>...

NetBackup™ for Oracle Administrator's Guide

Last Published: 2023-10-23

Product(s): NetBackup (10.3.0.1, 10.3)

Introduction
1. About NetBackup for Oracle
2. NetBackup for Oracle features
NetBackup for Oracle QuickStart
1. Install NetBackup for Oracle
2. Register Oracle database instances
3. Add an Oracle database instance group
4. Create an Oracle policy
Installing NetBackup for Oracle
1. Verifying the operating system and platform compatibility
2. NetBackup server and client requirements for NetBackup for Oracle
3. Requirements for using NetBackup for Oracle in a NetBackup cluster
4. License for NetBackup for Oracle
5. About accurate licensing for Oracle
6. About linking Oracle RMAN with NetBackup for UNIX
  1. Verifying environment variables and shutting down Oracle
  2. Linking Oracle RMAN with NetBackup on UNIX platforms
Configuring RBAC for the Oracle administrator
1. RBAC roles for the Oracle administrator
Managing Oracle instances and databases
1. About Oracle discovery
  1. Configure discovery of Oracle clients
2. Managing Oracle instances
3. Manage Oracle databases and pluggable databases
  1. View Oracle database details
  2. View pluggable database details
4. About Oracle database instance groups
  1. Add an instance to an instance group
5. Clean up Oracle instance and databases
6. Authorizing a DBA to register instances or instance groups with the nboraadm command
Managing Oracle credentials
1. About Oracle credentials
2. Oracle credential types in the NetBackup Credential Management (CMS)
3. Add a credential to use for cloning an Oracle database
4. Edit or delete a named credential
5. Manage credentials for an instance or an Oracle RAC database
Configuring Oracle policies
1. Preparing for NetBackup for Oracle configuration
2. About Oracle Intelligent Policies (OIP)
3. About script-based Oracle policies
4. Configuring the logon account for the NetBackup Client Service for NetBackup for Oracle
5. Testing configuration settings for NetBackup for Oracle
Managing Oracle RAC
1. Oracle Real Application Clusters (RAC)
2. Add an Oracle Real Application Cluster (RAC)
3. Edit or delete an Oracle RAC database
Performing backups and restores of Oracle
1. Overview of using NetBackup for Oracle
2. Maintaining the RMAN repository
3. Querying the RMAN repository
4. About NetBackup for Oracle backups
  1. Running the NetBackup for Oracle shell script
  2. Running RMAN
5. Browsing backups using the bplist command
6. Managing expired backup images
  1. About preventing the direct expiration of backup images
7. About NetBackup for Oracle restores
8. Using NetBackup for Oracle in a Windows Server Failover Cluster (WSFC)
Oracle cloning
1. About cloning an Oracle database or a pluggable database
2. Create a custom RBAC role for Oracle cloning
3. Clone an Oracle database
4. Clone a pluggable database
5. Cloning a database from an Oracle Intelligent Policy (OIP) that is Data Guard aware
6. Additional functionality in NetBackup APIs
NetBackup Copilot for Oracle
1. About Oracle Copilot
2. Configuring an OIP using a share on the NetBackup appliance (Oracle Copilot)
3. Creating an instant recovery point from an Oracle Copilot image (NetBackup Appliance share)
4. Deleting an instant recovery point for Oracle Copilot instant recovery
5. Configuring an OIP using universal shares (Oracle Copilot)
  1. Recommendations when you configure an Oracle Copilot with universal shares
  2. Troubleshooting issues related to Oracle Copilot with universal shares
6. Managing an instant access mount from an Oracle Copilot universal share image
7. Cleaning up the Oracle Copilot share after point in time restore of database
8. Single-step restore to ASM storage from an Oracle Copilot recovery point or instant access mount
9. About restoring from a data file copy to ASM storage using RMAN
Oracle Copilot with instant access
1. Prerequisites when you configure an instant access Oracle database
  1. Hardware configuration requirement of instant access
2. Things to consider before you configure an instant access mount point
3. Backing up an Oracle database using Oracle Copilot policy with a universal share
4. Configure an instant access mount
5. View the livemount details of an instant access mount
6. Configuring Auto Image Replication for Oracle instant access backups
7. Delete an instant access mount
8. NetBackup for Oracle terms
9. Frequently asked questions
NetBackup for Oracle with Snapshot Client
1. About NetBackup for Oracle with Snapshot Client
2. How NetBackup for Oracle with Snapshot Client works
3. About configuring Snapshot Client with NetBackup for Oracle
4. Restoring NetBackup for Oracle from a snapshot backup
  1. About restoring individual files from a NetBackup for Oracle snapshot backup
  2. About NetBackup for Oracle restores of volumes and file systems using snapshot rollback
    1. Performing a snapshot rollback restore using a script or RMAN command
    2. Performing a NetBackup for Oracle point-in-time rollback restore from a SnapVault backup (UNIX)
5. About configuring NetBackup for Oracle block-level incremental backups on UNIX
6. About Snapshot Client effects
7. About Oracle support for Replication Director
  1. Configuring an Oracle Intelligent Policy using Replication Director
  2. Configuring a script-based Oracle policy
NetBackup Dedupe Direct for Oracle
1. About NetBackup Dedupe Direct for Oracle plug-in
2. Verifying the operating system and platform compatibility
3. Before you install NetBackup Dedupe Direct for Oracle plug-in
4. Installing NetBackup Dedupe Direct for Oracle plug-in on the Oracle database server
5. Using NetBackup Dedupe Direct for Oracle plug-in
6. Uninstalling the NetBackup Dedupe Direct for Oracle plug-in
Other Oracle configuration
1. Load balance Oracle RAC instances
2. Configure an Oracle Wallet with RAC within NetBackup
Troubleshooting
1. About troubleshooting NetBackup for Oracle
2. About NetBackup for Oracle troubleshooting steps
3. NetBackup debug logs and reports
4. Enabling the debug logs manually (Windows)
5. Enabling the debug logs manually (UNIX)
6. About the NetBackup for Oracle log files
7. Setting the debug level on a Windows client
8. Setting the debug level on a UNIX client
9. About RMAN utility logs
10. Troubleshooting RMAN backup or restore errors
  1. Verifying the RMAN script on UNIX
  2. Troubleshooting each stage of the backup or restore
11. Troubleshooting NetBackup for Oracle with Snapshot Client
12. Error: Unable to re-create online log
13. Minimizing timeout failures on large database restores
14. Minimizing the loading and unloading of tapes for database backups
15. Enabling the debug logs manually for NetBackup Dedupe Direct for Oracle plug-in
Appendix A. Deduplication best practices
1. Optimizing and deduplicating stream-based and proxy copy Oracle backups
2. Oracle stream handler
3. Configuring a stream-based Oracle backup
4. Example RMAN script for a stream-based backup
5. Editing the RMAN script and configuring NetBackup for Oracle for a proxy copy backup
6. Example RMAN script for a proxy copy backup
Appendix B. Snapshot Client support of SFRAC
1. About Snapshot Client support of SFRAC
2. NetBackup configuration for an SFRAC environment
3. Configuring the SFRAC environment for a backup operation
4. Performing a rollback restore in an SFRAC environment
5. Troubleshooting NetBackup in an SFRAC environment
Appendix C. Script-based Block-Level Incremental (BLI) Backups without RMAN on UNIX and Linux systems
1. About script-based Block-Level Incremental (BLI) Backups without RMAN
2. About BLI backup and restore operations
3. Verifying installation requirements for BLI backups without RMAN
  1. File system and Storage Checkpoint space management
4. Creating NetBackup policies for script-based BLI backup
5. Performing backups and restores
6. About troubleshooting backup or restore errors
Appendix D. XML Archiver
1. NetBackup for Oracle XML export and XML import
2. About the environment variables set by a user in the XML export parameter file
3. About XML export shell scripts
  1. Creating XML export scripts manually
4. Performing an XML export archive
5. Browsing XML export archives using bporaimp parameters
6. Browsing XML export archives using bplist
7. Restoring an XML export archive
8. Troubleshooting XML export or XML import errors
  1. Checking the logs to determine the source of an error
  2. Troubleshooting each stage of the XML export or XML import
9. Additional XML export and import logs
Appendix E. Register authorized locations
1. Registering authorized locations used by a NetBackup database script-based policy

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 Time for 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, the tag is 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