Re: Change the Path of REDOLOG FILE

From: <bdbafh_at_gmail.com>
Date: 5 Jan 2006 15:44:28 -0800
Message-ID: <1136504668.209471.238700@g14g2000cwa.googlegroups.com>

Here is an offline method.

SQL> shutdown immediate
SQL> host

in your shell, copy or move the logfile(s).

SQL> startup mount;
SQL> col member format a60
SQL> select member from v$logfile;

SQL> alter database rename file '<oldpath>' to '<newpath>';

SQL> alter database open;
SQL> alter database backup controlfile to trace;

hth
-bdbafh Received on Thu Jan 05 2006 - 17:44:28 CST