[ suadhm @ 29.08.2007. 12:23 ] @


Želi da omogućim flashback recovery na jednoj testnoj Oracle 10g bazi.
Sve potrebno sam odradio:

1. Podesio da baza radi u ARCHIVELOG modu.
2. Omogućio sam flash recovery area.
3. Podesio parametre DB_RECOVERY_FILE_DEST i DB_RECOVERY_FILE_DEST_SIZE.
4. Sada je trebalo samo da omogućim flashback, postupak je sledeći:

a. Baza se ugasi, a zatim se podigne u mount režimu.
b. Podesi se paramaetar DB_FLASHBACK_RETENTION_TARGET.
c. I na kraju se omogući flashback pomoću komande: ALTER DATABASE FLASHBACK ON;
Tu mi se javlja problem, neće da odradi ovu naredbu i vraća poruku: ORA-00439: feature not enabled: Flashback Database

Kada ukucam: ALTER tablespace .... FLASHBACK ON; to mi odradi bez problema, ali za cijelu bazu neće.

Ima li ko iskustva sa Flashback recovery, gdje sam pogriješio u postupku?

Ima li ko rešenje?

Unaprijed hvala.
[ suadhm @ 30.08.2007. 14:06 ] @


Evo kako sam pokušao da odradim ovo:

E:\oracle\product\10.2.0\db_1\BIN>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on ╚et Kol 30 14:31:03 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected.
SQL> select flashback_on, log_mode from v$database;

FLASHBACK_ON LOG_MODE
------------------ ------------
NO NOARCHIVELOG

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 293601280 bytes
Fixed Size 1248624 bytes
Variable Size 88081040 bytes
Database Buffers 201326592 bytes
Redo Buffers 2945024 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter system set db_flashback_retention_target=4320;

System altered.

SQL> alter system set db_recovery_file_dest_size=536870912;

System altered.

SQL> alter system set db_recovery_file_dest='D:\oracle\oradata\flash_recovery_area';

System altered.

SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-00439: feature not enabled: Flashback Database

I to je to, ne mogu dalje, čak sam reinstalirao bazu i sve odradio iz početka i opet ista greška.

Baza je 10g R2 (10.2.0.1) a OS je Windows XP SP2, a probao sam i na Windows 2000 Server i ista greška.

Može li mi ko pomoći???



[ suadhm @ 10.09.2007. 08:20 ] @


Konačno sam riješio problem: baza mora biti Enterprise Edition.