To put the database in flashback mode you have to mount the database and
then alter it:
startup mount;
alter system set DB_FLASHBACK_RETENTION_TARGET=1440;
alter database flashback on;
alter database open;

The key to this is that your database HAS to be in archive log mode.
The DB_FLASHBACK_RETENTION_TARGET determines how long the flashback logs
will keep data
to allow you to flashback your data. This parameter is in increments of
minutes. The setting
of 1440 is for one day.

Regards.
Steven St. Laurent
Oracle Certified Associate.

-----Original Message-----
From: Sikyala Raquel
[mailto:oracledba-ezmlmshield-x78280292.[Email address protected]
Sent: Thursday, November 30, 2006 4:24 PM
To: LazyDBA Discussion
Subject: RE: Setting Archive_log_dest parameter :VSMail mx2


Thanks. I changed db_recovery_file_dest to '/u05/flash_recover_area'. I
checked the flashback_on value and it is no. How do I change that
setting?

Raquel Sikyala


-----Original Message-----
From: David Chiu [mailto:[Email address protected]
Sent: Thursday, November 30, 2006 1:08 PM
To: Sikyala, Raquel
Subject: RE: Setting Archive_log_dest parameter

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


Sikyala:

This is the location/destination for your instance Flashback Database
(NEW under 10g)
SQL> alter system set DB_RECOVERY_FILE_DEST='/u05/archive_log'
scope=both;


The is the location/destination for your instance archive log
SQL> alter system set log_archive_dest_1='location=/u05/archive_log'
scope=spfile;
System altered.

You might want to change the location/destination for your Flashback
Database location to somewhere else, Check to see if you are enable the
flashback feature under 10g. If you are, the following should sql query
will be YES.

Please read 10g documnetation to see if you are ready want to use the FB
feature....


SQL> select flashback_on
from v$database;

FLASHBACK_ON
------------
YES

Hope this helps,
David C


------------------------------------------------------------------------
----
David Chiu
Management Dynamics, Inc.
Database Administrator
Phone: 919.468.3445
[Email address protected]
http://www.ManagementDynamics.com/


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page