数据库的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.查看数据状态