Search This Blog

Sunday, September 11, 2011

ORA-55628: Flashback Archive supports Oracle 11g or higher

Today when i am trying to enable flashback data archive on our production box upgraded from 10g to 11gr2 then got below error message
ORA-55628: Flashback Archive supports Oracle 11g or higher

but our database 11gr2 but still i am getting error message becuase compatible parameter was set to

SQL> select * from v$version;


Oracle Database 11g Enterprise Edition Release - Production

PL/SQL Release - Production

CORE Production

TNS for 32-bit Windows: Version - Production

NLSRTL Version - Production

SQL> show parameter comp


------------------------------------ ----------- ----------------

compatible string

SQL> alter system set compatible = '' scope=spfile;

System altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 945786880 bytes

Fixed Size 1384328 bytes

Variable Size 729809016 bytes

Database Buffers 209715200 bytes

Redo Buffers 4878336 bytes

Database mounted.

Database opened.

No comments: