Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

104

积分

0

好友

4

主题
1#
发表于 2012-5-2 21:55:56 | 查看: 2808| 回复: 1
各位,问个问题,如果将rman的autobackup  controlfile设置为on,那么在每次做ddl操作的时候,是否,rman会自动备份controlfile?或者说是DB的物理结构发生改变了(如删除一个表)就会自动的备份controlfile?请明示。。。
2#
发表于 2012-5-2 22:32:46
Oracle联机文档:
you can configure RMAN to automatically back up the control file and server
parameter file. The autobackup occurs whenever a backup record is added. If the
database runs in ARCHIVELOG mode, then an autobackup is also taken whenever the
database structure metadata in the control file changes. A control file autobackup
enables RMAN to recover the database even if the current control file, recovery
catalog, and server parameter file are lost.
Again:
control file autobackup
The automatic backup of the current control file and server parameter file that RMAN
makes after backups and, if the database is in ARCHIVELOG mode, after structural
changes.

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-25 01:25 , Processed in 0.049118 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569