Backup&Recovery
2009-09-01
RMAN排除备份 Exclude带来的Obsolete影响
最近注意到,在Oracle9i中,一旦实施了Rman的排除表空间备份,Exclude的表空间在RMAN中一直会被认为是Need Backup的,从而会导致Oracle认为之前的备份一直是有用的,不能被Obsolete所抛弃。
这就会为备份集管理带来一系列的问题。
-The End-
这就会为备份集管理带来一系列的问题。
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 风云再起:去IOE并不是一个趋势 理性选择才是趋势
- 2011-09-01 2011Oracle技术嘉年华-OTN CHINA TOUR大会
- 2007-09-01 Oracle view V$SQLAREA Definition
- 2006-09-01 终于收到ITPUB的T-Shirt衫
- 2005-09-01 Oracle 10g Release 2 new tools:asmcmd