Home » Other » Training & Certification » What happens when a database crashes?
What happens when a database crashes? [message #325993] Mon, 09 June 2008 20:19 Go to next message
sumsrik
Messages: 1
Registered: June 2008
Junior Member
Hi,
I have started preparation with oracle architecture.
I have a doubt..

when the user says commit after modifying the data, the database crashes suddenly. Is the data saved?How oracle engine recovers the data. How a dba knows what data is modified??

Thanks,
Suma
Re: What happens when a database crashes? [message #325994 is a reply to message #325993] Mon, 09 June 2008 20:28 Go to previous messageGo to next message
BlackSwan
Messages: 23056
Registered: January 2009
Senior Member
>when the user says commit after modifying the data, the database crashes suddenly
If the COMMIT completed, the changed data will exist after the DB is restarted.
If the COMMIT did not complete, then the changed data will be rolled back after the restart.

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting Guidelines at stated in URL above

visit http://tahiti.oracle.com & read the Concepts Manual.
Re: What happens when a database crashes? [message #326019 is a reply to message #325993] Mon, 09 June 2008 23:20 Go to previous message
Michel Cadot
Messages: 59791
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I agree with Ana if you want to undertand how Oracle works you have to read Database Concepts.
All the questions about Oracle architecture, how it works, how it is built, what are the objects and so on are answered there.

Regards
Michel
Previous Topic: How to overcome Oracle trigger mutation error?
Next Topic: Subquery in clauses 'insert' and 'values'
Goto Forum:
  


Current Time: Wed Nov 26 12:43:39 CST 2014

Total time taken to generate the page: 0.11764 seconds