What is meant by 'Bounce' the database

Hello, 

What is meant by 'Bounce' the database. I keep coming across the phrase. 
Usually after changing some parameter/setting, the paper/manual will ask us 
to 'bounce' the database (i guess, instead of shutting down the database and 
restarting it). 

How do we bounce the database. 

Thanks, 
Tom

Join this group

Popular White Paper On This Topic

•  Beginner's Guide to ERP

5 Replies

0 b 22, 2002

Unknown User replied Fe

Hello , 

bounce the database means .. 
1.Shutdown abort + Start up 
This is one atomic operation.. It requires 
instance recovery .. 

regards 
-Nirmal Kumar 
Junior DBA (Oracle) 
Savvion India Limited- Mumbai

0

Unknown User replied Feb 22, 2002

It means to restart the database.

0

Unknown User replied Feb 22, 2002

Yes the word bounce mean to stop the databse and restart the same. :-) 

-Krishna

0

Unknown User replied Feb 22, 2002

Careful. Somebody said that 'bounce' means to 'shutdown abort' and restart. 
This is not necessarily correct. Shutdown abort should NOT be used unless 
absolutely necessary. Most shutdowns can be accomplished with a 'shutdown 
immediate' (shutdown normal will wait for certain activities to finish which 
may delay your shutdown too much). 'shutdown abort' will not issue a 
checkpoint and will not synchronize all the data and control file headers. 
when you restart the database after a shutdown abort it will perform 'media 
recovery' and resychronize everything. if you have problems doing a 
shutdown immediate then go ahead and do a shutdown abort. 

hth, 
andy