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

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

Cleaning up the Copilot share after point in time restore of database

Feedback

Feedback