Home » RDBMS Server » Backup & Recovery » Is there anyway to restore data? (Oracle 10g, Windows)
Is there anyway to restore data? [message #473854] Wed, 01 September 2010 03:43 Go to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
I've got a situation, in my proc DB, it's No Archivelog, none backup still now. Just few minutes, some one deleted all data of 61 tables - critical data.

Is there any way to restore data? I knew it's difficult, also impossible, but ...

Thank you!
Re: Is there anyway to restore data? [message #473855 is a reply to message #473854] Wed, 01 September 2010 03:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is your recyclebin active?

select value from v$system_parameter where name = 'recyclebin';


Regards
Michel
Re: Is there anyway to restore data? [message #473858 is a reply to message #473854] Wed, 01 September 2010 04:10 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, M.Cadot!

The Recyclebin is on, but all data have been deleted and committed.
Re: Is there anyway to restore data? [message #473862 is a reply to message #473858] Wed, 01 September 2010 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oh! I thought the table was dropped, if the data has been commited try flashback query:

insert into mytable
select * from mytable as of timestamp to_timestamp('<date/time before delete','timestamp format')
/

Regards
Michel
Re: Is there anyway to restore data? [message #473864 is a reply to message #473854] Wed, 01 September 2010 04:35 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Yes! Thank you, sir!

I've done flashback query for this task. I've restored data in 31 tables, however, I could not continue because some one open the App, then, new data is inserted into Sad

Thank again, sir!
Re: Is there anyway to restore data? [message #473866 is a reply to message #473864] Wed, 01 September 2010 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It does not matter you can retrieve the old as I said or you can create a new table with this statement and then save these old data and then ask application manager what to do with them. The important part is that you can (may) retrieve the deleted data what you have to do with them after that is another question.

For you now, the most important part is:
* backup your database (regurlarly)
* Set it in archivelog mode

Regards
Michel
Re: Is there anyway to restore data? [message #473868 is a reply to message #473866] Wed, 01 September 2010 04:53 Go to previous message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you for your guide!

I knew it's important to put DB in archive and make backup, however, it's difficult to extent storage if it's full - ~2tb data on 2tb storage Very Happy
Previous Topic: RMAN 9i and 10g
Next Topic: Restore RMAN BACKUP
Goto Forum:
  


Current Time: Fri Mar 29 05:13:23 CDT 2024