Multiplexing Redolog files:

Steps for Renaming Redo Log Members

Shut down the database.

SHUTDOWN

Copy the redo log files to the new location.

Operating system files, such as redo log members, must be copied using the appropriate operating system commands.

Note:

You can execute an operating system command to copy a file (or perform other operating system commands) without

exiting SQL*Plus by using the HOST command. Some operating systems allow you to use a character in place of the

word HOST. For example, you can use an exclamation point (!) in UNIX.

The following example uses operating system commands (UNIX) to move the redo log members to a new location:

mv /diska/logs/log1a.rdo /diskc/logs/log1c.rdo

mv /diska/logs/log2a.rdo /diskc/logs/log2c.rdo

Startup the database, mount, but do not open it.

CONNECT / as SYSDBA

STARTUP MOUNT

Rename the redo log members.

Use the ALTER DATABASE statement with the RENAME FILE clause to rename the database redo log files.

ALTER DATABASE

  RENAME FILE '/diska/logs/log1a.rdo', '/diska/logs/log2a.rdo'

           TO '/diskc/logs/log1c.rdo', '/diskc/logs/log2c.rdo';

Open the database for normal operation.

The redo log alterations take effect when the database is opened.

ALTER DATABASE OPEN;

Query to check that redolog files locations.

Sql> select GROUP#,member from v$logfile;