RE: OPS/RAC redolog questions

From: Brian McGraw <brian.mcgraw_at_ipacc.com>
Date: Mon, 26 Jul 2004 09:20:19 -0500
Message-id: <0I1G00F2AQJBE230@sauron2.ipacc.com>

I didn't see an answer to this, so...

No. Look closely at the gv$logfile view, and you'll see that each logfile entry is associated to a specific INST_ID. Query the gv$instance view, and you'll be able to tell which instance is associated to which each logfile.

HTH- Brian

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of jaysingh1_at_optonline.net
Sent: Tuesday, July 20, 2004 11:42 AM
To: oracle-l_at_freelists.org
Subject: OPS/RAC redolog questions

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
-----------------------------------------------------------------


----------------------------------------------------------------
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 Mon Jul 26 2004 - 09:18:44 CDT