我的数据库是Oracle10G,Rman备份天数设置的2天,打show all;命令也显示CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
但是现在2天之前的备份不能自动删除,备份盘才100G空间,几天就满,还得手工删除,,有高手能解决这个问题吗? 或者给我个解决问题的思路?谢谢了
但是现在2天之前的备份不能自动删除,备份盘才100G空间,几天就满,还得手工删除,,有高手能解决这个问题吗? 或者给我个解决问题的思路?谢谢了
建一个job任务自动删除或者剪切到别的磁盘上面。
尽管恢复窗口设置为2天,但两天内的备份恢复的话可能依赖两天前的备份,任何恢复只能从一个全备/0级备份开始,再应用增量备份或归档日志
persistent and automatic backup retention policy. When a backup retention
policy is in effect, RMAN considers backups of datafiles and control files as
obsolete, that is, no longer needed for recovery, according to criteria that
you specify in the CONFIGURE command. You can then use the REPORT
OBSOLETE command to view obsolete files and DELETE OBSOLETE to delete them.
RMAN不会自动删除已经废弃的备份!
they are no longer needed to satisfy the retention policy. RMAN can
identify the obsolete files for you, but it does not automatically delete
them. You must use the DELETE OBSOLETE command to delete files that
are no longer needed to satisfy the retention policy.
不会自动删。这个问题你建个脚本自动定期执行上述命令,扔在那不就行了。