用rman不备份oracle数据库某个表空间的方法

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:262

用rman不备份oracle数据库某个表空间的方法

For example, you can exclude testing tablespaces cwmlite and example from
whole database backups as follows:

CONFIGURE EXCLUDE FOR TABLESPACE cwmlite;
CONFIGURE EXCLUDE FOR TABLESPACE example;

If you run the following command, then RMAN backs up all tablespaces in the
database except cwmlite and example:
BACKUP DATABASE;

You can still back up the configured tablespaces by explicitly specifying them in a
BACKUP command or by specifying the NOEXCLUDE option on a BACKUP DATABASE
command. For example, you can enter one of the following commands:
BACKUP DATABASE NOEXCLUDE; # backs up the whole database, including cwmlite and example
BACKUP TABLESPACE cwmlite, example; # backs up only cwmlite and example

You can disable the exclusion feature for cwmlite and example as follows:
CONFIGURE EXCLUDE FOR TABLESPACE cwmlite CLEAR;
CONFIGURE EXCLUDE FOR TABLESPACE example CLEAR;
RMAN includes these tablespaces in future whole database backups.
Note: If you use Oracle Enterprise Manager, then you can use the
Maintenance wizard to exclude tablespaces from backups.

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】