Renaming a redo log group member

Steps to rename redo log file member :

1.shutdown the database

2.copy the redo log file member from existing location to new location with different name

3.start the database

4.issue alter database rename file command

5.alter database open

 

SQL> @redo.sql

                Note : Dont modify the CURRENT & ACTIVE state redo log files.

SQL> shut immediate

SQL> exit

oracle> cd /u02/app/oracle/crms

oracle> ls

oracle> cp redo04.log redo04b.log

oracle> ls

oracle> export ORACLE_SID=crms

oracle> sqlplus / as sysdba

SQL> alter database rename file

                '/u02/app/oracle/crms/redo04.log' to

                '/u02/app/oracle/crms/redo04b.log';

SQL> alter database open;

SQL> @redo.sql