recover deleted records [message #315585] |
Tue, 22 April 2008 01:33 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
Hi,
I have deleted 1000 records from the TEST table and i also commited those records.
But i want to recover those records because i deleted wrong records.
The idea which i know is that
SELECT NAME,FIRST_TIME,NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY first_time DESC;
I will chose the appropriate arcive log.
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(logfilename=>'/home/oracle/ARCHIVE_LOG/1_20_650546031.dbf',options=>DBMS_LOGMNR.NEW);
EXECUTE DBMS_LOGMNR.start_logmnr(options=>DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
SELECT username,OPERATION,sql_undo,sql_redo
FROM v$logmnr_contents
Is it a right procedure?
If yes then one more thing i would like to know is that my deleted records are in the redo log and till now archive is not generated. How can i use those redo log?
Thanks
|
|
|
|
|
|