Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h1PLkoP10564 for ; Tue, 25 Feb 2003 15:46:50 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h1PLkoh10558 for ; Tue, 25 Feb 2003 15:46:50 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id JAA45450; Tue, 25 Feb 2003 09:11:40 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00558C09; Tue, 25 Feb 2003 08:59:22 -0800 Message-ID: Date: Tue, 25 Feb 2003 08:59:22 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Ruth Gramolini" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Ruth Gramolini" Subject: Re: delete archivelog... backed up 1 times to tape Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0472_01C2DCC4.D2B4F310" ------=_NextPart_000_0472_01C2DCC4.D2B4F310 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable The archivelogs have to have been backed up by rman for rman to delete = them. Thisscript is the one we use. =20 execute script alloc_name1_disk; backup format '/dbback/al_%sdbname_%p' (archivelog all delete input); execute script rel_pa1_disk; } =20 HTH,=20 Ruth =20 ----- Original Message -----=20 From: Ed Bittel=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, February 20, 2003 9:23 AM Subject: RMAN: delete archivelog... backed up 1 times to tape I am trying to use the DELETE ARCHIVELOG command that is available in version 9.2.0.1. The complete syntax I wish to use is this command:=20 RMAN> delete archivelog until time 'trunc(sysdate)-2' backed = up 1 times to tape;=20 I have tried this as part of a backup script and as a standalone = command after allocating a maintenance channel, but it doesn't work. = Furthermore, this command DOES NOT return records:=20 RMAN> list archivelog all backed up 1 times to tape;=20 But this command DOES return records:=20 RMAN> list archivelog all backed up 0 times to tape;=20 I know I have backups of archivelogs on tape because they are reported = when I issue this command:=20 RMAN> list backup of archivelog from time 'sysdate-3' device = type sbt; Does anyone know what is going on here?=20 Thanks,=20 Ed=20 /************************ RDBMS Version: 9.2.0.1 OS: Sun Solaris 8 Product: RMAN (9.2.0.1) *************************/ --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20 Author: Ed Bittel INET: grep_oracle@hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------=_NextPart_000_0472_01C2DCC4.D2B4F310 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
The archivelogs have to have been backed up by rman = for rman=20 to delete them.  Thisscript is the one we use. 
 
  execute script alloc_name1_disk;
 =20 backup
    format=20 '/dbback/al_%sdbname_%p'
    (archivelog=20 all
     delete input);
  execute script=20 rel_pa1_disk;
}
  
HTH, 
Ruth   
----- Original Message -----
From:=20 Ed=20 Bittel
Sent: Thursday, February 20, = 2003 9:23=20 AM
Subject: RMAN: delete = archivelog...=20 backed up 1 times to tape

I am trying to use the DELETE ARCHIVELOG command that = is=20 available in
version 9.2.0.1. The complete syntax I wish to use is = this=20 command:
       = RMAN>   =20 delete archivelog until time 'trunc(sysdate)-2' backed up 1
times = to tape;=20

I have tried this as part of a backup script and as a = standalone=20 command
after allocating a maintenance channel, but it doesn't = work. =20 Furthermore,
this command DOES NOT return records:=20

       RMAN> list archivelog = all=20 backed up 1 times to tape;

But this command DOES return = records:=20

      RMAN> list archivelog all = backed up=20 0 times to tape;

I know I have backups of archivelogs on tape = because=20 they are reported when
I issue this command:=20

      RMAN> list backup of = archivelog from=20 time 'sysdate-3' device type sbt;


Does anyone know what is = going on=20 here?


Thanks,

Ed=20

/************************
 RDBMS Version: = 9.2.0.1
 OS:=20 Sun Solaris 8
 Product: RMAN=20 (9.2.0.1)
*************************/
--
Please see the = official=20 ORACLE-L FAQ: http://www.orafaq.net
--=20
Author: Ed Bittel
  INET: grep_oracle@hotmail.com
Fat=20 City Network Services    -- 858-538-5051 http://www.fatcity.com
San = Diego,=20 California        -- Mailing list = and web=20 hosting=20 = services
-------------------------------------------------------------= --------
To=20 REMOVE yourself from this mailing list, send an E-Mail message
to: = ListGuru@fatcity.com (note = EXACT=20 spelling of 'ListGuru') and in
the message BODY, include a line = containing:=20 UNSUB ORACLE-L
(or the name of mailing list you want to be removed=20 from).  You may
also send the HELP command for other = information (like=20 subscribing).
------=_NextPart_000_0472_01C2DCC4.D2B4F310-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: rgramolini@tax.state.vt.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).