2

i m using oracle 10g and i want to enable flashback database i hava manually run all the command like

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?

skaffman
  • 398,947
  • 96
  • 818
  • 769
Bhavana
  • 329
  • 2
  • 4
  • 9

2 Answers2

2

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."

Dave Costa
  • 47,262
  • 8
  • 56
  • 72
  • You can enable flashback database after a clean shutdown and your DB in Mount (or Open) - cite "Ensure the database instance is open or mounted" in Chap7 - Oracle doc 12c Backup & Recovery manual. The problem with the question is "VERSION" not enable flashback database feature! – Duong May 05 '19 at 14:59
0

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