cancel
Showing results for 
Search instead for 
Did you mean: 

Recover a deleted record / table

former_member199632
Participant
0 Kudos

Hello,

Our Oracle DB (10.2.0.4) is on archive mode. But flashback is not enabled

In such cases, If a user deleted a table entry / a entire table itself, Is it possible to recover

How to solve this kind of a issue.

Is it really deleting from the DB or else is it just mark as flag (flag as deleted.)

regards,

Zerandib

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hai...

For your requirement Flash back to be set to on, then only possible.

Former Member
0 Kudos

Here are two SDN blogs on flashback query:

[Get me my data back! QUICK!|/people/lars.breddemann/blog/2007/05/09/get-me-my-data-back-quick|]

[How to get those accidentally deleted rows back (on Oracle)|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/9379] [original link is broken] [original link is broken] [original link is broken];

Cheers Michael

stefan_koehler
Active Contributor
0 Kudos

Hello Zerandib,

depending on how the user deleted the data (DML = DELETE or DDL = TRUNCATE) from the entire table or just a table entry - you can use flashback query. Flashback query works with the undo data - so you can flashback your table until UNDO_RETENTION.

Official documentation:

http://download.oracle.com/docs/cd/E11882_01/appdev.112/e17125/adfns_flashback.htm#ADFNS01003

If the data is not stored in undo tablespace anymore - you can also use the LogMiner to rebuild your data with help of the archive logs:

http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/logminer.htm#SUTIL1553

If your entire table was deleted with DDL (TRUNCATE) you need to restore your whole database and recover it.

Regards

Stefan

Former Member
0 Kudos

Hello,

Well to recover that table entry or the table, system needs to be restored using latest full backup and applying archive logs till before the point of time you lost that table.

Thanks