Click here to Skip to main content
15,919,879 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
A table with with more than 10 lacs record has been dropped unknowingly. And we maintain incremental backup so no luck we found because it happened 5 days back.
Some say like if the transaction log has the event logged then no matter we can recover...but our technical dba says if the session of the connection is closed then no longer the log maintained.
Is it correct?.if so then how can i recover.... please help me...it is very urgent
Thanks in advance!!!😞

What I have tried:

Tried to check the log.since the connection was closed...the entry in log will not be maintained and they say it cannot be recovered
Posted
Updated 24-Oct-16 23:49pm

If you had noticed sooner you could have done something but with 5 days past the data pages are probably overwritten by now.

Generally :
1) Don't allow access to the database to anyone who is not qualified (is mortified when using DROP commands)
2) Backup important data to time based files (don't overwrite the same backup file) [if storage permits]
 
Share this answer
 
Quote:
A table with with more than 10 lacs record has been dropped unknowingly.
You just learned the hard way the reason why we do backups.
Quote:
And we maintain incremental backup so no luck we found because it happened 5 days back.
A backup which can't recover things the are more than 5 days old is not a good backup and may be not called a backup at all.
Incremental backup is a technique used to reduce the size of daily backup, but it can't be used alone. Usually, it is associated with regular full backups (weekly or monthly).
When planning a backup, you have to answer a few questions:
- What can't I afford to loose ?
- For how many days should I be able to recover data ?
- How long to recover the data from a backup ?
from the answers to these questions, you deduce how to organize the backups.
And whe, you plan the backup, always ask yourself "What append in worst case ?"
 
Share this answer
 
v3
If your DBA says it's gone, it's gone - you will have to restore the "newest" backup you have and try to update it as best you can.
Let this be a lesson to you: never touch the production DB except with well tested software, and improve your backup regimen.
 
Share this answer
 
Comments
sai sruthi 25-Oct-16 3:36am    
Ya i accept but can u please tell me whether the transaction log entries are dependent on connection session?
there is command used on oracle called ( rollback)
try your luck ^_^
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900