开发者

flashback recovery in oracle 10g

i m using oracle 10g and i want to enable flashback database i hava manually run all the command lik开发者_开发问答e

SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;

SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=536870912;

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='/C/TEMP1';
SQL> ALTER DATABASE OPEN;
SQL>ALTER DATABASE FLASHBACK ON;

it shows the error like

ORA-00439: feature not enabled : Flashback Database

plz anyone can help me to setup the flashback database?


Jeffrey Kemp's comment is correct. ALTER DATABASE FLASHBACK ON cannot be specified while the database is open. SQL Reference manual states: "You can specify this clause when the database is mounted but not open."


Most likely is that you are not using the Enterprise Edition. Do you happen to be on Standard Edition or XE ?

Ronald - who thinks this question fits better in http://dba.stackexchange.com

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜