Ransomware attackers specifically target and attempt to destroy backup systems to increase the probability of payment. Hardening your system is critical. Please ensure you have reviewed your platform security using the Security Hardening Checklist
Cohesity

COHESITY Documentation

Explore our documentation to get started, discover products & new features, access troubleshooting guides, register sources, platforms support.

Products
Data Security Alliance
Visit Cohesity.com
Demos
Support
Blogs
Developers
Partner Portals
Cohesity Community
© 2026 Cohesity, Inc. All Rights Reserved.
Terms of Use|
Privacy Policy|
Legal|
  1. Home
  3. NetBackup™ for Oracle Administrator's Guide
  5. Performing backups and restores of Oracle
  7. Cleaning up the Oracle Copilot share after point in time restore of database
NetBackup™ for Oracle Administrator's Guide

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

  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

Feedback

Was this page helpful?
Previous

Creating an instant access mount from an Oracle Copilot universal share image

Next

Single-step restore to ASM storage from an Oracle Copilot recovery point

Feedback

Was this page helpful?