OPS/RAC redolog questions

From: <jaysingh1_at_optonline.net>
Date: Tue, 20 Jul 2004 12:41:50 -0400
Message-id: <289480828977f8.28977f82894808@optonline.net>

dear List Members,

We have 2 Node OPS using Oracle 8.1.7 on Sun Solaris. I see some unusual behaviorn in my gv$edologfile.

How come I see TWO logfiles with the same name? Does it mean that both Node-1 and Node-2 are writing into (using) the same physical redo log file?

SQL> col member format a50
SQL> l
1* select member,count(*) from gv$logfile group by MEMBER SQL> /

MEMBER                                               COUNT(*)
-------------------------------------------------- ----------


/dev/vx/rdsk/dbdg2/idb2_redo1.log                           2

/dev/vx/rdsk/dbdg2/idb2_redo2.log                           2

/dev/vx/rdsk/dbdg2/idb2_redo3.log                           2

/dev/vx/rdsk/dbdg2/idb2_redo4.log                           2

/dev/vx/rdsk/dbdg2/idb2_redo5.log                           2

/dev/vx/rdsk/dbdg2/idb2_redo6.log                           2

6 rows selected.

SQL> SQL> !ls -l /dev/vx/rdsk/dbdg2/*redo*
crw-r--r-- 1 oracle dba 161,99003 Jul 19 06:15
/dev/vx/rdsk/dbdg2/idb2_redo1.log

crw-r--r-- 1 oracle dba 161,99004 Jul 19 06:17
/dev/vx/rdsk/dbdg2/idb2_redo2.log

crw-r--r-- 1 oracle dba 161,99005 Jul 19 06:17
/dev/vx/rdsk/dbdg2/idb2_redo3.log

crw-r--r-- 1 oracle dba 161,99024 May 20 21:44
/dev/vx/rdsk/dbdg2/idb2_redo4.log

crw-r--r-- 1 oracle dba 161,99025 Apr 15 20:47
/dev/vx/rdsk/dbdg2/idb2_redo5.log

crw-r--r-- 1 oracle dba 161,99026 Apr 15 20:47
/dev/vx/rdsk/dbdg2/idb2_redo6.log

SQL> select inst_id,group#,member from gv$logfile;

INST_ID GROUP# MEMBER

---------- ---------- --------------------------------------------------
         2          1 /dev/vx/rdsk/dbdg2/idb2_redo1.log
         2          2 /dev/vx/rdsk/dbdg2/idb2_redo2.log
         2          3 /dev/vx/rdsk/dbdg2/idb2_redo3.log
         2          4 /dev/vx/rdsk/dbdg2/idb2_redo4.log
         2          5 /dev/vx/rdsk/dbdg2/idb2_redo5.log
         2          6 /dev/vx/rdsk/dbdg2/idb2_redo6.log
         1          1 /dev/vx/rdsk/dbdg2/idb2_redo1.log
         1          2 /dev/vx/rdsk/dbdg2/idb2_redo2.log
         1          3 /dev/vx/rdsk/dbdg2/idb2_redo3.log
         1          4 /dev/vx/rdsk/dbdg2/idb2_redo4.log
         1          5 /dev/vx/rdsk/dbdg2/idb2_redo5.log
         1          6 /dev/vx/rdsk/dbdg2/idb2_redo6.log

12 rows selected.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jul 20 2004 - 11:39:07 CDT