• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 492
  • 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 GruwezOracle 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

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

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