INTERVIEW QUESTIONS ORACLE BACKUP AND RECOVERY DETAILS

Question: What are the steps involved in Database Shutdown ?

Answer: Close the Database, Dismount the Database and Shutdown the Instance.

Close the Database, Dismount the Database and Shutdown the Instance. Source: CoolInterview.com

Normal (default) - waits for all on going transactions and sessions to complete. This could take hours 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. Note that a shutdown abort is NOT evil or dangerous. The "abort" simply means that Oracle will terminate all active work, which is what most people want during a shutdown!(while startup it may take some more time for instance recovery which will be done by SMON)

Source: CoolInterview.com

When Shutdown cmd given No new sessions allowed.
There are 4 types
Abort,Immediate,Transactional,Normal.
In abort:-Doestnt wait for current sessions,and also for current transactions.Not make checkpoint to close file.

In Immediate:-Make checkpoit and close file

In Transactional:-Wait for current transactions,Make checkpoit and close file

In Normal-Wait for current session,Wait for current transactions,finally make chckpoints and close files. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question