========= 删除归档日志 =========
第一步: 直接删除 物理数据 rm
第二步:通过 rman 删除:
oracle@linux112:/opt/dbbak/log_archive_dest_1> rman
RMAN> connect target sys/sys_passwd
执行如下命令:
(1) crosscheck backup;
(2) delete obsolete;
(3) delete expired backup;
(4) crosscheck archivelog all;
(5) delete expired archivelog all;
(6) host;
此问题属于归档日志满了。
解决办法:
SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ARCHIVELOG 99.9 0 3
FLASHBACKLOG 0 0 0
可以看出,ARCHIVELOG日志已经达到99.9%了。要把它清除掉