GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Backup and Recovery
Go To First  |  Previous Question  |  Next Question 
 Backup and Recovery  |  Question 2 of 42    Print  
What are the steps involved in Database Shutdown ?
Close the Database, Dismount the Database and Shutdown the Instance.



  
Total Answers and Comments: 7 Last Update: October 25, 2007   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: sanjay
 

There are four types of shutdown

Shutdown Normal - Normal is the default mode, here new user can't logon to the database, but the current user can start the new transaction and work till he wants, the database shutdown only after the last user logs off.

Shutdown Transactional - here new user can't logon to the database, and the current user can't start the new transaction, once the current transaction complets, database shutdown.

Shutdown Immediate - here new user can't logon to the database, user can't start the new transaction, the current transactions rolls back, and database shutdown.

Shutdown Abort - here new user can't logon to the database, user can't start new transaction, the current transaction is not rolled back, database shutdown's.

While shutting down oracle updates data file header and control file with the current checkpoint informanation, Except Shutdown Abort the checkpoint is same in datafile header and control file it means database is consistance and it is clean shutdown. If the checkpoint is not same at both locations then instance recovery required at next startup.

I hope it will clear your doughts.



Above answer was rated as good by the following members:
contactspatel, rnraomaddula
October 13, 2005 14:45:55   #1  
sandeep vig        

RE: What are the steps involved in Database...

u can give either of the four commands depends on the priority

1) shutdown

2)shutdown immediate

3)shutdown transactional

4)shutdown abort

in shutdown abort recoverry is required


 
Is this answer useful? Yes | No
August 29, 2006 03:53:13   #2  
sanjay        

RE: What are the steps involved in Database...

There are four types of shutdown

Shutdown Normal - Normal is the default mode here new user can't logon to the database but the current user can start the new transaction and work till he wants the database shutdown only after the last user logs off.

Shutdown Transactional - here new user can't logon to the database and the current user can't start the new transaction once the current transaction complets database shutdown.

Shutdown Immediate - here new user can't logon to the database user can't start the new transaction the current transactions rolls back and database shutdown.

Shutdown Abort - here new user can't logon to the database user can't start new transaction the current transaction is not rolled back database shutdown's.

While shutting down oracle updates data file header and control file with the current checkpoint informanation Except Shutdown Abort the checkpoint is same in datafile header and control file it means database is consistance and it is clean shutdown. If the checkpoint is not same at both locations then instance recovery required at next startup.

I hope it will clear your doughts.


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
November 20, 2006 09:53:09   #3  
ravi        

RE: What are the steps involved in Database...

the question is steps of shutdown the database not the types of shutdown of database these are two different questions.

steps are

close the database

dismount the database

and shutdown the instance

types of shutdown of databses are

1. shutdown normal

2. shutdown transactional

3. shutdown immediate

4. shutdown abort


 
Is this answer useful? Yes | No
March 30, 2007 18:03:04   #4  
Chiranjeevi Manne        

RE: What are the steps involved in Database...
Types of oracle instance shutdown:
1. SHUTDOWN NORMAL
2. SHUTDOWN IMMEDIATE
3. SHUTDOWN TRANSACTIONAL
4. SHUTDOWN ABORT --> Needs Database Recovery.

 
Is this answer useful? Yes | No
September 19, 2007 04:14:24   #5  
Mohammed Abdul Afroze        

RE: What are the steps involved in Database...
The steps involved in database shutdown are as follows:

1. Shutdown
2.
Shutdown Transaction
3. Shutdown Immediate
4. Shutdown Abort

Shutdown: This is a Normal Shutdown. Only SYSDBA gets the privilege to shutdown the database.

Shutdown Transactional: This is also a graceful shutdown. It will wait until all the users ends their session.
Shutdown Immediate: This is also an graceful shutdown. It will rollback all the transactions if it is not committed.
Shutdown abort: This is also an ungraceful shutdown. Memory wont be
synchronized.

 
Is this answer useful? Yes | No
October 19, 2007 07:27:00   #6  
sathyagowri Member Since: October 2007   Contribution: 1    

RE: What are the steps involved in Database...
Shutting Down Database:
Shutdown ModeAITN
Allow New ConnectionsXXXX
Wait until current session endsXXXO
Wait until current transaction endsXXOO
Force a check point and close filesXOOO



N-Normal T-Transactional I-Immediate & A-Abort

X
O

No

Yes


 
Is this answer useful? Yes | No
October 25, 2007 14:25:32   #7  
satyam_2007 Member Since: October 2007   Contribution: 5    

What are the steps involved in Database...
There are the following steps of shutting down the database and it's associated instance:

1)Close the database.
2) Unmount the database.
3)Shut down the instance.

1) Close a database:
When we close the database oracle writes all the data and recovery data in the SGA to the datafiles and redo log files. Next orcale close all online datafiles and redo log files.
Any offline datafiles of any offline tablespace have been closed already.

2) Unmount the database:

After the database has been closed Oracle unmount the database to diassociate it from its instance. At this point instance remains in the memory of the computer.
After the database is unmounted Oracle closes the control files of the database.

3) Shut down an Instance:

The final step in the shut down the database is the shutting down an instance The SGA is removed from the memory and the background processes are terminated.


Thanks & Regards
Satyam

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape