Your database has to be in archivelog mode first.

hth

-----Original Message-----
From: Bhaskar
[mailto:oracledba-ezmlmshield-x41739641.[Email address protected]
Sent: Wednesday, June 02, 2004 6:37 AM
To: LazyDBA.com Discussion
Subject: 10 G flashback query


Hi,

Actually I'm trying to turn on the flashback query feture but I'm
finding following errors.

SQL> ALTER DATABASE FLASHBACK ON;
ALTER DATABASE FLASHBACK ON
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE
ORA-38707: Media recovery is not enabled.


Anyone can give me the list of commands i need to execute in order to
enable that feature.

BR,
Bhaskar.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page