relocate redo logfiles

[Jean-Paul]

Hello,

Does anybody know how I move my redo logfiles from one harddisk to another? Is there a statement or do I have to rebuild my database/controlfile?

Thanks in advance,

Jean-Paul

[pando]

do yourself a favour, go to tahiti.oracle.com, read administrator guide, the chapter that says "MANAGE REDO LOGS"

[Jean-Paul]

Thanks. Couldn't find the guide that quick but search for manage redo log brought me here:

http://www.samoratech.com/OraAdmin/swmanageredo.htm

[Rohit]

Hi

Shutdown the database

Copy the file to the new location

Startup mount

Alter database rename file 'old path' to 'new path';

Alter datbase open;

Query the V$logfile

Seelan

[marist89]

Originally posted by Rohit
Hi

Shutdown the database

Copy the file to the new location

Startup mount

Alter database rename file 'old path' to 'new path';

Alter datbase open;

Query the V$logfile

This is a case study of how NOT to do it in a 24x7 environment.

1. add new log files in your new location.
2. switch logfile until you are using one of your new log files.
3. drop the old log files.

[rsuri]

as Jeff already mentioed, the correct way is to -

# create new logfiles
# keep switching logfiles so that the old files are in Inactive status
# drop old logfiles (and then remove from the OS)

[thanigai]

first make sure the member you want to switch is in inactive..
then drop the first member..
alter database drop logfile member 'path'
#reate member with new location...
alter database add logfile member 'newpath' to group1
switch logfile..
alter system switch logfile...

follow this to create log files in diff location...even DB is open.

Thanks.
Thanigaivasan.