ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 不能从open read only直接转换为open read write

不能从open read only直接转换为open read write

原创 Linux操作系统 作者:aimos 时间:2010-08-19 16:46:43 0 删除 编辑
今天群里的兄弟提了个问题,正好我也不知道,又从群里学了一点新东西。
问题:只读打开数据库: startup open read only 后,能不能在不重启实例的情况下,将数据库的模式转变为read write?
过程:首先,实验了几种方法,不行,然后看了官方文档,没有相关选项,后来群里兄弟查了一下,发现了比较权威的说法:
You Asked
Hi Tom,

Once I open the Database using ALTER DATABASE OPEN READ ONLY, how can I change the status
to READ WRITE??

Can a Database that is in Read-Write mode to be changed to Read-Only and Vis-Versa??

Thanks and I appreciate your help..

Kandy Train..


and we said...
read only and read write are modifiers of the alter database OPEN clause.

since an instance may mount and open only one database (you have to "kill it" and create
a new instance - set of processes plus memory), you have to in effect shutdown and
restart the instance to go from read only to read write or vice versa.
结果:只能重启实例,以read write方式打开数据库。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23230551/viewspace-671405/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-01-23

  • 博文量
    15
  • 访问量
    35510