Add Redo LogFile Member

Add Redo LogFile Member 1

List Current LogFiles Information. 1

Creating Online Redo Log Members. 1

Check the Current Change. 2

Swith the LogFiles. 2

List Current LogFiles Information

SQL> SELECT * FROM V$LOGFILE order by GROUP# asc;

GROUP# STATUS TYPE MEMBER

---------- ------- ------- -----------------------------------------------

1 STALE ONLINE E:\ORACLE\ORADATA\ORCL\REDO01.LOG

2 ONLINE E:\ORACLE\ORADATA\ORCL\REDO02.LOG

3 ONLINE E:\ORACLE\ORADATA\ORCL\REDO03.LOG

SQL> SELECT * FROM V$LOG;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM

---------- ---------- ---------- ---------- ---------- --- ---------------- -------------

1 1 77 104857600 1 YES INACTIVE 4405018 10-SEP-06

2 1 78 104857600 1 YES INACTIVE 4504818 11-SEP-06

3 1 79 104857600 1 NO CURRENT 4560152 25-JAN-07

Creating Online Redo Log Members

SQL> ALTER DATABASE ADD LOGFILE MEMBER 'C:\OraData\orcl\REDO01a.LOG' TO GROUP 1;

SQL> ALTER DATABASE ADD LOGFILE MEMBER 'C:\OraData\orcl\REDO02a.LOG' TO GROUP 2;

SQL> ALTER DATABASE ADD LOGFILE MEMBER 'C:\OraData\orcl\REDO03a.LOG' TO GROUP 3;

Check the Current Change

SQL> SELECT * FROM V$LOGFILE order by GROUP# asc;

GROUP# STATUS TYPE MEMBER

---------- ------- ------- --------------------------------------------------------------------------------

1 STALE ONLINE E:\ORACLE\ORADATA\ORCL\REDO01.LOG

1 INVALID ONLINE C:\ORADATA\ORCL\REDO01A.LOG

2 ONLINE E:\ORACLE\ORADATA\ORCL\REDO02.LOG

2 INVALID ONLINE C:\ORADATA\ORCL\REDO02A.LOG

3 ONLINE E:\ORACLE\ORADATA\ORCL\REDO03.LOG

3 INVALID ONLINE C:\ORADATA\ORCL\REDO03A.LOG

Swith the LogFiles

--After SWITCHING the logfile status invalid is eliminated

SQL> ALTER SYSTEM SWITCH LOGFILE ;

SQL> ALTER SYSTEM SWITCH LOGFILE ;

SQL> ALTER SYSTEM SWITCH LOGFILE ;

SQL> ALTER SYSTEM SWITCH LOGFILE ;

SQL> SELECT * FROM V$LOGFILE;

GROUP# STATUS TYPE MEMBER

---------- ------- ------- --------------------------------------------------------------------------------

3 ONLINE E:\ORACLE\ORADATA\ORCL\REDO03.LOG

2 ONLINE E:\ORACLE\ORADATA\ORCL\REDO02.LOG

1 ONLINE E:\ORACLE\ORADATA\ORCL\REDO01.LOG

1 ONLINE C:\ORADATA\ORCL\REDO01A.LOG

2 ONLINE C:\ORADATA\ORCL\REDO02A.LOG

3 ONLINE C:\ORADATA\ORCL\REDO03A.LOG