ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 用rman 不备份某个表空间

用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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: in 和exists的用法
请登录后发表评论 登录
全部评论
oracle 10g ocm oracle 10g/11g/12c ocp aix 6.1 administrator,ogg expert,ITSS 技术交流群 201703254 微信公众号 paulyibin 探讨技术,开心工作 电话 13719354869 ,深入研究数据库和开始研究big data

注册时间:2007-12-11

  • 博文量
    905
  • 访问量
    6492868