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/

Oracle LazyDBA home page