Home » RDBMS Server » Backup & Recovery » Flashback Not Enabled
Flashback Not Enabled [message #272710] Sat, 06 October 2007 08:48 Go to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member
Hi,

I am using Oracle 10g R2 version in win 2003 server. I am trying to enable flashback. I am facing ORA-00436 error msg. May i know reason why it's not enable ?

SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> STARTUP MOUNT
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1247900 bytes
Variable Size 71304548 bytes
Database Buffers 92274688 bytes
Redo Buffers 2945024 bytes
Database mounted.
SQL>
SQL> ALTER DATABASE FLASHBACK ON;
ALTER DATABASE FLASHBACK ON
*
ERROR at line 1:
ORA-00439: feature not enabled: Flashback Database


SQL> ALTER DATABASE OPEN;

Database altered.


Babu

Report message to a moderator

Re: Flashback Not Enabled [message #272716 is a reply to message #272710] Sat, 06 October 2007 09:07 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You might benefit by learning how to Read The Fine Manual.

http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14192/setup005.htm#BRBSC183

3.5.4 Setting Initialization Parameters for Size and Location of the Flash Recovery Area
To enable the flash recovery area, you must set the two initialization parameters DB_RECOVERY_FILE_DEST_SIZE (which specifies the disk quota, or maximum space to use for flash recovery area files for this database) and DB_RECOVERY_FILE_DEST (which specifies the location of the flash recovery area).

Report message to a moderator

Previous Topic: Export With DBMS_JOB
Next Topic: sys as owner of recovery catalog
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 09:33:33 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.