From oracle-l-bounce@freelists.org Tue Dec 7 05:37:17 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iB7BbHs19311 for ; Tue, 7 Dec 2004 05:37:17 -0600 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 iB7BbHm19305 for ; Tue, 7 Dec 2004 05:37:17 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7849772CAE3; Tue, 7 Dec 2004 06:43:41 -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 32111-33; Tue, 7 Dec 2004 06:43:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C45E472C77D; Tue, 7 Dec 2004 06:43:40 -0500 (EST) In-Reply-To: <20041207104016.5394.qmail@webmail10.rediffmail.com> To: premj@rediffmail.com Cc: oracle-l@freelists.org, oracle-l-bounce@freelists.org Subject: Re: What not to do in a standby environment ? MIME-Version: 1.0 Message-ID: From: Tony.Adolph@o2.com Date: Tue, 7 Dec 2004 12:20:35 +0100 X-MIMETrack: Serialize by Router on MUC8LX01/SPOKE/o2-Germany(Release 6.5.1|January 21, 2004) at 12/07/2004 12:28:47, Serialize complete at 12/07/2004 12:28:47 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 13214 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Tony.Adolph@o2.com Precedence: normal Reply-To: Tony.Adolph@o2.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Its not really a don't do, but you have to be aware that if you add a new datafile to the production db, then you must also manually add it to the standby. Recovery stops until the new datafile is added. Cheers Tony Prem Khanna J Sent by: oracle-l-bounce@freelists.org 12/07/2004 11:40 AM Please respond to premj@rediffmail.com To oracle-l@FreeLists.org cc Subject What not to do in a standby environment ? Hi Friends, I would like to know the list of "NOT TO DO" on Primary database in Standby database environment. And how to rectify, in case , it's done. i have a partial list like ... NOLOGGING , CLEAR ARCHIVE , RECREATE CONTROL FILE, RESETLOGS , ARCHIVE LOG STOP Please do let me know if you have come across anything that's it left out from the docs in case of standby database DONT'S. Note:120855.1 has got some , but it seems to miss things like NOLOGGING operations . If someone has one such list , can you share it with me ? The environment is oracle 8.1.7.4/Solrais 9. Any pointers would be of immense help.TIA. Regards, Prem. -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l