rman备份影响oracle性能,RMAN排除备份 Exclude带来的Obsolete影响

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

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

-The End-

By eygle on 2009-09-01 08:34 |

Comments (0) |

Backup&Recovery | 2380 |