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