oracle数据库open_mode的改变

数据库的open_mode有read only和read write 中，要改变需要重新启动数据库。

一.read only

1.关闭数据库 shutdonw immediate;

2.启动数据库到mount状态

ora_test@oracle[/home/oracle]> sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Sun Mar 7 17:27:26 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. idle> startup mount; ORACLE instance started. Total System Global Area 209715200 bytes Fixed Size 1218532 bytes Variable Size 113248284 bytes Database Buffers 88080384 bytes Redo Buffers 7168000 bytes Database mounted.

3.启动数据库到只读模式

idle> alter database open read only; Database altered. idle> select open_mode from v$database; OPEN_MODE ---------- READ ONLY idle>

二.read write

1.关闭数据库 shutdonw immediate;

2.启动数据库到mount状态

ora_test@oracle[/home/oracle]> sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Sun Mar 7 17:27:26 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. idle> startup mount; ORACLE instance started. Total System Global Area 209715200 bytes Fixed Size 1218532 bytes Variable Size 113248284 bytes Database Buffers 88080384 bytes Redo Buffers 7168000 bytes Database mounted.

3.打开数据库这个与alter database open  的作用是一样的。

4.查看数据状态