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 Timefor 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, thetagis 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