Home » RDBMS Server » Backup & Recovery » How to use flashback to recover Tablespace? (oracle10gR2 Solaris5.9)
How to use flashback to recover Tablespace? [message #308630] Tue, 25 March 2008 01:55 Go to next message
wxfjordan
Messages: 92
Registered: December 2006
Member

If I dropped a tablespace, can I use flashback to recover this tablespace?

Report message to a moderator

Re: How to use flashback to recover Tablespace? [message #308634 is a reply to message #308630] Tue, 25 March 2008 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't use flashback to recover a tablespace if you didn't PREVIOUSLY put the database in flashback mode.

Now, you have to restore/recover the database up to the time of tablespace was dropped.

Regards
Michel

Report message to a moderator

Re: How to use flashback to recover Tablespace? [message #308660 is a reply to message #308630] Tue, 25 March 2008 02:44 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
I think you had previously on your flashback feature.
Now you can't use flashback feature merely to flashback of individual tablespace.
You have to issue flashback database to flashback the whole database in the point previously to get tablespace back.

Report message to a moderator

Re: How to use flashback to recover Tablespace? [message #308712 is a reply to message #308630] Tue, 25 March 2008 04:47 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Wouldn't log miner help in getting the tablespace back?

Report message to a moderator

Re: How to use flashback to recover Tablespace? [message #308722 is a reply to message #308712] Tue, 25 March 2008 05:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No, you can't go back transactions on SYS tables (technically you could but I will not risk anything on this).

Regards
Michel

Report message to a moderator

Re: How to use flashback to recover Tablespace? [message #309796 is a reply to message #308630] Fri, 28 March 2008 19:35 Go to previous message
d.c.b.a
Messages: 44
Registered: March 2005
Location: China
Member
In this case, you need to keep the data files of that tablespace, and the online redo logs / archive logs of when you dropped the tablespace. we can extract the tables name and data object id mapping relation from the redo logs to fasten the data recovery.

You can get in touch with Oracle for DUL service, or get in touch with me for AUL service.

Thanks.

[Updated on: Sat, 29 March 2008 01:36] by Moderator

Report message to a moderator

Previous Topic: Cold Backup Error
Next Topic: Data Block corrupted
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 18:27:10 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.