Home » RDBMS Server » Backup & Recovery » recovering deleted records..!
recovering deleted records..! [message #131829] Tue, 09 August 2005 11:38 Go to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
hai,

we need to recover the deleted records from a table which was commited at that time.how to recover those deleted records from the database...?plz help out with detailed command.

regards
bala
Re: recovering deleted records..! [message #131845 is a reply to message #131829] Tue, 09 August 2005 13:40 Go to previous messageGo to next message
dvranga
Messages: 3
Registered: August 2005
Location: Atlanta
Junior Member
How about Exp/Imp? What oracle version?

Vijay
Re: recovering deleted records..! [message #131852 is a reply to message #131829] Tue, 09 August 2005 14:47 Go to previous messageGo to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
db-->9i

other than imp/exp , we need to use other strategy to do this..?
Re: recovering deleted records..! [message #131895 is a reply to message #131852] Wed, 10 August 2005 00:15 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Read the documentation for logminer and check . it might work for u.

Re: recovering deleted records..! [message #132159 is a reply to message #131895] Thu, 11 August 2005 02:58 Go to previous messageGo to next message
cliff_tian
Messages: 3
Registered: August 2005
Junior Member
Yeah, the best way is using logminer.
Easily, the 9i OEM can help you achieve this, but need OEM repository installed.

Another way is to restore with backup and recover to the point of time.

Third way is build a databse based on your backup and get the table, then export to production.

The first way is simple!
icon14.gif  Re: recovering deleted records..! [message #232753 is a reply to message #131829] Mon, 23 April 2007 03:29 Go to previous message
irthero
Messages: 4
Registered: April 2007
Location: INDIA
Junior Member
Cool

PLS USE THIS BELOW COMMAND FOR RECEOVER DELETED RECORDS

INSERT INTO TABLE_NAME SELECT * FROM TABLE_NAME
AS OF TIMESTAMP TO_TIMESTAMP('01-APR-2007 10:15:12 PM','DD-MON-YYYY HH:MI:SS PM') WHERE CLAUSE

-RAM
Previous Topic: Oracle Disaster recovery query - Veritas Volume replicator and Flashsnap
Next Topic: HOW TO ALL TABLES IN DATABASE AT ONCE
Goto Forum:
  


Current Time: Mon Dec 05 14:42:04 CST 2016

Total time taken to generate the page: 0.10112 seconds