学习oracle技术,每天学一点,每天进步一点
用rman 不备份某个表空间
上一篇 /
下一篇 2007-12-22 09:27:41
/ 个人分类：rman备份与恢复
For example, you can exclude testing tablespaces cwmlite and example from
)Z D{
\Fso)[0whole database backups as follows:ITPUB个人空间z,FCC'i*u
CONFIGURE EXCLUDE FOR TABLESPACE cwmlite;
ad!U xv"m0CONFIGURE EXCLUDE FOR TABLESPACE example;ITPUB个人空间)i4ML1]#}$w
If you run the following command, then RMAN backs up all tablespaces in the
6\0Q V'cb|%k`0database except cwmlite and example:
;x4m%K/K.^a0BACKUP DATABASE;
\/@V i:Hq O!Su Z0You can still back up the configured tablespaces by explicitly specifying them in aITPUB个人空间,I Bpy5a7m]
BACKUP command or by specifying the NOEXCLUDE option on a BACKUP DATABASE
$yK a5N\kLA W:~ q0command. For example, you can enter one of the following commands:
6y j*X U6h b0BACKUP DATABASE NOEXCLUDE; # backs up the whole database, including cwmlite and example
:FNa gy'V} { T0BACKUP TABLESPACE cwmlite, example; # backs up only cwmlite and example
j"sO R jN'^.E&FCB0You can disable the exclusion feature for cwmlite and example as follows:ITPUB个人空间 hY)Z5p,Le
CONFIGURE EXCLUDE FOR TABLESPACE cwmlite CLEAR;ITPUB个人空间a6E:d8tO T
CONFIGURE EXCLUDE FOR TABLESPACE example CLEAR;
]
r f C6c3w
Y0RMAN includes these tablespaces in future whole database backups.
7n6KWN'@ KzJ~S0Note: If you use Oracle Enterprise Manager, then you can use theITPUB个人空间&y#J(_ ay#}QO$Q
Maintenance wizard to exclude tablespaces from backups.ITPUB个人空间{iU o;h(z%^} j6s
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG:
