From oracle-l-bounce@freelists.org Sat Oct 1 11:41:44 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j91Gfi25024961 for ; Sat, 1 Oct 2005 11:41:44 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j91GfU6H024941 for ; Sat, 1 Oct 2005 11:41:37 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1AE3B1F01B2; Sat, 1 Oct 2005 11:41:22 -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 29652-02; Sat, 1 Oct 2005 11:41:22 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8BE981F0037; Sat, 1 Oct 2005 11:41:21 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type; b=YgUSCiQBWYJSpK3TyJtWtrgyXWCANtYZF4Se2c9kG0rIs8fTItuETartSFRA1A5VJ3TVK9aYVW0ahYw19fFPJ/D+Pe3gNZu0UGEwScaqZ9AnA3qmiDYLf4Swk4+rEpEB+eKvHSSnbc+QrJytqegqwGj3a7GNuIqLJCzEVPBz8jo= Message-ID: Date: Sat, 1 Oct 2005 12:39:27 -0400 From: Sami Seerangan To: oracle-l Subject: 2 different status on each instance (2 Node RAC Standby) MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3479_10187357.1128184767301" X-archive-position: 26206 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: dba.orcl@gmail.com Precedence: normal Reply-To: dba.orcl@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.2 required=5.0 tests=AWL,BAYES_00,HTML_60_70, HTML_MESSAGE,NORMAL_HTTP_TO_IP,UPPERCASE_25_50 autolearn=no version=2.63 ------=_Part_3479_10187357.1128184767301 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I am experiencing some weird behavior in standby database. Environment: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Sun OS 2.9, Oracle 9.2.0.6 ,Veritas 4.0 I did setup 2 Node Primary and 2 node Standby physical standby setup as below. 2 Node Primary (test1,test2) 2 Node Standby (test1,test2) Test Case: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D SQL> show parameter cluster (on both standby1 and standby2) NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cluster_database boolean TRUE cluster_database_instances integer 2 cluster_interconnects string 1) Both standby instances are in READ-ONLY mode by using SQL> ALTER DATABASE OPEN READ ONLY; Database altered. 2) From instance1 (TEST1), I issued the following command while instance2 (TEST2) is in READ-ONLY mode. SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; Database altered. 3) From instance1 (TEST1), I did SQL> select dbid,name,database_role,open_mode,SWITCHOVER_STATUS from v$database; DBID NAME DATABASE_ROLE OPEN_MODE SWITCHOVER_STATUS ---------- --------- ---------------- ---------- ------------------ 1867751112 TEST PHYSICAL STANDBY MOUNTED RECOVERY NEEDED 4) From instance2 (TEST2), I did SQL> select dbid,name,database_role,open_mode,SWITCHOVER_STATUS from v$database; DBID NAME DATABASE_ROLE OPEN_MODE SWITCHOVER_STATUS ---------- --------- ---------------- ---------- ------------------ 1867751112 TEST PHYSICAL STANDBY READ ONLY SESSIONS ACTIVE 5) From instance1(TEST1), I did SQL> select database_status,instance_role,status from gv$instance; DATABASE_STATUS INSTANCE_ROLE STATUS ----------------- ------------------ ------------ ACTIVE PRIMARY_INSTANCE MOUNTED 6) From Instance2(TEST2), I did SQL> select database_status,instance_role,status from gv$instance; DATABASE_STATUS INSTANCE_ROLE STATUS ----------------- ------------------ ------------ ACTIVE PRIMARY_INSTANCE OPEN Questions: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Q1) How the cluster database is showing 2 different status in 2 difference instance Q2) Why gv$instance is reporting only one instance event though both are either mounted or open for READ-ONLY ------=_Part_3479_10187357.1128184767301 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I am experiencing some = weird behavior in standby database.

Environment:
=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
Sun OS 2.9, Oracle 9.2.0.6,Veritas 4.0

I did setup 2 Node Primary and 2 node Standby physical standby setup as = below.

2 Node Primary (test1,test2)
2 Node Standby (test1,t= est2)


Test Case:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
SQL> show parameter = cluster (on both standby1 and standby2)

NAME            = ;            &n= bsp;        TYPE        VALUE

------------------------------------ ----------- --------= ----------------------
cluster_database &= nbsp;           &nbs= p;       boolean     TRUE
clust= er_database_instances         =   integer     2
cluster_interconnects&n= bsp;            = ;   string


1) Both standby instanc= es are in READ-ONLY mode by using

SQL> ALTER DATABASE OPEN READ ONLY;
Dat= abase altered.


2) From instance1 (TEST1), I issued the followin= g command while instance2
(TEST2) is in READ-ONLY= mode.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SES= SION;

Database altered.
<= br style=3D"font-family: courier new,monospace;">
3) From instance1 (TEST1), I did


SQL> select d= bid,name,database_role,open_mode,SWITCHOVER_STATUS from v$database;

      DBID NAME      DATABASE_ROLE   &nbs= p;OPEN_MODE  SWITCHOVER_STATUS
-= --------- --------- ---------------- ---------- ------------------
1867751112 TEST    &n= bsp; PHYSICAL STANDBY MOUNTED    RECOVERY NEEDED


4) From instance2 (TEST2), I did



      DBID NAME      DATABASE_ROLE   &nbs= p;OPEN_MODE  SWITCHOVER_STATUS
-= --------- --------- ---------------- ---------- ------------------
1867751112 TEST    &n= bsp; PHYSICAL STANDBY READ ONLY  SESSIONS ACTIVE



SQL> select database_status,instance_role,sta= tus from gv$instance;

DATABASE_STATUS   INSTANCE_ROLE =      STATUS
----------------- ------------------ ------------
ACTIVE          &= nbsp; PRIMARY_INSTANCE   MOUNTED


6) From Instance2(TEST2), I did

SQL> select database_status,instance_role,sta= tus from gv$instance;

DATABASE_STATUS   INSTANCE_ROLE =      STATUS
----------------- ------------------ ------------
ACTIVE          &= nbsp; PRIMARY_INSTANCE   OPEN



= Questions:
=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D
Q1) How the cluster database is = showing 2 different status in 2 difference=20
instance

<= span style=3D"font-family: courier new,monospace;"> Q2) Why gv$instance is reporting only one instance event though both are ei= ther

mounted or open for READ-ONLY
------=_Part_3479_10187357.1128184767301-- -- http://www.freelists.org/webpage/oracle-l