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;

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s