Re: Moving Redo Log Files (Oracle 7.1.6.2 on AIX 4.1)

From: Reza Abouk <Reza.Abouk_at_mci.com>
Date: 1997/03/14
Message-ID: <33297337.4915598@news.internetmci.com>#1/1

On Wed, 12 Mar 1997 17:32:04 +0000, Booster <JFLeaver_at_darlington.ac.uk> wrote:

>How Do I move redo log files between directories? I think I should use
>'alter database rename file <orig. dir/file> <destination dir/file>' and
>then copy the log files to their new locations.
>
>Is this correct. Do I need to be wary of anything?
>
>Thanks,
>
> Jonathan Leaver.

select a.group#,a.member, b.status
from v$logfile a, v$log b
where a.group# = b.group#
/

   GROUP# MEMBER                                   STATUS
--------- ---------------------------------------- --------------
        1 /u04/oracle/dvlp/redo01.log               INACTIVE
        2 /u04/oracle/dvlp/redo02.log               INACTIVE
        3 /u04/oracle/dvlp/redo03.log               CURRENT

if you want to move only one member do:

alter database drop logfile member '/u04/oracle/dvlp/redo01.log'; alter database add logfile member

                  '/u11/oradata/dvlp/redo01.log'  to group 1;

if you want to move all members do:

alter database drop logfile group 1;
alter database add logfile group 1

     ('/u11/oradata/dvlp/redo01.log',
      '/u12/oradata/dvlp/redo01.log') size 1M;

NOTE: start from inactive ones that are not first in line after the
            current log, or try a log switch to get them in order that
            you want (for drop and recreate)

alter system switch logfile;

Reza Abouk Received on Fri Mar 14 1997 - 00:00:00 CST