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
Printable View
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
do yourself a favour, go to tahiti.oracle.com, read administrator guide, the chapter that says "MANAGE REDO LOGS"
Thanks. Couldn't find the guide that quick but search for manage redo log brought me here:
http://www.samoratech.com/OraAdmin/swmanageredo.htm
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
This is a case study of how NOT to do it in a 24x7 environment.Quote:
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
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.
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)
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.