To clean up the Oracle 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