From oracle-l-bounce@freelists.org Mon Jul 26 09:18:44 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6QEIJn02806 for ; Mon, 26 Jul 2004 09:18:29 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6QEI6602774 for ; Mon, 26 Jul 2004 09:18:17 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0B28F72C626; Mon, 26 Jul 2004 08:56:39 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05173-80; Mon, 26 Jul 2004 08:56:38 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4FC5872CA1A; Mon, 26 Jul 2004 08:56:38 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 26 Jul 2004 08:55:04 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B199E72C8B3 for ; Mon, 26 Jul 2004 08:55:03 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04928-75 for ; Mon, 26 Jul 2004 08:55:03 -0500 (EST) Received: from infinity-insurance.com (frodo.infinity-insurance.com [208.147.170.20]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1039772C41F for ; Mon, 26 Jul 2004 08:55:03 -0500 (EST) Received: from ([10.80.2.3]) by frodo.infinity-insurance.com with ESMTP id 133020032.13439722; Mon, 26 Jul 2004 09:21:11 -0500 Received: from ipacc.com ([10.80.2.4]) by sauron2.ipacc.com (Sun Java System Messaging Server 6.1 (built Apr 28 2004)) with ESMTP id <0I1G00F29QJBE230@sauron2.ipacc.com> for oracle-l@freelists.org; Mon, 26 Jul 2004 09:21:12 -0500 (CDT) Received: from ([10.15.3.185]) by sauron3.ipacc.com with ESMTP id KP-XXM31.1230280; Mon, 26 Jul 2004 09:20:17 -0500 Date: Mon, 26 Jul 2004 09:20:19 -0500 From: Brian McGraw Subject: RE: OPS/RAC redolog questions In-reply-to: <289480828977f8.28977f82894808@optonline.net> To: oracle-l@freelists.org Message-id: <0I1G00F2AQJBE230@sauron2.ipacc.com> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Thread-index: AcRueNtxFN3HQZv7TYeXQVo5yGixXAEop/pg X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5980 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: brian.mcgraw@ipacc.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of jaysingh1@optonline.net Sent: Tuesday, July 20, 2004 11:42 AM To: oracle-l@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@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@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 -----------------------------------------------------------------