Home » RDBMS Server » Backup & Recovery » How can recover uncommitted data? (Oracle 10g, Windows XP)
How can recover uncommitted data? [message #419432] Sat, 22 August 2009 03:58 Go to next message
shaeer
Messages: 1
Registered: August 2009
Location: India
Junior Member
How can recover uncommitted data after server down due to power failure without shutdown the database?

Report message to a moderator

Re: How can recover uncommitted data? [message #419446 is a reply to message #419432] Sat, 22 August 2009 08:13 Go to previous messageGo to next message
ebrian
Messages: 2786
Registered: April 2006
Senior Member
You can't. Check Automatic Recovery After Instance Failure: Crash Recovery.

Report message to a moderator

Re: How can recover uncommitted data? [message #419455 is a reply to message #419432] Sat, 22 August 2009 09:45 Go to previous message
Michel Cadot
Messages: 54247
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Uncommitted data never existed for the database.
So as Brian said you can't.

Regards
Michel

Report message to a moderator

Previous Topic: RMAN hotbackup (merged 3)
Next Topic: A special instance recovery
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 25 18:45:38 CDT 2013

Total time taken to generate the page: 0.12033 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.