Received: (qmail 30001 invoked from network); 9 Sep 2011 00:27:47 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.ip-pool.com with SMTP; 9 Sep 2011 00:27:41 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A8863E3CDE1; Fri, 9 Sep 2011 01:23:19 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1315545799; bh=Uyasl68ypYreTJ1X3xI1VOXddfyy7lxxZ4U5QWsH iZc=; h=Message-ID:Date:From:Subject:To:MIME-Version:Content-type: Content-Transfer-Encoding:Sender:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=hvw7CIELupj7LM1+fy4o2LGJ8TKxLCCCF+9aRTowtG32bofPRP 0Gq/uNhjovQ3jL/Sco1UYXpTTO4Usi//ZrWZWR1geFIj7uhcVfNOXR/z7vYJGlDQ2XB XUbRYuWoOAyIGZeKK9Cnk+7/cvsMcilFsN57t6JbkG7Hz6tfAOQsHk= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 8SCFCJ3a6jhp; Fri, 9 Sep 2011 01:23:19 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F18C9E3FC5E; Fri, 9 Sep 2011 01:22:33 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 09 Sep 2011 01:21:51 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F2A2FE40205 for ; Fri, 9 Sep 2011 01:21:50 -0400 (EDT) Authentication-Results: turing.freelists.org; dkim=pass (1024-bit key) header.i=@yahoo.com Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id LKbezSnU0wsD for ; Fri, 9 Sep 2011 01:21:50 -0400 (EDT) Received: from nm27-vm0.bullet.mail.ac4.yahoo.com (nm27-vm0.bullet.mail.ac4.yahoo.com [98.139.52.244]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 3AC31E3FB1D for ; Fri, 9 Sep 2011 01:21:43 -0400 (EDT) Received: from [98.139.52.191] by nm27.bullet.mail.ac4.yahoo.com with NNFMP; 09 Sep 2011 05:21:41 -0000 Received: from [98.139.52.178] by tm4.bullet.mail.ac4.yahoo.com with NNFMP; 09 Sep 2011 05:21:41 -0000 Received: from [127.0.0.1] by omp1061.mail.ac4.yahoo.com with NNFMP; 09 Sep 2011 05:21:41 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 2259.23238.bm@omp1061.mail.ac4.yahoo.com Received: (qmail 94061 invoked by uid 60001); 9 Sep 2011 05:21:40 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1315545700; bh=zkkzaWjlXVOQwZvMrqD+ABbe7JwqOR/3Znk5KZHT8hY=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=ZDwjPmCoiNYkO6yqquJyHl0o4l57Urwee53UFB5men6pkvziSyP/TrmO+c7vrjncZLOKxnmGWyf7AkNn2AyRFZnpYOeyW2fXpe/tjK3igu+QY29ifmz64uy7mNW5gnijUgw4o7djgy+N/NHJ1BAfhCOAzZAumdDiAcQ+0N9jFek= DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=4+MFHFvE+6XjuQNgVDsK7OL1CJdvUEM0RTEicqSTFhhjJGkGfuoKGbjit5FJuTvaSCpSvPPAm7VgCAE/o8gIEYx2/axybZyvsMsqyH8LlFXJMVec3S8cqNqDd+9zGdOqBJbTNHUMwxC5YV6OQh1fQSjqUkkZt/TgX5zvhrLkqVM=; X-YMail-OSG: WFsbCXwVM1m97jblBS2ZWxj2N1k8v9cdj0c8LPAbEdjkLo5 _X3TBIXw0eRsxTSeZD9YurhcmUpzIefYML_b9COFtp666e0pe.WA2fZHd4pB xL8DpwaJPfPfi7.MPiWL.aaxALzAB7pFqH8op2bCLK4kyYqDvd0MTiTCszDI LVb661jZVzzrout9t3pjTiqfupdrwLTZV0o2kv5A6Iz3ZG2cUGcfH1RqF.e2 11g96Whg2X0Szpws8wPuz6hv54efginx6Z1zmDOo0HhtJxmvjYzLVsOFtXDt svk2oRQSMZrktoy6visKWlInINwvugSg3VY12vYVvl8wMFCDSYQyTjemDXA5 3CPy7JoujTtpirW__SX7quhEOUvebW1x_neoUONLDw5cxkK5uIaS6ym5iUxf JFOi9yYnPXHAt3TLQS.agjZPSq04A5oUNzmO_.allPksqIdW.3H4ljrd10H. kDwk2bzVJnrHh9L0.tLjxQFpu4OuoxgOSjFus7NiwtfWt87Xsu51rK.Nhukd KDpfKqUcrxxJTlRqzmEQmMZAzauJWqqQm6w-- Received: from [98.207.110.150] by web65906.mail.ac4.yahoo.com via HTTP; Thu, 08 Sep 2011 22:21:40 PDT Message-ID: <1315545700.90254.YahooMailNeo@web65906.mail.ac4.yahoo.com> Date: Thu, 8 Sep 2011 22:21:40 -0700 (PDT) From: Saibabu Devabhaktuni Subject: RE: Oracle Failover/Switchover and Streams To: free MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 38675 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: saibabu_d@yahoo.com Precedence: normal Reply-To: saibabu_d@yahoo.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l Any configuration that is made within the database will just work fine from the new primary. However you do need to watch out for database level settings like supplemental logging and force logging after the data guard switchover or failover as these parameters doesn't get to redo stream. I've also written about it at http://sai-oracle.blogspot.com/2011/09/enhancing-active-data-guard.html Thanks,  Sai http://sai-oracle.blogspot.com -- http://www.freelists.org/webpage/oracle-l