Search This Blog

Tuesday, June 10, 2008

Enabling FLAHSBACK database

Database FLAHSBACK option is introduce in oracle 10g version.

and it is only available with ENTERPRISE EDITION,

if we have STANDARD EDITION or OTHER then you can't use FLAHSBACK DATABASE option.

if we trying to enable FLASHBACK DATABASE option then we are getting below error message

ORA-00439:feature not enabled: string

Flashback database option is enabled or not, we can check in v$option or v$version data dictionary view

Now if we are on ENTERPRISE EDITION and want to enable FLASHABACK database, so below are steps for this

1. We need to set below three parameters

1. db_recovery_file_dest

For FLASHBACK RECOVERY AREA LOCATION

2. db_recovery_file_dest_size

For FLASHBACK RECOVERY AREA size

3. db_flashback_retention_target

This parameter value specify in MINUTE, default value is 1440 minute. This parameter is use for how far back in time the database may be flashed back.

NOTE: All three parameter are DYNAMIC so no need to bounce database to take effect the parameter value.

Steps for enable flashback database

1. we can check flashback database is enable or not?

select flashback_on from v$database

NO --mean disable, YES -- mean enable

2. shutdown the database

SQL>shutdown immediate

3. startup the database in mount mode

SQL> startup mount

4. enable the flashback database

SQL> alter database flashback on;

5. open the database

SQL> alter database open;


9 comments:

Anonymous said...

hi.
I am Mohammad Tajbakhsh from IRAN and i found your blog today.
I am a beginner DBA and i found our names are simillar to each oither.
i find too much usefull articles here.
nice to find you sir.
Best Regards.
v_taj_b@yahoo.com

Anonymous said...

Hi Taj,
to make flashback on, i'm getting the following error
ORA-00439:feature not enabled-flashback database

Anonymous said...

hi Taj,
i'm getting the error ora-00439 while putting flashback on

Anonymous said...

hi Taj,
i'm getting the error ora-00439 while putting flashback on

titty said...

hi Taj,
i'm getting the error ora-00439 while putting flashback on

Anonymous said...

hi Taj,
i'm getting the error ora-00439 while putting flashback on

Anonymous said...

hi taj
i have same problem
ORA-00439:feature not enable
m using 10g express edition and i have done all things..
in archive log mode, flashback retention time,flash recovery area, recovery file size
i know the steps already you have mentioned..
but i am getting same error on executing command
alter database set flashback on..
reply me asap

Anonymous said...

I wonder if there is any way to activate this feature without changing the version. fmaia@r7.com

Anonymous said...

I wonder if there is any way to activate this feature without changing the version. fmaia@r7.com