Re: redo log files

Sure, but to avoid downtime:

1. Create new logfiles in the new location
2. Drop the old logfiles.
3. If you get an error indicating that the logfile is in use: Alter system switch logfile; Then try to drop the logfile again.
4. Tadaaaa. Suddenly you have new logfiles and have avoided downtime.

Petter Henrik Hansen
DBA
Fellesdata AS
petter.hansen_at_fellesdata.no

Rob Medley wrote:

> Hi,
> 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.
>
> The redo log files are not in a tablespace. If you want to get a list, then
> select * from v$logfile;
>
> Cheers,
>
> Rob Medley
> medleyrk_at_iafrica.com
>
> David Nguyen wrote:
>
> > Hello,
> >
> > The DBA before me installed oracle 7.3 on NT and placed the online redo log
> > files on the same disk where the data files resides. I would like to move
> > this to another drive. Is the correct procedure to:
> >
> > 1. shutdown my instance
> >
> > 2. move the log files and rename the file using alter database
> >
> > 3. restart my instance
> >
> > Also, how would I find out what tablespace the redo log files are placed in?
> > I checked the dba_data_files and it is not there.
> >
> > Thanks,
> >
> > Dave
> >
> > -**** Posted from Supernews, Discussions Start Here(tm) ****-
> > http://www.supernews.com/ - Host to the the World's Discussions & Usenet
Received on Sun Nov 29 1998 - 16:17:59 CST