RMAN 歸檔日誌未刪除

我正在開發一個 Oracle11gR2 數據庫。數據庫處於 DataGuard 模式，即使 dataguard 設置為 DEFER。

我想刪除已至少備份 2 次到磁帶的所有歸檔日誌。

rman> list archivelog all backed up 2 times to device type sbt_tape;

顯示符合條件的歸檔日誌列表

但是，當我稍後嘗試執行時

rman> delete force noprompt archivelog all backed up 2 times to device type sbt_tape;

沒有文件被刪除。

除了設置為 370 天視窗的保留策略外，所有參數均設置為預設值

查看我生成的跟踪，除其他外，顯示list命令報告的每個文件的此消息

DBGMISC: Matching archived log has 0 backups

我不知道如何解釋。

任何有關如何進一步調查該問題的想法將不勝感激

rman配置如下

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORACLE are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 370 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'SBT_LIBRARY=/opt/tivoli/tsm/client/oracle/bin64/libobk.so';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ASMARCHIVES/oracle/snap_orcld.f';

因為您有 CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1；# 預設將設備類型 SBT_TAPE 的 ARCHIVELOG 備份副本配置為 1；# 預設數據庫要確保備份到磁帶和磁碟。如果您希望它有所不同，因為您只備份到刪除有關磁碟備份的行的磁帶。

CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR;

您還可以考慮設置 ARCHIVELOG 刪除策略。

引用自：https://dba.stackexchange.com/questions/306561