From oracle-l-bounce@freelists.org Tue Jun 21 02:37:41 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5L7bfpf011100 for ; Tue, 21 Jun 2005 02:37:41 -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 j5L7bfNi011096 for ; Tue, 21 Jun 2005 02:37:41 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 132BB1C1EAB; Tue, 21 Jun 2005 01:34:17 -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 27839-05; Tue, 21 Jun 2005 01:34:17 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 92E3C1C1E49; Tue, 21 Jun 2005 01:34:16 -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:content-transfer-encoding:content-disposition; b=bMFwhZ0YsnKmejgNbxlExLwuA8LzdQJjJrEGiECBgT1F2uIkYVlRfNPrcbamKBUknxmRjQEcdfd5DDlS54sTSdqYUpqw57iBd3kL/CCD/5Rxae+XvJnX0KPv6/v5Dmrur1GGdfN1qb1QamZgDy/oVrRqqzAxLpUdEflua2pfWGQ= Message-ID: <97b7fd2f05062023324d66bd9b@mail.gmail.com> Date: Tue, 21 Jun 2005 09:32:30 +0300 From: The Human Fly To: Oracle-L Freelists Subject: data guard + failover question Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline X-archive-position: 21393 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: sjaffarhussain@gmail.com Precedence: normal Reply-To: sjaffarhussain@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.4 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Hello list, First of all, its not a production issue, but, this question would be quite helpful. We have a DRC (data guard) for one of our business critical database. My question is, when the failover occurs, physical standby becomes primary, my question is, in this situation, do we need to collect statistics for this or not? I dont think that statistics are replicated as data use to replicate between primary and secondary. Appreciate your valuable suggestions or views. -- Best Regards, Jaffar, OCP DBA Banque Saudi Fransi Saudi Arabia ---------------------------------------------------------------------------------------- "It is your atittude, not your aptitude that determins your altitude." -- http://www.freelists.org/webpage/oracle-l