Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterOracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and laterOracle Database
RMAN-08138 warning: archived log not deleted - must create more backups Cause An archived log that should have been deleted was not as it it did not meet the user specified archive log deletion policy of number of backups required before deleting the logs. Action This is an informational ...
tag=TAG20131112T153726comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsed time:00:00:01channelORA_DISK_1:deleting archivedlog(s)RMAN-08138:WARNING:archived log not deleted-must create more backups--->出现警告提示,日志当前不能被删除,更多的备份需要创建 archived log file name=/u03/database/usb...
SQL> select count(*) from v$archived_log where archived='YES' and deleted='NO'; COUNT(*) --- 18 --注意这些已经备份过两次的recid编号 SQL> select recid, sequence#, archived, deleted, backup_count from v$archived_log where backup_count>1; RECID SEQUENCE# ARCHIVED DELETED BACKUP_COUNT ---...
channel ORA_DISK_1: deleting archived log(s) RMAN-08138: WARNING: archived log not deleted - must create more backups --->出现警告提示,日志当前不能被删除,更多的备份需要创建 archived log file name=/u03/database/usbo/fr_area/USBO/archivelog/2013_11_12/o1_mf_1_121_983pm3gp_.arc threa...
But, when there is no disk space to reclaim, we should not refresh the aging rules which could cause a performance problem. Comment/Info: We print a message when a file is purged/deleted from FRA when reclaim space in alert log.
select applied,deleted,decode(rectype,11,'YES','NO') reclaimable ,count(*),min(sequence#),max(sequence#) from v$archived_log left outer join sys.x$kccagf using(recid) where is_recovery_dest_file='YES' and name is not null group by applied,deleted,decode(rectype,11,'YES','NO') ord...
有一些RMAN命令可在仅使用恢复目录时使用。还可以在仅使用恢复目录时使用RMAN存储脚本。如果使用控制文件,要冒某些历史数据被覆盖的风险,但恢复目录将保障这些数据的安全,这是因为控制文件与备份有关的活动分配的空间有限,从而恢复目录有更多的空间存储备份历史。系统中的一个恢复目录可对多个Oracle数据库执行备份、复原和...
研究archivelog行为最好的工具视图是v$archived_log。很多DBA喜欢从操作系统层面删除归档日志,但是这种方式是不会直接被Oracle控制文件认可,所以建议使用RMAN或者官方工具来做。 --已归档未删除日志 SQL> select count(*) from v$archived_log where archived='YES' and deleted='NO'; ...