Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: OPS/RAC redolog questions
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.
-- 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
![]() |
![]() |