Solved

REcovering deleted records from oracle database.

Posted on 2008-06-13
5
798 Views
Last Modified: 2008-09-27
I have mistaken deleted records from a table in a database ( Oracle) , How can i retrieve the information back into the database.
0
Comment
Question by:FranklinRaj22
5 Comments
 
LVL 47

Accepted Solution

by:
schwertner earned 168 total points
Comment Utility
Have you committed the transaction? If not then issue 'rollback' command.
If you have commited the try to flashback the table:

SELECT * FROM my_table AS OF TIMESTAMP (sysdate - 0.3);

If you see the deleted records create a new table:

CREATE TABLE copy_my_table AS (SELECT * FROM my_table AS OF TIMESTAMP (sysdate - 0.3));

0.3 stands for fraction of the day, so it means close to 7 hours in the past.
0
 
LVL 34

Assisted Solution

by:johnsone
johnsone earned 166 total points
Comment Utility
If that does not work and your database is in archive log mode, you should be able to use Log Miner to recover the records.
0
 
LVL 16

Assisted Solution

by:rolutola
rolutola earned 166 total points
Comment Utility
If you are NOT in archivelog mode, I dread to think, you have 2 options.

1. Shutdown and restore from backup

2. Create a duplicate instance, restore to last cold backup, export the table and import it into the live instance.

If you are in ARCHIVELOG mode, then don't panic, you don't have to lose data.

R.

0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Left Justify field in Oracle 6 69
Oracle SQL Select Statement 19 58
oracle rollup query 3 34
Oracle -- identify blocking session 24 22
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  â€¦
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to recover a database from a user managed backup

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now