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

From: Tommy Pham <tpham_at_specialized.com>
Date: 1997/03/12
Message-ID: <33272228.308D@specialized.com>#1/1

Booster 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.

Hi,
I would first copy the file to a new location, then rename the log. Make sure that you're not picking on the active log. Also, I would do this procedures in restricted mode, just to be safe.

Tommy Received on Wed Mar 12 1997 - 00:00:00 CST