Oracle DBA, How To, Error, Cause and Action

Oracle Database Shutdown Process (4/4)

Oracle Database Shutdown Process (1/4)
Oracle Database Shutdown Process (2/4)
Oracle Database Shutdown Process (3/4)
Oracle Database Shutdown Process (4/4) [You are here]


SHUTDOWN ABORT

This is very nasty way of shutdown Oracle, you should not perform SHUTDOWN ABORT unless is necessary. What happen with SHUTDOWN ABORT is like you power off your computer without notice to anyone. Very fast way of shutdown, when you startup the system there will be database recovery needed, that is because when you startup database all the datafiles are still "open" state, you will only can close all datafiles properly with above 3 shutdowns (NORMAL, TRANSACTIONAL, IMMEDIATE).

1. Again we have active connected session




2. SHUTDOWN ABORT command is issued



As you notice SHUTDOWN ABORT command is not going through the 3 steps of shutdown sequence, it shutdown the system is fast because it skipped 2 sequences, what SHUTDOWN ABORT did was kill all process and release the SGA.

You must not perform SHUTDOWN ABORT unless is necessary.

Oracle Database Shutdown Process (1/4)
Oracle Database Shutdown Process (2/4)
Oracle Database Shutdown Process (3/4)
Oracle Database Shutdown Process (4/4) [You are here]