« 2009系统架构师大会 补记 | Blog首页 | Oracle 11g R2 For Linux发布 - 2009-08-31 »
RMAN排除备份 Exclude带来的Obsolete影响
作者:eygle | 【转载请注出处】|【云和恩墨 领先的zData数据库一体机 | zCloud PaaS云管平台 | SQM SQL审核平台 | ZDBM 数据库备份一体机】
链接:https://www.eygle.com/archives/2009/09/rman_excludeobs.html
最近注意到,在Oracle9i中,一旦实施了Rman的排除表空间备份,Exclude的表空间在RMAN中一直会被认为是Need Backup的,从而会导致Oracle认为之前的备份一直是有用的,不能被Obsolete所抛弃。链接:https://www.eygle.com/archives/2009/09/rman_excludeobs.html
这就会为备份集管理带来一系列的问题。
RMAN> report need backup;这被定义为一个Bug,在Oracle 10g中被修正,在10gR2中,排除表空间之后,RMAN如下报告:
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
7 0 /dev/rrac_statspack
RMAN> report need backup;Oracle在Bug 3736736修正中澄清,修正后,如果有效备份中不包含排除表空间,则备份将不保留用于恢复排除表空间的归档。
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
file 4 is excluded from whole database backup
-The End-
历史上的今天...
>> 2015-09-01文章:
>> 2011-09-01文章:
>> 2007-09-01文章:
>> 2006-09-01文章:
>> 2005-09-01文章:
By eygle on 2009-09-01 08:34 | Comments (0) | Backup&Recovery | 2380 |