Home » RDBMS Server » Backup & Recovery » how to recover before 15 minutes table data from flashback (oracle 11.2.0.2.0 linux)
how to recover before 15 minutes table data from flashback [message #548608] Fri, 23 March 2012 08:23 Go to next message
nehhaverma
Messages: 34
Registered: September 2009
Location: JAIPUR
Member
Hi

I delete some of the data from a table unfortunately and make commit on that on my production server.
kindly help me in getting back my all data of this table only of last 15 minutes.

Thanks.

Neha
Re: how to recover before 15 minutes table data from flashback [message #548610 is a reply to message #548608] Fri, 23 March 2012 09:04 Go to previous messageGo to next message
nehhaverma
Messages: 34
Registered: September 2009
Location: JAIPUR
Member
could u please reply on my post.
Re: how to recover before 15 minutes table data from flashback [message #548613 is a reply to message #548610] Fri, 23 March 2012 09:42 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
We do not owe you anything, do NOT demand for an anwer and do NOT use IM/SMS speak.

select * from t as of timestamp systimestamp-interval '15' minute;

flashback table t to timestamp systimestamp-interval '15' minute;


Regards
Michel
Re: how to recover before 15 minutes table data from flashback [message #548614 is a reply to message #548613] Fri, 23 March 2012 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 25856
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: how to recover before 15 minutes table data from flashback [message #548624 is a reply to message #548610] Fri, 23 March 2012 11:40 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
nehhaverma wrote on Fri, 23 March 2012 15:04
could u please reply on my post.


If you are able to ask for an answer you should be able to feedback to the answer we give you.

Regards
Michel

Re: how to recover before 15 minutes table data from flashback [message #549649 is a reply to message #548624] Mon, 02 April 2012 14:49 Go to previous messageGo to next message
Sticker Printing
Messages: 7
Registered: March 2012
Location: USA
Junior Member
ake commit on that on my production server.
kindly help me in getting back my all data of this table only of last 15 minutes.
Re: how to recover before 15 minutes table data from flashback [message #549685 is a reply to message #549649] Tue, 03 April 2012 01:08 Go to previous message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Who is "ake"?
Why the replies given here does not answer to your problem (which, by the way, is not clear)?

Regards
Michel
Previous Topic: Backup & Recovery
Next Topic: Partly restore a database
Goto Forum:
  


Current Time: Wed Feb 21 17:58:15 CST 2018

Total time taken to generate the page: 0.01977 seconds