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
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
