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

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
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.

Report message to a moderator

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: 68637
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 12:51:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.