RE: add logfile member to flash recovery area

From: Randy Johnson <randyjo_at_sbcglobal.net>
Date: Mon, 9 Jul 2007 16:50:07 -0500
Message-ID: <005401c7c273$1ddd04c0$c4fda80a@scraunch>

Just create a new set of logfile groups and drop the old set. If you have the "db_recovery_file_dest" and "db_create_file_dest" parameters configured correctly then Oracle will create two members for each of your logfiles using syntax similar to the following:

alter database add logfile group 6 logfile size 50m;

This will create one member in your db_create_file_dest and one member in your db_recovery_file_dest.
After you create your new set of redo logs you can just drop the old ones.

-Randy

Randy Johnson
Sr. Technical Consultant
Enkitec, LLP

Office ..... 817-255-3580
Mobile .... 817-564-6583
Email ..... HYPERLINK

"mailto:randy.johnson_at_enkitec.com"randy.johnson_at_enkitec.com

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of LS Cheng
Sent: Monday, July 09, 2007 4:59 AM
To: ORACLE-L
Subject: add logfile member to flash recovery area

I just configured a flash recovery area using ASM, I was wondering if anyone know the command to add a logfile member to FRA?

ALTER DATABASE
ADD LOGFILE MEMBER
TO GROUP 1; does not work

ALTER DATABASE
ADD LOGFILE MEMBER '+DGFRA01'
TO GROUP 1; works but it's not adding to FRA, if it is V$LOG.IS_RECOVERY_DEST_FILE would show YES but shows NO.

The only I have found is recreating the groupbut I guess there must be some sort of command :-?

thanks

--

LSC No virus found in this incoming message. Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.2/891 - Release Date: 7/8/2007 6:32 PM

No virus found in this outgoing message. Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.2/891 - Release Date: 7/8/2007 6:32 PM

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jul 09 2007 - 16:50:07 CDT