difference between normal shutdown and immediate shut down

[Former Member]

hi all,

what is the difference between normal shutdown and immediate shut down.

rgds

vinnu.

[Former Member · Accepted solution]

Hi Vinay,

This is the difference

Normal - waits for in-flight work to complete

Immediate - terminates all sessions and does a rollback on all

uncommitted transactions

Abort - aborts all sessions, leaving current DML in need of rollback, de-allocates the SGA and terminates the background processes.

Thanks

Prince

[Former Member]

Hi Vinu,

Shutdown Normal waits for users to Log off and it could take a while, where as Shutdown Immediate Performs a Roll Back , Shuts down in a controlled manner.

Shutdown Abort -- it performs immediate shut down, no rollback, recovery required.

Regards,

Ershad Ahmed.

[Former Member]

Hello Vinay,

You can shut down the database as follows:

Normal

No new database logon possible.

After all database user have logged off,

the database is closed properly: all files are closed,

the database is dismounted, and the instance is shut down.

The database is consistent after shutdown.

Immediate

Only the current commands are executed.

PMON ends all sessions and performs a rollback of the open transactions.

The database is then closed properly (as for a normal shutdown).

The database is consistent after shutdown.

DBWR and ARCH might require up to 1 hour post-processing time.

Transactional

No new connections are allowed and no new transactions can be started.

Oracle waits for all open transactions to finish, then disconnects all users

(that is, work processes in the SAP system) and shuts down the database

Abort

Emergency database shutdown

Users are not logged off and open transactions are not rolled back.

The database is not consistent after shutdown.

An instance recovery is automatically performed at the next database startup.

Regards,

Ammey Kesarkar

<i>'Award points for useful info'</i>