OPS/RAC redolog questions
- From: jaysingh1@xxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 20 Jul 2004 12:41:50 -0400
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
