Q
Problem solve Get help with specific problems with your technologies, process and projects.

Details of a shutdown

I would like to know the details on what happens during a shutdown, specifically between the time the database reports a successful close of redo log thread 1 and the completed alter database close normal.

During a normal shutdown, it's my understanding that Oracle will close all sessions (see modes below), close the database, unmount the data files and then shut down the instance in two steps, first issuing a "free" the SGA RAM heap and finally, terminating the background processes.

Oracle has three shutdown modes:

  • 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, deallocates the SGA and terminates the background processes.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close