Database Administration (MOSC)

MOSC Banner

Moving one member of redolog group to new location (Online)

edited Mar 6, 2020 3:32PM in Database Administration (MOSC) 7 commentsAnswered

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/

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center