Peoplecnc.com - How to shutdown an Oracle Database

ERP and Technical Documentation

Oracle ERP1
JDEdwards

Topics
Home General News (1/202) ERP White Papers (0/225) JDEdwards - Peoplesoft - Oracle ERP1 White Paper (9/218) Oracle Documentation and White Papers (19/456) Oracle DBA Commands (1/222) Webserver / Apache (2/232)

User Functions
Username: Password: Don't have an account yet? Sign up as a New User Lost your password?

Events
There are no upcoming events

Older Stories

Wednesday 17-May

Thursday 11-May

Wednesday 10-May

Monday 08-May

Welcome to Peoplecnc.com
Wednesday, September 08 2010 @ 07:03 AM CDT

How to shutdown an Oracle Database

Wednesday, May 10 2006 @ 10:08 AM CDT
Contributed by: sv800
Views: 4,138

The shutdown database command explained with options

TO SHUT DOWN
To shutdown an Oracle Database, connect as SYSOPER or SYSDBA or an use with SYSDBA privileges.

SHUTDOWN

- By default, SHUTDOWN NORMAL
- Command does not allow new connections, however it waits until the current sessions ends. After a normal shutdown the next starup will be normal.

Command Options:

SHUTDOWN ABORT
- Kills all processes, do not write checkpoint
- After an Abort shutdown, the next startup requires an instance recovery.

SHUTDOWN INMMEDIATE
- Kills all processes, write checkpoints

SHUTDOWN TRANSACTIONAL
- This option prevents users from losing data in the current transaction
- Kills all processes, write checkpoints and wait for current transactions

What's Related
More by sv800 More from Oracle Documentation and White Papers

Story Options
Mail Story to a Friend Printable Story Format