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