我正在开发一个 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;# 默认数据库要确保备份到磁带和磁盘。如果您希望它有所不同,因为您只备份到删除有关磁盘备份的行的磁带。
您还可以考虑设置 ARCHIVELOG 删除策略。