Re: Adding Redo Log group and files

From: John Chiu <johnymc_at_netscape.net>
Date: Sat, 6 Nov 1999 07:54:22 -0500
Message-ID: <8018cp$gk2$1@news2.tor.accglobal.net>

You can issue a log switch by running ALTER SYSTEM SWITCH LOGFILE:

SQL> select group#, status, substr(member,1,40) member from v$logfile;

GROUP# STATUS MEMBER

--------- ------- ----------------------------------------
        2         F:\ORANT\DATABASE\LOG3ORCL.ORA
        2         F:\ORANT\DATABASE\LOG4ORCL.ORA
        1 STALE   F:\ORANT\DATABASE\LOG1ORCL.ORA
        1 STALE   F:\ORANT\DATABASE\LOG2ORCL.ORA

SQL> alter database add logfile group 3 ('f:\orant\database\log5orcl.ora', 2 'f:\orant\database\log6orcl.ora') size 16k;

Database altered.

SQL> select * from v$log;

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

--------- --------- --------- --------- --------- --- ---------------- -----
-------- ---------
        1         1        94   1048576         2 NO  INACTIVE
125067 05-NOV-99
        2         1        95   1048576         2 NO  CURRENT
145101 06-NOV-99
        3         1         0     16384         2 YES UNUSED

SQL> select group#, status, substr(member,1,40) member from v$logfile;

GROUP# STATUS MEMBER

--------- ------- ----------------------------------------
        2         F:\ORANT\DATABASE\LOG3ORCL.ORA
        2         F:\ORANT\DATABASE\LOG4ORCL.ORA
        1 STALE   F:\ORANT\DATABASE\LOG1ORCL.ORA
        1 STALE   F:\ORANT\DATABASE\LOG2ORCL.ORA
        3         F:\ORANT\DATABASE\LOG5ORCL.ORA
        3         F:\ORANT\DATABASE\LOG6ORCL.ORA

6 rows selected.

SQL> alter system switch logfile;

System altered.

SQL> select * from v$log;

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

--------- --------- --------- --------- --------- --- ---------------- -----
-------- ---------
        1         1        94   1048576         2 NO  INACTIVE
125067 05-NOV-99
        2         1        95   1048576         2 NO  INACTIVE
145101 06-NOV-99
        3         1        96     16384         2 NO  CURRENT

145190 06-NOV-99 SQL> select group#, status, substr(member,1,40) member from v$logfile;

GROUP# STATUS MEMBER

--------- ------- ----------------------------------------
        2         F:\ORANT\DATABASE\LOG3ORCL.ORA
        2         F:\ORANT\DATABASE\LOG4ORCL.ORA
        1 STALE   F:\ORANT\DATABASE\LOG1ORCL.ORA
        1 STALE   F:\ORANT\DATABASE\LOG2ORCL.ORA
        3         F:\ORANT\DATABASE\LOG5ORCL.ORA
        3         F:\ORANT\DATABASE\LOG6ORCL.ORA

6 rows selected.

SQL> alter system switch logfile;

System altered.

SQL> select * from v$log;

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

--------- --------- --------- --------- --------- --- ---------------- -----
-------- ---------
        1         1        97   1048576         2 NO  CURRENT
145191 06-NOV-99
        2         1        95   1048576         2 NO  INACTIVE
145101 06-NOV-99
        3         1        96     16384         2 NO  INACTIVE

145190 06-NOV-99 SQL> select group#, status, substr(member,1,40) member from v$logfile;

GROUP# STATUS MEMBER

--------- ------- ----------------------------------------
        2         F:\ORANT\DATABASE\LOG3ORCL.ORA
        2         F:\ORANT\DATABASE\LOG4ORCL.ORA
        1         F:\ORANT\DATABASE\LOG1ORCL.ORA
        1         F:\ORANT\DATABASE\LOG2ORCL.ORA
        3         F:\ORANT\DATABASE\LOG5ORCL.ORA
        3         F:\ORANT\DATABASE\LOG6ORCL.ORA

6 rows selected.

HTH John Chiu

Christ Follower <christ_follower_at_my-deja.com> wrote in message news:80053g$n5m$1_at_nnrp1.deja.com...
> When my database was created, the redo log files are not mirrored. How
> can I add more groups and files to address this problem? I tried ALTER
> DATABASE ADD LOGFILE MEMBER command to add additional files to an
> existing group. Then I checked v$logfile but they were reported
> INVALID. What did I miss? Thanks.
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Nov 06 1999 - 06:54:22 CST