RE: add logfile member to flash recovery area
- From: "Randy Johnson" <randyjo@xxxxxxxxxxxxx>
- To: "'ORACLE-L'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Jul 2007 16:50:07 -0500
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@xxxxxxxxxxx"randy.johnson@xxxxxxxxxxx
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of LS Cheng
Sent: Monday, July 09, 2007 4:59 AM
To: ORACLE-L
Subject: add logfile member to flash recovery area
Hi
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
Other related posts:
