Moving one member of redolog group to new location (Online)
Hello,
Oracle 11.2.0.4 no patches SE
I have 4 redo logs groups:
/opt/app/oracle/oraarch/orcl/redo01a.log - redo04a.log
/opt/app/oracle/oradata/orcl/redo01b.log - redo04b.log
I have to move all logs from oraarch to oradata2.
Usually I see offline solution which I cannot implement at that moment.
I know that I can create new redo log group eg group5 and place redo05a.log to correct location.
But I have another idea. Would following solution work ?
1. Drop from group 1 (inactive) following redologs group member:
alter database drop logfile member '/opt/app/oracle/