oracle 启动关闭数据库

关于启动关闭数据库的一些常用操作

[@more@]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

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

转载于:http://blog.itpub.net/49731/viewspace-916477/