2006 年 07 月 17 日, 星期一
数据库启动关闭命令
汇总如下：
sqlplus "/as sysdba"
sqlplus /nolog
conn username/password as sysdba
startup pfile='/adf/adf/adf/init.ora';
startup
startup nomount
startup mount
alter database open;
alter database mount;
startup restrict;
alter system disable restricted session;
alter system enable restricted session;
alter database open read only;
alter database open read write;
alter system quiesce restricted;
alter system unquiesce;
startup force;
startup open recover;
alter system suspend;
alter system resume;
SQL> help shutdown
SHUTDOWN
--------
Shuts down a currently running Oracle instance, optionally closing
and dismounting a database.
SHUTDOWN [ABORT|IMMEDIATE|NORMAL|TRANSACTIONAL [LOCAL]]
SQL> help startup
STARTUP
-------
Starts an Oracle instance with several options, including mounting,
and opening a database.
STARTUP options | migrate_options
where options has the following syntax:
[FORCE] [RESTRICT] [PFILE=filename] [QUIET] [ MOUNT [dbname] |
[ OPEN [open_options] [dbname] ] |
NOMOUNT ]
where open_options has the following syntax:
READ {ONLY | WRITE [RECOVER]} | RECOVER
and where migrate_options has the following syntax:
[PFILE=filename] MIGRATE [QUIET]
v$instance.ACTIVE_STATE
v$instance.DATABASE_STATUS