搜索 <book_title>...

NetBackup™ for Oracle 管理指南

Last Published: 2024-05-14

Product(s): NetBackup & Alta Data Protection (10.4)

在数据库的时间点还原后清理 Oracle Copilot 共享

在 Oracle 数据库的时间点还原后，RMAN 可以在 Oracle Copilot 共享上保留先前数据库实体中的文件。NetBackup 不会自动清理先前数据库实体中的文件。此过程介绍如何使用 RMAN 手动清理共享。

注意:

GUI 不提供清理 Oracle Copilot 共享的功能。此功能仅限用于命令行选项。

清理 Oracle Copilot 共享

在 NetBackup 客户端上打开命令提示符。

设置 NLS DATE_FORMAT 以显示小时、分钟和秒。

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

登录到 RMAN，如果 NetBackup 使用 RMAN 目录库，则需要登录到该目录库。

使用 RMAN> list incarnation of database; 命令，可查找当前实体的 Reset Time。

示例：

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

使用 list backup summary completed before "to_date()" device type disk; 命令，可通过使用重置时间（"to_date()" 必须匹配 NLS_DATE_FORMAT）查找先前实体中的所有备份片。

示例：

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

使用 list backup summary completed before "to_date()" device type disk tag ''; 命令，可通过使用 tag（默认情况下，tag 为 NetBackup 策略名称）查找共享上的备份片。

示例：

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

使用 list backup completed before "to_date()" device type disk tag ''; 命令，可删除摘要选项以查看需要删除哪些文件。

示例：

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

使用 delete backup completed before "to_date()" device type disk tag ''; 命令，可删除不需要的备份片。

示例：

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

使用 list copy completed before "to_date()" tag ''; 命令，可通过使用相同的重置时间和 tag 查找共享上的数据文件副本。

示例：

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

使用 delete copy completed before "to_date()" tag ''; 命令，可删除选定共享上的数据文件副本。

示例：

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