OraFAQ Forum: Backup & Recovery » About Flashback Feature / Column recovery (merged)

Home » RDBMS Server » Backup & Recovery » About Flashback Feature / Column recovery (merged)

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

About Flashback Feature / Column recovery (merged) [message #244840]

Thu, 14 June 2007 05:08

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

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.

Report message to a moderator

Re: About Flashback Feature. [message #244857 is a reply to message #244841]

Thu, 14 June 2007 06:31

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

Report message to a moderator

Re: About Flashback Feature. [message #244938 is a reply to message #244857]

Thu, 14 June 2007 12:25

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