Change Orilglogs path

[Former Member]

hi

After a sucessfull setup of R3, is it possible to change the path of the Origlog and Mirror logs, ie i want to have the drive changed.

jonu

[Former Member]

Hi,

(Note you should take a backup before attempting this)

What you would do is create new log files (in the new path you wanted) and then drop the original logs.

1) I would save the current log locations for future reference:

select * from v$logfile;

2) Add however many new log files you need to the new locations, here's example syntax:

alter database add logfile ( '/oracle/<SID>/NewOrigLogDirA/newlogm1' ,

'/oracle/<SID>/NewMirLogDirA/newlogm2') size 100M ;

3) switch the log files (may need to switch several times) to make sure the current log is on the new one and not the old logfile:

alter system switch logfile;

select * from v$log;

--> Note which log group# is the current log, you can get the logfile name from the output of the v$logfile select statement.

4) Now you can drop the old log files

alter database drop logfile group X;

--> Where X is your old logfile groups.

Also it's not possible to drop a log file that Oracle is currently using so don't be alarmed if you try to...