OraFAQ Forum: Backup & Recovery » Is there anyway to restore data?

Home » RDBMS Server » Backup & Recovery » Is there anyway to restore data? (Oracle 10g, Windows)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Is there anyway to restore data? [message #473854]

Wed, 01 September 2010 03:43

trantuananh24hg
Messages: 547
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!

Report message to a moderator

Re: Is there anyway to restore data? [message #473855 is a reply to message #473854]

Wed, 01 September 2010 03:53

Michel Cadot
Messages: 54155
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

Report message to a moderator

Re: Is there anyway to restore data? [message #473858 is a reply to message #473854]

Wed, 01 September 2010 04:10

trantuananh24hg
Messages: 547
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.

Report message to a moderator

Re: Is there anyway to restore data? [message #473862 is a reply to message #473858]

Wed, 01 September 2010 04:31

Michel Cadot
Messages: 54155
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

Report message to a moderator

Re: Is there anyway to restore data? [message #473864 is a reply to message #473854]

Wed, 01 September 2010 04:35

trantuananh24hg
Messages: 547
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!

Report message to a moderator

Re: Is there anyway to restore data? [message #473866 is a reply to message #473864]

Wed, 01 September 2010 04:40

Michel Cadot
Messages: 54155
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

Report message to a moderator

Re: Is there anyway to restore data? [message #473868 is a reply to message #473866]

Wed, 01 September 2010 04:53

trantuananh24hg
Messages: 547
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

Report message to a moderator

Previous Topic:	RMAN 9i and 10g
Next Topic:	Restore RMAN BACKUP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 05:56:38 CDT 2013

Total time taken to generate the page: 0.15379 seconds