From the course: Oracle Database 12c: Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Shutdown

Shutdown - Oracle Database Tutorial

From the course: Oracle Database 12c: Administration

Start my 1-month free trial

Shutdown

“

- [Instructor] We have a similar story for shutting down the Oracle Instance. Going from a running database state to a ... Well, not running. We have several methods or modes of database shutdown you can use. These different modes determine how cleanly is the database shutdown procedure performed, compared to the time it will take. Starting off with the SHUTDOWN ABORT command. If we run the SHUTDOWN ABORT command, it will take the Oracle database from an open, or on state, to an off state immediately. However, because of its brute-force nature, the database will not be consistent upon shut down. And when you will restart the database, Oracle will have to use the redo log files to perform automatic crash recovery. It is similar to pulling the plug of the Oracle database. That might sound scary, but as long as you don't have any corruptions in your database data files or missing redo logs, you should be okay. The SHUTDOWN ABORT mode is usually used when there is no other method of…

Contents