Originally posted by samdba
Hi all,

Happy New Year to all.

We have two Redo log groups having 3 members each. But, since the begining, all members of a particular log group are on the same disk. Oracle recommends to have members of the same group on a separate disk so that in case a particular disk fails, we do not loose all members and there is no need to do database recovery.

Now, pl. tell me what is the procedure for relocating the members on separate disks.

Thanks in Adv.
Great question to research on your own given that you've stated you want to get certified.