ORACLE数据库状态与v$instance视图

1.   数据库STARTED状态

SQL> startup nomount

ORACLE instance started.

 

Total System Global Area  285212672 bytes

Fixed Size                  1218968 bytes

Variable Size             121636456 bytes

Database Buffers          155189248 bytes

Redo Buffers                7168000 bytes

 

SQL> select status from v$instance;

 

STATUS

------------

STARTED

2.   数据库MOUNTED状态

SQL> alter database mount;

 

Database altered.

 

SQL> select status from v$instance;

 

STATUS

------------

MOUNTED

3.   数据库OPEN状态

SQL> alter database open;

 

Database altered.

 

SQL> select status from v$instance;

 

STATUS

------------

OPEN

4.   数据库非限制状态

SQL> select logins from v$instance;

 

LOGINS

----------

ALLOWED

5.   数据库限制状态

SQL> alter system enable restricted session;

 

System altered.

 

SQL> select logins from v$instance;

 

LOGINS

----------

RESTRICTED

 

SQL> alter system disable restricted session;

 

System altered.

6.   数据库非挂起状态

SQL> select database_status from v$instance;

 

DATABASE_STATUS

-----------------

ACTIVE

7.   数据库挂起状态

SQL> alter system suspend;

 

System altered.

 

SQL> select database_status from v$instance;

 

DATABASE_STATUS

-----------------

SUSPENDED

 

SQL> alter system resume;

 

System altered.

8.   数据库静默状态

SQL> alter system quiesce restricted;

 

System altered.

 

SQL> select active_state from v$instance;

 

ACTIVE_ST

---------

QUIESCED

9.   数据库非静默状态

SQL> alter system unquiesce;

 

System altered.

 

SQL> select active_state from v$instance;

 

ACTIVE_ST

---------

NORMAL

 

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

转载于:http://blog.itpub.net/183159/viewspace-732514/