打开APP
userphoto
未登录

开通VIP,畅享免费电子书等14项超值服

开通VIP
rman备份出錯
Starting backup at 04-SEP-06
channel ch00: starting full datafile backupset
channel ch00: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 09/04/2006 02:02:31
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable
00230, 00000, "operation disallowed: snapshot controlfile enqueue unavailable"
// *Cause:  The attempted operation cannot be executed at this time because
//          another process currently holds the snapshot controlfile enqueue.
// *Action: Retry the operation after the concurrent operation that is holding
//          the snapshot controlfile enqueue terminates.
 
 

如果不通过rman,oracle是无法实现联机全备的,这也是oracle比较尴尬的事情,oracle通过rman实现了联机全备,最本质的原因就是引入了snapshot controlfile,因为scn时时刻刻是要被写入控制文件的,但是联机全备时又需要短暂的锁住控制文件(全备时要保证控制文件,数据文件scn是一致的啊),这样就产生了矛盾,于是在rman中就引入了snapshot controlfile,事实上在rman备份时用snapshot controlfile临时代替了controlfile,备份之后他们之间又重新同步了 [/B]

本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请点击举报
打开APP,阅读全文并永久保存 查看更多类似文章
猜你喜欢
类似文章
rman 总结篇
黑牛的博客: rman备份、配置相关技术操作
深入浅出Oracle学习笔记(2)
OracleRMAN的备份与恢复命令详解(一)
ORACLE RMAN备份的脚本配置
Oracle 不同故障的恢复方案
更多类似文章 >>
生活服务
热点新闻
分享 收藏 导长图 关注 下载文章
绑定账号成功
后续可登录账号畅享VIP特权!
如果VIP功能使用有故障,
可点击这里联系客服!

联系客服