用rman 不备份某个表空间

原创 Linux操作系统作者：paulyibinyi 时间：2007-12-22 09:27:41 0 删除编辑

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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-1085/，如需转载，请注明出处，否则将追究法律责任。