Re: redo log files

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 Fri Nov 27 1998 - 14:43:48 CST