Re: RMAN question

Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message news:<c6tonvc1d8op97t2bp3m57q4ejelkfsilj_at_4ax.com>...
> On Thu, 2 Oct 2003 20:29:08 +0200, "Volker Hetzer"
> <volker.hetzer_at_ieee.org> wrote:
>
> >If I need to recover something outside the recovery window I simply
> >had it set up the wrong way. Since the recovery window isn't set according
> >to the whim of the dba but is agreed upon with the customers, what's the problem?
>
>
> Imagine you have a customer with a 30 day recovery window (which, BTW,
> is quite normal). Now would it be feasible to have a control file
> hosting 30 days archive log file names? Especially if you have 1000s
> of archive logs per day?

Then it isn't a small system. With a recovery catalog, you have to have a second database. If you have one anyways for OEM or whatever, not a problem, but if you don't, it's potentially twice as much work (well, not really, but you should know what I mean), and certainly requires separate resources. Of course, without a catalog you have to have some mechanism to be sure you don't lose RMAN information since it's not all in a backup controlfile to trace, which just means periodically doing a "list backup."

I've just gone through this with a customer. They agree a catalog is a good thing, will do it in a few months, just have more "important" things to have me do just now. I'm happy to have convinced them not to rely solely on exp! Can't say as I'm entirely happy with the 8i RMAN standby db syncronization mechanics.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/uniontrib/thu/business/news_1b2visas.html