Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to add redo log group to a RAC instance containing both ASM and non ASM

User_H4VX1Apr 21 2015 — edited May 2 2015

Hi gurus,

We have a 3 node RAC instance.2 nodes are on ASM and 1 is on non ASM.

I need to add a redo log group for each thread.

I am using the following statement to do that

alter database add logfile thread 1 group 5 ('+DATA','+DATA') size 10m;

My question is how can I allow the instance on non asm to use the group.

Is their any other way to achieve this?

As I am a newbie to RAC and ASM administration it will be really helpful if any one of you can provide some guidance.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 30 2015

Added on Apr 21 2015

#automatic-storage-management, #performance-availability

13 comments

4,969 views