From oracle-l-bounce@freelists.org Tue Jan 11 17:40:30 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j0BNeUA22512 for ; Tue, 11 Jan 2005 17:40:30 -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 j0BNeUn22507 for ; Tue, 11 Jan 2005 17:40:30 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6D96472CDAD; Tue, 11 Jan 2005 18:47:06 -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 01770-69; Tue, 11 Jan 2005 18:47:06 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C8BE572CB50; Tue, 11 Jan 2005 18:47:03 -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:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=kT1LPbJ7ZUttgTxWzAUVixzb74/oK6ARTk7Bl1KCR9k83JyR6iTAWM0o1r+ZsDW93V2xlebkd5kT7H3qVS2YNP5JydsHDfWcFvpzxM6IxXEidiEgs/JLCufHLdcy485/KBfikfsCXpQ9EqycWRsEMQdkd+mLYFVvWykBf74Cch8= Message-ID: <10644b9e050111154469001816@mail.gmail.com> Date: Tue, 11 Jan 2005 17:44:54 -0600 From: Steven Patenaude To: CMarquez@aarp.org Subject: Re: RMAN/DG - delete *ONLY* archive logs "already shipped to thestandby DataGuard database"? Cc: joelgarry@anabolicinc.com, oracle-l@freelists.org In-Reply-To: <7E412C164E6ECB468834A39F31E6E0D40666DB60@mbs06dc.na.aarp.int> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <7E412C164E6ECB468834A39F31E6E0D40666DB60@mbs06dc.na.aarp.int> X-archive-position: 14646 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: spatenau@gmail.com Precedence: normal Reply-To: spatenau@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org On Tue, 11 Jan 2005 18:13:47 -0500, Marquez, Chris wrote: > If my standby is NOT accepting or applying "shipped" logs should that be > there *rule* for not backing up and/or not deleting from the primary? > As soon as late one night my primary archive log dir is full and db > halts...that rule is out, right? > > Again I agree, but not in one script. Backup is backup...standby > consistency is another script / logic / code. True, true. I thought about mentioning something like this previously. The standby monitoring scripts should let you know when the standby isn't applying logs anymore. The production monitoring scripts should let you know if your directory is filling up. Steven -- http://www.freelists.org/webpage/oracle-l