RE: Recovery Manager vs. SQL Back Track

I'm using RMAN also, it works very good. By the way:
any way to automate delete obsolete backuppieces? I'm doing backup to disk with RMAN, and want to delete backuppieces from obsolete backupsets.
If i do a crosscheck, it won't mark files as expired because files are still on disk.
Cannot also use CHANGE DELETE command, because i need to know the obsolete pieces first....that's what i'm trying to automate. Besides, we have 142 remote db being backed up with a local RMAN catalog, and it's a lil' complex to manually monitor all the obsolete backupsets.

Any script/idea willbe appreciated.
RDBMS 8.1.6.0
RMAN 8.1.6.0
Solaris 2.6

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, April 03, 2001 3:26 PM

> You cannot send a PDF attachment thru the list as far as I know.
>
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, April 03, 2001 2:07 PM
>
>
> Send it through the list. I would like to see it also. Thanks.
>
> >>> rgramolini_at_tax.state.vt.us 04/03/01 11:56AM >>>
> I have used rman exclusively since I became an Oracle DBA because it was
> there and I needed a backup strategy. It has gotten better with later
> releases. We are now on 8.0.6. It used Oracle internals so that is an
> advantage. It comes free with Oracle so that is another advantage.
>
> I can send you a paper on why to love rman written by Francis Sanchez of
> Oracle Corp. if you need it. I can't send an attachment through the
list.
>
> Regards,
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, April 03, 2001 10:45 AM
>
>
> > Hi everyone -
> >
> > Currently we are doing backups manually, periodic cold backups, and hot
> > backups in between - we are running in archivelog mode. We are running
> > 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris. Today there are only
a
> > few small production servers (2 - 5 GB), but we are anticipating a
couple
> > large ones (~200GB), and a data warehouse (anticipated to be around
> 500GB).
> >
> > We have started playing around with Recovery Manager. Our Sybase DBAs
are
> > telling us we should look at SQL BackTrack instead.
> >
> > For those of you who are using either one, I'd appreciate your comments
on
> > how well you like / don't like it and any "gotcha's" that you have run
> into.
> > Other than the cost factor, what would you recommend?
> >
> > Thanks very much -
> > Lisa
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gene Sais
> INET: Gsais_at_co.palm-beach.fl.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Claudio Roca
  INET: croca_at_afip.gov.ar

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_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).