Home » RDBMS Server » Backup & Recovery » How to recover only one table with no flashback option in 9i
How to recover only one table with no flashback option in 9i [message #266080] Sun, 09 September 2007 09:48 Go to next message
coolboy2005in
Messages: 12
Registered: July 2007
Location: Herndon
Junior Member
We have a table whose rows were deleted by a developer some time ago.(Faulty codes...)

He deleted the table in the morning and we came to know about it in the Afternoon.

We were able to restore the table from the backup by first restoring the tablespace to the point just before the disaster & took the backup of the table & again restored the tablespace up to the last transaction and then recreated the table.
This caused some down time due to which our manager was not so happy with us.

I just want to know ( The Logic) if there is any way by which we could have recovered this table without taking any down time.

This happened on database 9i R2. My platform is RHEL4.
Re: How to recover only one table with no flashback option in 9i [message #266081 is a reply to message #266080] Sun, 09 September 2007 09:56 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

One possible workaround is :

1. Create New (dummy) database with production last valid backup.
2. export that particular table from dummy created database
3. import that table in production database.

Regards
Taj

[Updated on: Sun, 09 September 2007 09:56]

Report message to a moderator

Re: How to recover only one table with no flashback option in 9i [message #266121 is a reply to message #266080] Sun, 09 September 2007 22:02 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

In addition to Mohammad Taj,

1)Check your recycle bin to see if table exist there or not. Most probably it will be there and you will be so much lucky.


2)And if you enable your flashback feature then dropping table!! Don't worry. You can flashback it .

From backup restore whole tablespace is really cumbersome.

Check out two above scenario and take action.

Re: How to recover only one table with no flashback option in 9i [message #266133 is a reply to message #266121] Sun, 09 September 2007 23:30 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
flashback drop table(recyclebin) option is introduce in Oracle10g.
and OP is using oracle 9i.


Regards
Taj
Re: How to recover only one table with no flashback option in 9i [message #266134 is a reply to message #266080] Sun, 09 September 2007 23:40 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Oh yes. I have not seen that. Thanks Mohammad Taj.
Previous Topic: dbverify
Next Topic: Export User and conserves his userid
Goto Forum:
  


Current Time: Sat Dec 10 11:11:46 CST 2016

Total time taken to generate the page: 0.09819 seconds