eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 2009系统架构师大会 补记 | Blog首页 | Oracle 11g R2 For Linux发布 - 2009-08-31 »

RMAN排除备份 Exclude带来的Obsolete影响
modb.pro

最近注意到,在Oracle9i中,一旦实施了Rman的排除表空间备份,Exclude的表空间在RMAN中一直会被认为是Need Backup的,从而会导致Oracle认为之前的备份一直是有用的,不能被Obsolete所抛弃。

这就会为备份集管理带来一系列的问题。

RMAN> report need backup;

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
这被定义为一个Bug,在Oracle 10g中被修正,在10gR2中,排除表空间之后,RMAN如下报告:
RMAN> report need backup;

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
Oracle在Bug 3736736修正中澄清,修正后,如果有效备份中不包含排除表空间,则备份将不保留用于恢复排除表空间的归档。

-The End-





历史上的今天...
    >> 2015-09-01文章:
    >> 2011-09-01文章:
    >> 2007-09-01文章:
           Oracle view V$SQLAREA Definition
    >> 2006-09-01文章:
           终于收到ITPUB的T-Shirt衫
    >> 2005-09-01文章:

By eygle on 2009-09-01 08:34 | Comments (0) | Backup&Recovery | 2380 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com