This article explains the steps for multiplexing redologs in oracle RAC. Multiplexing means to keep multiple copies of redo log in different diskgroup. It is similar to that of multiplexing in standalone, Only change is RAC will have threads for node.
i.e a 2 node RAC will have 2 threads. So while adding redolog group, we need to mention the thread parameter. Basically, we need to add new redolog groups in required diskgroup and drop the old ones.

1. Current redo log status:

Currently, the redologs are under +DATA diskgroup, which we will multiplex to +REDOA,+REDOB diskgroup and resize to 5G each.

2. Add logfile groups for node 1 :(THREAD 1)

3. Add logfile groups for node 2 : (THREAD 2)

4. Drop the old redolog groups:

The old redolog groups are 1,2,3,4. And We can drop only the redolog groups whose status is INACTIVE.
Currently group 1, 3 are INACTIVE. Let’s drop them first.

Now we need to drop group 2, 4. But their status is CURRENT. So any attempt to drop these loggroups will result in below error.

ORA-01623: log 1 is current log for instance test (thread 1) – cannot drop

So to make them inactive, switch logfiles multiple time, till the status changes to INACTIVE.

As now both are in the INACTIVE state, Let’s drop them.

Now all the old the redolog groups were dropped. With this multiplexing activity completed.

For resizing redolog groups , we can follow the same above steps.

For any queries, please post in our FORUM.