Startup/Shutdown Options in Oracle Database

SYSDBA or SYSOPER (or SYSASM in ASM instance) system privilege is required to issue the STARTUP & SHUTDOWN commands.

Startup optionsSTARTUP [FORCE][RESTRICT][NOMOUNT][MIGRATE][QUIET]
[PFILE=file_name | SPFILE=file_name]
[MOUNT [EXCLUSIVE] database_name | OPEN READ {ONLY | WRITE [RECOVER]}
| RECOVER database_name]
STARTUP
STARTUP OPEN
STARTUP OPEN READ ONLY
STARTUP OPEN READ WRITE
STARTUP OPEN WRITE RECOVER
STARTUP OPEN RECOVER;
STARTUP OPEN database_name PFILE=’/path/’ PARALLEL
STARTUP NOMOUNT
STARTUP MOUNT (or STARTUP MOUNT EXCLUSIVE or STARTUP MOUNT SHARED)
STARTUP RESTRICT
STARTUP RESTRICT MOUNT
STARTUP [PFILE=’/path/’] {UPGRADE | DOWNGRADE} [QUIET]
STARTUP UPGRADE
STARTUP DOWNGRADE
STARTUP MIGRATE
STARTUP FORCE (= SHUT IMMEDIATE + STARTUP)
STARTUP FORCE pfile=’/path/’
STARTUP FORCE RESTRICT PFILE=’/path/’ OPEN [database_name]
STARTUP pfile
STARTUP pfile = ‘/path/’
STARTUP spfile
STARTUP spfile = ‘/path/’

NOMOUNT — Background processes will be started upon reading the parameter file (initSID.ora) or server parameter file (spfileSID.ora) at $ORACLE_SID/dbs and allocate the shared memory and semaphores.
MOUNT — control files will be read and opened.
OPEN — datafiles, redolog files are opened.


Shutdown options

SHUTDOWN {NORMAL | TRANSACTIONAL [LOCAL] | IMMEDIATE | ABORT}
SHU
SHUT
SHUTDOWN
SHUTDOWN NORMAL

SHUTDOWN TRANSACTIONAL
SHUTDOWN TRANSACTIONAL LOCAL — in RAC environment
SHUTDOWN IMMEDIATE
SHUTDOWN ABORT


Misc

alter database mount;
alter database open;
alter database open;
alter database close;
alter database mount;
alter database dismount;
alter database open read only;
alter database mount exclusive;
alter database mount standby database;


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s