How to move redolog files from one location to another in oracle 11g

Oracle Version :11g
OS: Rhel 6


Step 1:-Determine current location for redolog files.

SQL> column member format a40
SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                   IS_RECOVERY_DEST_FILE
---------- ------- ------- ---------------------------------------- ---------------------
         3         ONLINE  /u01/app/oracle/oradata/prim/redo03.log  NO
         2         ONLINE  /u01/app/oracle/oradata/prim/redo02.log  NO
         1         ONLINE  /u01/app/oracle/oradata/prim/redo01.log  NO

Step 2.Shutdown the database and move the redolog files into new location.

SQL>shut immediate;
SQL>! mv /u01/app/oracle/oradata/prim/redo03.log /u02/redo03.log
SQL>! mv /u01/app/oracle/oradata/prim/redo02.log /u02/redo02.log
SQL>! mv /u01/app/oracle/oradata/prim/redo01.log /u02/redo01.log

Step 3.Start the database in mount point and rename the redolog files .

SQL> startup mount
SQL> alter database rename file '/u01/app/oracle/oradata/prim/redo03.log' to '/u02/redo03.log';
SQL> alter database rename file '/u01/app/oracle/oradata/prim/redo02.log' to '/u02/redo02.log';
SQL> alter database rename file '/u01/app/oracle/oradata/prim/redo01.log' to '/u02/redo01.log';

Step 4. Open the database and check new location of redolog files.

SQL>alter database open;
SQL> column member format a40
SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER           IS_RECOVERY_DEST_FILE
---------- ------- ------- ---------------- ---------------------
         3         ONLINE  /u02/redo03.log  NO
         2         ONLINE  /u02/redo02.log  NO
         1         ONLINE  /u02/redo01.log  NO

Done..




Please share your ideas and opinions about this topic.

If you like this post, then please share with others.
Please subscribe on email for every updates on mail.