Add Members for Online Relog File Group on RAC ASM

Let’s say you have already created logfiles from Group 1 to Group 8 on a 2 node RAC cluster on Diskgroup :+RECOC1. Now it is always highly recommended to mutiplex the relog files. This is how we will add new members to existing groups.

First let us see the commands to create the logfile groups on +RECOC1

— Add Redo LogFile’s Thread 1 —

alter database add logfile thread 1 group 1 (‘+RECOC1’) size 1G;

alter database add logfile thread 1 group 2 (‘+RECOC1’) size 1G;

alter database add logfile thread 1 group 3 (‘+RECOC1’) size 1G;

alter database add logfile thread 1 group 4 (‘+RECOC1’) size 1G;
— Add Redo LogFile’s Thread 2 —

alter database add logfile thread 2 group 5 (‘+RECOC1’) size 1G;

alter database add logfile thread 2 group 6 (‘+RECOC1’) size 1G;

alter database add logfile thread 2 group 7 (‘+RECOC1’) size 1G;

alter database add logfile thread 2 group 8 (‘+RECOC1’) size 1G;

 

Now we will add membersto all above created groups  in diskgroup +DATAC1

ALTER DATABASE
ADD LOGFILE MEMBER ‘+DATAC1’
TO GROUP 1;

ALTER DATABASE
ADD LOGFILE MEMBER ‘+DATAC1’
TO GROUP 2;

ALTER DATABASE
ADD LOGFILE MEMBER ‘+DATAC1’
TO GROUP 3;

ALTER DATABASE
ADD LOGFILE MEMBER ‘+DATAC1’
TO GROUP 4;

ALTER DATABASE
ADD LOGFILE MEMBER ‘+DATAC1’
TO GROUP 5;

ALTER DATABASE
ADD LOGFILE MEMBER ‘+DATAC1’
TO GROUP 6;

ALTER DATABASE
ADD LOGFILE MEMBER ‘+DATAC1’
TO GROUP 7;

ALTER DATABASE
ADD LOGFILE MEMBER ‘+DATAC1’
TO GROUP 8;

 

 

Leave a Reply