OraFAQ Forum: Backup & Recovery » how to recover before 15 minutes table data from flashback

Home » RDBMS Server » Backup & Recovery » how to recover before 15 minutes table data from flashback (oracle 11.2.0.2.0 linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to recover before 15 minutes table data from flashback [message #548608]

Fri, 23 March 2012 08:23

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

Report message to a moderator

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

nehhaverma
Messages: 34
Registered: September 2009
Location: JAIPUR

Member

could u please reply on my post.

Report message to a moderator

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

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

We do not owe you anything, do NOT demand for an anwer and do NOT use IM/SMS speak.

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

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

Regards
Michel

Report message to a moderator

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

BlackSwan
Messages: 26766
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/

Report message to a moderator

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

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Backup & Recovery
Next Topic:	Partly restore a database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 23 00:30:30 CDT 2025