Veritas NetBackup™ for Oracle Administrator's Guide

Last Published:
Product(s): NetBackup (8.2)
  1. Introduction
    1.  
      What's new about NetBackup for Oracle
    2.  
      About NetBackup for Oracle
    3.  
      NetBackup for Oracle features
    4.  
      NetBackup for Oracle terminology
    5.  
      NetBackup for Oracle operation using the Oracle Intelligent Policy
    6.  
      Logging the RMAN input and output on a client
    7.  
      NetBackup for Oracle operation using a script- or template-based policy
    8.  
      About Oracle RMAN
    9.  
      About the Oracle recovery catalog
  2. NetBackup for Oracle QuickStart
    1.  
      Installing NetBackup for Oracle
    2.  
      Registering Oracle database instances
    3.  
      Creating an Oracle database instance group
    4.  
      Creating an Oracle policy
  3. Installing NetBackup for Oracle
    1.  
      Verifying the operating system and platform compatibility
    2.  
      NetBackup server and client requirements
    3.  
      Requirements for using NetBackup for Oracle in a NetBackup cluster
    4.  
      About the license for NetBackup for Oracle
    5. 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
        1.  
          Manually linking AIX (64-bit)
        2.  
          Manually linking HP Itanium (64-bit)
        3.  
          Manually linking Linux x86 (64-bit)
        4.  
          Manually linking IBM pSeries or zSeries
        5.  
          Manually linking Solaris x86 (64-bit)
        6.  
          Manually linking Solaris SPARC (64-bit)
  4. Oracle policy configuration
    1. Preparing for NetBackup for Oracle configuration
      1.  
        About Oracle policy configuration
      2. Permissions for NetBackup for Oracle log directories
        1.  
          Oracle Home User permissions when NetBackup SAN Client is used
      3.  
        NetBackup for Oracle backup policy types
      4.  
        Configuring the Maximum jobs per client for NetBackup for Oracle
    2. Instance management for an Oracle Intelligent Policy
      1.  
        About the NetBackup Discovery Service
      2.  
        Viewing the Oracle database instance repository
      3.  
        Manually adding an Oracle database instance to the repository
      4.  
        Registering an Oracle database instance
      5.  
        About Oracle database instance groups
      6.  
        Adding an instance to an instance group
      7.  
        Automatic Registration of an instance group
      8.  
        About instance actions
    3. About Oracle Intelligent Policies (OIP)
      1.  
        Creating an Oracle Intelligent Policy (OIP)
      2.  
        Oracle database upgrade effect on Oracle Intelligent Policies
      3.  
        Configuring NetBackup for Oracle automatic backup schedules
      4.  
        About NetBackup for Oracle schedule properties using Oracle Intelligent Policy
      5.  
        Oracle Intelligent Policy - Storage and Retention
      6.  
        About Oracle Intelligent Policy master server behavior
      7.  
        Instances and Databases tab
      8.  
        Backup Selections tab
      9.  
        Oracle tab
      10.  
        About using a NetBackup appliance share for Oracle backups (Copilot)
      11.  
        Configuring an OIP using a share on the NetBackup appliance (Copilot)
    4. About script- or template-based Oracle policies
      1.  
        Adding a new script- or template-based Oracle policy
      2.  
        About policy attributes
      3.  
        About backup schedules, templates, and scripts
      4.  
        About schedule properties
      5.  
        Script- or template-based policy - Storage and Retention
      6.  
        Adding clients to a policy
      7. About adding backup selections to an Oracle policy
        1.  
          Adding a template to the backup selections list in the NetBackup Administration Console
        2.  
          Adding a script to the backup selections list in the NetBackup Administration Console
      8. About configuring the run-time environment
        1.  
          About the Oracle RMAN environment
        2.  
          About the environment variables set by NetBackup for Oracle
        3.  
          About the RMAN SEND command variables
        4.  
          About the bp.conf file on UNIX systems
      9. About creating templates and shell scripts
        1.  
          Starting the NetBackup Backup, Archive, and Restore interface
        2.  
          RMAN templates and shell scripts
        3.  
          Creating RMAN templates using the NetBackup for Oracle RMAN template generation wizard
        4.  
          Creating an RMAN script from a template
        5. About creating RMAN scripts manually
          1.  
            About the NetBackup for Oracle sample scripts
          2.  
            Using the NetBackup for Oracle sample scripts
          3.  
            About the set duplex command
        6.  
          About storing templates
        7.  
          About storing shell scripts
    5.  
      Configuring the logon account for the NetBackup Client Service for NetBackup for Oracle
    6.  
      Testing configuration settings for NetBackup for Oracle
  5. 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 NetBackup for Oracle templates
      2.  
        Using bpdbsbora to run a backup template
      3.  
        Running the NetBackup for Oracle shell script
      4.  
        Running RMAN
    5.  
      Browsing backups using the bplist command
    6.  
      Managing expired backup images
    7. About NetBackup for Oracle restores
      1.  
        Starting the recovery wizard
      2.  
        Using the recovery wizard
      3.  
        Using bpdbsbora to run a recovery template
      4.  
        About an Oracle recovery shell script on the client
      5.  
        Running RMAN on the client
      6.  
        About Oracle multistream restore for proxy backup
      7. Redirecting a restore to a different client
        1.  
          Preparing the master server for an alternate restore
        2.  
          About performing a redirected restore with RMAN
        3.  
          Example - Performing a redirected restore of Oracle
    8. Using NetBackup for Oracle in a Microsoft Windows cluster environment
      1.  
        About backups of an Oracle clustered database on Windows
      2.  
        Bringing the database instance offline on Windows
      3.  
        Bringing the database instance online on Windows
      4.  
        User-directed backup or restore from the Windows client
    9.  
      Creating an instant recovery point from an Oracle Copilot image
    10.  
      Deleting an instant recovery point for Oracle Copilot instant recovery
    11.  
      Cleaning up the Copilot share after point in time restore of database
    12.  
      Single-step restore to ASM storage from a Copilot recovery point
    13.  
      About restoring from a data file copy to ASM storage using RMAN
  6. Guided Recovery
    1.  
      About OpsCenter Guided Recovery
    2.  
      Setting up for Guided Recovery cloning
    3.  
      Guided Recovery cloning pre-operation checks
    4.  
      Performing a Guided Recovery cloning operation
    5.  
      Select a Master Server dialog
    6.  
      Select Source Database panel
    7.  
      Select Control File Backup panel
    8.  
      Destination host and login panel
    9.  
      Destination Parameters panel
    10.  
      Selection summary panel
    11.  
      Pre-clone check panel
    12.  
      Job Details panel
    13.  
      Guided Recovery post-clone operations
    14. Troubleshooting Guided Recovery
      1.  
        Troubleshooting files for metadata collection operations at the time of the backup
      2.  
        Troubleshooting files for Guided Recovery validation operations
      3.  
        Troubleshooting files for Guided Recovery cloning operations
  7. NetBackup for Oracle with Snapshot Client
    1. About NetBackup for Oracle with Snapshot Client
      1.  
        Proxy copy
      2.  
        NetBackup for Oracle stream-based operations
      3.  
        NetBackup for Oracle file-based operations
    2. How NetBackup for Oracle with Snapshot Client works
      1.  
        About the NetBackup for Oracle backup and restore operations
      2.  
        Database objects supported by advanced backup methods
      3.  
        About NetBackup multistreaming
      4.  
        RMAN multiple channels
      5.  
        Restoring data files to a new location
      6.  
        Redirecting a restore to a different client
      7.  
        Symbolic links and raw data files (UNIX)
      8.  
        Quick I/O data files (UNIX)
      9.  
        RMAN incremental backups
      10.  
        Proxy backup examples
    3. About configuring Snapshot Client with NetBackup for Oracle
      1.  
        Configuration requirements for snapshot backups with NetBackup for Oracle
      2.  
        Configuring a snapshot policy for NetBackup for Oracle
      3.  
        Configuring a snapshot policy using a share on the NetBackup appliance (Copilot)
    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 from the Java or Windows interface
        2.  
          Performing a snapshot rollback restore using a script or RMAN command
        3.  
          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
      1.  
        How BLI works with NetBackup for Oracle (UNIX)
      2.  
        About the Storage Checkpoint facility and NetBackup for Oracle
      3.  
        Configuration requirements for BLI backups with NetBackup for Oracle
      4. Configuring policies for BLI backups with NetBackup for Oracle
        1.  
          About the types of NetBackup for Oracle BLI backups
    6. About Snapshot Client effects
      1.  
        How Snapshot Client software affects backup types
      2.  
        How Snapshot Client software affects schedule properties
      3.  
        How Snapshot Client software affects templates and scripts
      4.  
        NetBackup for Oracle with Snapshot Client environment variables
    7. About Oracle support for Replication Director
      1.  
        Configuring an Oracle Intelligent Policy using Replication Director
      2.  
        Configuring a script- or template-based Oracle policy
  8. 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 the UNIX browser interface and wizards
    12.  
      Troubleshooting NetBackup for Oracle with Snapshot Client
    13.  
      Minimizing timeout failures on large database restores
    14.  
      Minimizing the loading and unloading of tapes for database backups
    15.  
      Delays in backup job transfer and completion
  9. Appendix A. Real Application Clusters
    1.  
      About Real Application Clusters
    2.  
      About virtual names and NetBackup for Oracle
    3.  
      About RAC archiving schemes
    4.  
      About backing up a database
    5.  
      Example of restoring a database
    6.  
      Troubleshooting database restores (UNIX and Windows)
    7.  
      About restoring archive logs
  10. Appendix B. Best practices for protecting Oracle RAC with NetBackup
    1.  
      Oracle RAC with NetBackup best practices
    2.  
      About using Templates and Oracle Intelligent Policy (OIP) with RAC
    3.  
      About NetBackup for Oracle operations
    4.  
      Example RAC configuration: Failover name exists and backup is not load balanced
    5.  
      Example RAC configuration: Failover name exists and backup is load balanced
    6.  
      Example RAC configuration: Failover name is not available and backup is not load balanced
    7.  
      Example RAC configuration: Failover name is not available, and backup is load balanced, one policy with custom script
    8.  
      Example RAC configuration: Failover name is not available and backup is load balanced, simple script with manual policy failover
    9.  
      Image catalog configuration for RAC
    10.  
      Configuring the appliance within a RAC environment
  11. Appendix C. Deduplication best practices
    1.  
      Optimizing and deduplicating stream-based and proxy copy Oracle backups
    2.  
      Configuring a stream-based Oracle backup
    3.  
      Example RMAN script for a stream-based backup
    4.  
      Editing the RMAN script and configuring NetBackup for Oracle for a proxy copy backup
    5.  
      Example RMAN script for a proxy copy backup
  12. Appendix D. 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
  13. Appendix E. 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
      1.  
        Number of policies required for BLI backup
      2.  
        About BLI policy attributes
      3.  
        About the BLI client list
      4.  
        Backup selections list for BLI backups
      5.  
        About schedules for BLI backup policies
      6.  
        Example Oracle BLI backup policy
      7.  
        Setting the maximum jobs per client global attribute
      8.  
        About BLI backup methods
      9. Creating notify scripts for BLI backups
        1.  
          Identify the POLICY_IN_CONTROL for BLI backups
        2.  
          Oracle environment variables for BLI scripts
        3.  
          About BLI notify scripts for other policies
        4.  
          Sample setup_bli_scripts session
    5. Performing backups and restores
      1.  
        About NetBackup for Oracle agent automatic backups
      2.  
        About NetBackup for Oracle manual backups
      3.  
        Backing up Quick I/O files
      4.  
        Restoring BLI backup images
      5.  
        About NetBackup backup and restore logs
    6. About troubleshooting backup or restore errors
      1.  
        Troubleshooting stages of backup and restore operations
      2.  
        NetBackup restore and backup status codes
      3.  
        Improving NetBackup backup performance
      4.  
        About BLI backup and database recovery
  14. Appendix F. XML Archiver
    1. NetBackup for Oracle XML export and XML import
      1.  
        NetBackup for Oracle XML export and import archiving features
      2.  
        XML export archive process
      3.  
        Sequence of operation: XML export archive
      4.  
        XML import restore process
      5.  
        Sequence of operation: XML import restore
    2.  
      About the environment variables set by a user in the XML export parameter file
    3. About XML export templates and shell scripts
      1.  
        Creating XML export templates using the NetBackup for Oracle wizard (UNIX)
      2.  
        Creating XML export templates using the NetBackup for Oracle wizard (Windows)
      3.  
        Creating an XML export script from a template
      4.  
        Creating XML export scripts manually
    4. Performing an XML export archive
      1.  
        Running NetBackup for Oracle XML export templates
      2.  
        Using bpdbsbora to run an XML export template
      3.  
        Running the NetBackup for Oracle XML export script on the client
      4.  
        Running bporaexp on the client as an Oracle user
      5.  
        Writing to a directory versus writing to a storage unit
      6.  
        About bporaexp parameters
    5.  
      Browsing XML export archives using bporaimp parameters
    6.  
      Browsing XML export archives using bplist
    7. Restoring an XML export archive
      1.  
        Running the XML import wizard on the client
      2.  
        Using bpdbsbora to run an XML import template
      3.  
        Running an XML import script on the client
      4.  
        Running bporaimp on the client
      5.  
        About bporaimp parameters
      6. About redirecting a restore of an XML export archive to a different client
        1.  
          Redirecting a restore of an XML export archive to a new client using bporaimp
        2.  
          Example - Using bporaimp for a redirected restore
    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
  15. Appendix G. Register authorized locations
    1.  
      Registering authorized locations used by a NetBackup database script-based policy

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

  1. Open a command prompt on the NetBackup client.
  2. 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
  3. Log into RMAN and if NetBackup uses the RMAN catalog, it is required to log in to the catalog.
  4. 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
    
  5. 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
    
  6. 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
    
  7. 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
    
  8. 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
    
  9. 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
    
  10. 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