How To Move Oracle Online Redo Log Files
Issue
You have online redo log files in the wrong place and want to move them.
Solution
[sql]select l.group# group_number<br />
, l.status group_status<br />
, f.member group_member<br />
, f.status file_status<br />
from v$log l<br />
, v$logfile f<br />
where l.group# = f.group#<br />
order by l.group#, f.member;[/sql]
[sql]sqlplus /nolog<br />
connect / as sysdba<br />
alter database add logfile (‘/path/to/new/redo_01_01.log’,’/path/to/new/redo_01_02.log’;) size 150M;<br />
alter database add logfile (‘/path/to/new/redo_02_01.log’,’/path/to/new/redo_02_02.log’;) size 150M;[/sql]
[sql]alter system switch logfile;[/sql]
[sql]alter database drop logfile group GROUP#;[/sql]
References
Oracle® Database Administrator’s Guide – Managing the Redo Log
Leave a Reply
Want to join the discussion?Feel free to contribute!