Home » RDBMS Server » Backup & Recovery » About Flashback Feature / Column recovery (merged)
About Flashback Feature / Column recovery (merged) [message #244840] Thu, 14 June 2007 05:08 Go to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I have dropped a column from a table. How I can recover it. I have seen that in recycle bin there is no entry for this table .

[Updated on: Sat, 16 June 2007 14:33] by Moderator

Report message to a moderator

About Flashback Feature. [message #244841 is a reply to message #244840] Thu, 14 June 2007 05:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

In my database flashback feature is not enabled. But I saw in the recycle bin there are 3 dropped tables. And I can flashback them easily. Now my question is if they can be flashback so why is it essential to on flashback feature if I want to recover table to prior drop state.

Another question is if I dropped any column oif a table how I can recover them if I dont on my flashback feature as well as if I on my flashback feature.
Re: About Flashback Feature. [message #244857 is a reply to message #244841] Thu, 14 June 2007 06:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are several flashback features in Oracle.
Flashback to before drop relies on recycle bin but not on flashback feature you're thinking of.
This one (activated with alter database flashback on) is for flashback database/table to a point in time.
There are also flashback queries and transaction that relies on undo data and allow you to retrieve previous data, for instance.

Regards
Michel
Re: About Flashback Feature. [message #244938 is a reply to message #244857] Thu, 14 June 2007 12:25 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Now my question is if they can be flashback so why is it essential to on flashback feature if I want to recover table to prior drop state.


Its necessary for full database flash back option but not for table to restore it from recyclebin.
Because when you enable flashback it start recording of your database status and when you want to use flash back its reads thats flash back logs.there are two new feature also used to fine out SCN_TO_TIMESTAMP and TIMESTAMP_TO_SCN.

more info

http://www.psoug.org/reference/convert_func.html

[Updated on: Thu, 14 June 2007 12:30]

Report message to a moderator

Re: Colum Recovery [message #245407 is a reply to message #244840] Sat, 16 June 2007 14:04 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Restore the whole table from the backup?
Re: Colum Recovery [message #245410 is a reply to message #244840] Sat, 16 June 2007 14:32 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't repeat the same question.

Regards
Michel

[Updated on: Sat, 16 June 2007 14:33]

Report message to a moderator

Previous Topic: System Change Number issue
Next Topic: Taking hot back up that are more than 2GB are a problem
Goto Forum:
  


Current Time: Wed Dec 07 18:36:41 CST 2016

Total time taken to generate the page: 0.14891 seconds