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
精彩评论