1. 首页 > ITPUX技术网 > 正文

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

用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.

本文由风哥教程整理发布,仅用于学习测试使用,转载注明出处:http://www.fgedu.net.cn/10327.html

联系我们

在线咨询:点击这里给我发消息

微信号:itpux-com

工作日:9:30-18:30,节假日休息