oracle数据库状态是started,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.数据库限制状态