Re: redo log files

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Fri, 27 Nov 1998 15:10:41 -0800
Message-ID: <Pine.OSF.3.95.981127150613.11727D-100000@gonzo.wolfenet.com>

On Fri, 27 Nov 1998, Rob Medley wrote:
>
> Correct Procedure for moving your redo logs :
> 1. Shutdown Oracle
> 2. Use operating system commands to move the files
> 3. Startup mount
> 4. Use alter database to rename(include the entire path) the redo log files
> 5. Alter database open.

It is not necessary to shut down the database to move redologs around. Just add more log groups with the log members where you want them. Afterwards, you can drop the redolog groups that were in the wrong place. You might find that one of the log groups that you try to drop is in use. If this happens, issue an "alter system switch logfile" command, and the database will start logging to one of your new logs. When the archiver is finished with the log you can drop the group.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Fri Nov 27 1998 - 17:10:41 CST