René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Add a member to a redo group [Oracle]

I have two redo log group with one member for each: 
select group#, bytes/1024/1024, members from v$log;

    GROUP# BYTES/1024/1024    MEMBERS
---------- --------------- ----------
         1              50          1
         2              50          1
I want to add a member to each redo group. First, I determine the file names of the existing members: 
select group#, substrb(member, 1, 90) from v$logfile;

    GROUP# SUBSTRB(MEMBER,1,90)
---------- -----------------------------------------------------------------------------
         2 E:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_2NQLFJ4W_.LOG
         1 E:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_2NQLFG7B_.LOG
Then I add the members: 
alter database add logfile member 'E:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\GROUP_1_MEMBER_2.LOG' to group 1;
alter database add logfile member 'E:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\GROUP_2_MEMBER_2.LOG' to group 2;

Links

See also Other redo log related administrative tasks.