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
- 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