Re: ok so i'm bored working on rman scripts

And it already is much better. There are some holes, such as the REPORT NEED BACKUP command lacking any awareness of archivelog backups (i.e. only reporting the state of datafile backups alone), but it's easy enough to write custom queries to deal with that. But calling it a "hole" might be too strong, because with custom-written backup scripts, you don't have *anything* to query and have to parse/examine log output to determine if what's backed up and what's not...

As far as more basic backup/restore functionality holes, it's mostly gotchas and diligent catalog maintenance at this point (9i), although better support for "object point-in-time recovery" would sure be nice so we can put the final nails into the coffin of people using "exports" for backup purposes. Still, even that can be crafted by reverse-engineering the actual RMAN commands hiding behind macros like DUPLICATE TARGET DATABASE, and 9i at least offers the ability to perform this down to the tablespace level (if not the object-level)...

Go for it, indeed! Nowadays, *not* going for it is the real risk...

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 01, 2002 6:38 AM

> Just go for it! That's what I did, out of necessity, I just implemented
it
> and waited until it got better. 8>)
>
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Monday, September 30, 2002 8:48 PM
>
>
> > Ruth, just some experiments, going to implement it for ERP at
> > longaberger, so i need to do proof of concept.
> >
> > not stuck(yet) just experimenting.
> >
> > joe
> >
> >
> > Ruth Gramolini wrote:
> >
> > >Joe,
> > >What are you trying to do with rman?
> > >Ruth
> > >----- Original Message -----
> > >To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > >Sent: Thursday, September 26, 2002 2:17 PM
> > >
> > >
> > >so i took the first 2 stories and put them on
> > >
> > >http://www.oracle-dba.com/bdbafh
> > >
> > >nothing pretty, maybe i'll mess with it later today, text only so far.
> > >
> > >feel free to submit your part of the on-going saga to
> bdbafh_at_oracle-dba.com
> > >
> > >joe
> > >
> > >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Joe Testa
> > INET: jtesta_at_dmc-it.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_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 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_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: Tim Gorman
  INET: Tim_at_SageLogix.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_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).