不知道alter database close 有什么用？

不知道alter database close 有什么用？

 

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> alter database close;
alter database close
*
ERROR at line 1:
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

 

##还有别的session，断掉之后再执行

SQL> alter database close;

Database altered.

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16196: database has been previously opened and closed

 

##数据库关闭后，就不能再打开了

SQL> alter database dismount;

Database altered.

SQL> select status from v$instance;

STATUS
------------
STARTED

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00750: database has been previously mounted and dismounted

##卸载数据库后也就不能再挂载了

 

记得从何明或者是tom的书中看到过，一个instance在其生存期中最多只能装载和打开一个database。

 

 

下面是shutdown immediate的日志，可以看到在关闭oracle的过程中系统自动执行了这两个命令

 

Mon Aug 16 23:42:09 2010
Starting background process EMN0
Mon Aug 16 23:42:09 2010
Shutting down instance: further logons disabled
EMN0 started with pid=23, OS id=7928
Mon Aug 16 23:42:10 2010
Stopping background process QMNC
Mon Aug 16 23:42:10 2010
Stopping background process CJQ0
Mon Aug 16 23:42:12 2010
Stopping background process MMNL
Mon Aug 16 23:42:13 2010
Stopping background process MMON
Mon Aug 16 23:42:14 2010
Shutting down instance (immediate)
License high water mark = 2
Mon Aug 16 23:42:14 2010
Stopping Job queue slave processes
Mon Aug 16 23:42:19 2010
Process OS id : 7920 alive after kill
Errors in file /u01/oracle/admin/stone/udump/stone_ora_7908.trc
Mon Aug 16 23:42:19 2010
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Mon Aug 16 23:42:21 2010
ALTER DATABASE CLOSE NORMAL
Mon Aug 16 23:42:21 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Aug 16 23:42:21 2010
Shutting down archive processes
Archiving is disabled
Mon Aug 16 23:42:26 2010
ARCH shutting down
ARC2: Archival stopped
Mon Aug 16 23:42:31 2010
ARCH shutting down
ARC1: Archival stopped
Mon Aug 16 23:42:36 2010
ARCH shutting down
ARC0: Archival stopped
Mon Aug 16 23:42:37 2010
Thread 1 closed at log sequence 21
Successful close of redo thread 1
Mon Aug 16 23:42:37 2010
Completed: ALTER DATABASE CLOSE NORMAL
Mon Aug 16 23:42:37 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active