LEARN ORACLE DBA: Control File and Redo log File Management In Oracle

CONTROL FILE AND REDO LOG FILE

Multiplexing the control file

Steps:-

1. Sql> ALTER SYSTEM SET CONTROL_FILES =’/u02/user18/test/control/control01.ctl’, ’/u02/user18/test/control/control02.ctl’ SCOPE=spfile;

2. Sql>SHUTDOWN IMMEDIATE;

3. $cp /u02/user18/test/control/control01.ctl /u02/user18/test/control/control02.ctl

4. Sql> STARTUP

5. Sql> SELECT NAME FROM V$CONTROLFILE;

Adding redo log group to the database

Sql>ALTER DATABASE ADD LOGFILE GROUP 4 ('/u02/user18/test/log/redo10a.log' , '/u02/user18/test/log/redo10b.log') SIZE 10m;

Adding redo log member to existing group

SQL>ALTER DATABASE ADD LOGFILE MEMBER '/u02/user18/test/log/redo2c.log’   TO GROUP 4;

Droping redo log group from database

Sql>ALTER DATABASE DROP LOGFILE GROUP 4;

Drop redo log member from the database

Sql>ALTER DATABASE DROP LOGFILE MEMBER ‘/u02/user18/test/log/redo2c.log’;

Resizing redo log member

             Steps:-

             Sql> ALTER DATABASE ADD LOGFILE MEMBER ‘/u02/user18/test/log/redo01b.log’

                      SIZE 10M TO GROUP 1;

             Sql> ALTER DATABASE ADD LOGFILE MEMBER ‘/u02/user18/test/log/redo02b.log’

                            SIZE 10M TO GROUP 2;

             Sql> ALTER SYSTEM SWITCH LOGFILE;

             Sql> ALTER DATABASE DROP LOGFILE MEMBER ‘/u02/user18/test/log/redo01a.log’;

             Sql> ALTER DATABASE DROP LOGFILE MEMBER ‘/u02/user18/test/log/redo02a.log’;

Views:-

V$CONTROLFILE

V$LOGFILE

V$LOG

RAC