OraFAQ Forum: Backup & Recovery » How to recover only one table with no flashback option in 9i

Home » RDBMS Server » Backup & Recovery » How to recover only one table with no flashback option in 9i

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

How to recover only one table with no flashback option in 9i [message #266080]

Sun, 09 September 2007 09:48

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.

Report message to a moderator

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

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

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.

Report message to a moderator

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

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

Report message to a moderator

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

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Oh yes. I have not seen that. Thanks Mohammad Taj.

Report message to a moderator

Previous Topic:	dbverify
Next Topic:	Export User and conserves his userid

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 06:26:00 CDT 2024