• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

recovering truncated table from db back up

A table was accidentaly truncated. The data in that table is kind of snapshot and even if we re-run the program that populated the table we will not able to reconcile it to the data the table previously contained before truncating.

Is there a way to recover this data from db backups (level 0 or level 1)

Thanks,
0
gs79
Asked:
gs79
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you might be lucky and have flashback configured and running, so you might not need to "restore" anything, just "flashback" the table:
http://docs.oracle.com/cd/B13789_01/server.101/b10759/statements_9012.htm

otherwise, you will need to restore the database fully from backup (eventually to another host or instance), export the data from there, and import to your table.
0
 
Geert GOracle dbaCommented:
don't you have a standby running ?
activate that and copy the data via a db-link
0
 
gs79Author Commented:
Its a Data Warehouse db and we do not have a standby
0
 
gs79Author Commented:
Flashback is enabled and configured but since it was truncated almost 4 weeks it cannot be recovered.
we do not have a strong case to go alternate route of recovering from full db back up..

Thanks for your responses..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now