Re: RMAN sample script for Linux

"Brian Peasland" <oracle_dba_at_remove_spam.peasland.com> wrote in message news:3EF86117.515CAEF4_at_remove_spam.peasland.com...
> > And, since this is 9i RMAN, Oracle is recommending running without a
catalog
> > database these days, and hence the elaborate script you have is a bit
> > redundant.
>
> Who is recommending to run without a Recovery Catalog in 9i?

Oracle is.

>What did 9i
> introduce that does away with the benefits of a Recovery Catalog?

Stored persistent configuration parameters in the controlfile of the target database. They are read each time a datafile copy or backup command is issued. Therefore they don't need to be specified at run-time, and therefore there is no need for long-winded scripts. One of the major reasons for having a catalog was to permit the storage of scripts. If scripts are no longer needed, you don't need a catalog.

>Do you
> have docs to back this up?

Try:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmquick.htm#442214 (sorry for the wrapping).

The specific bit of interest is:

"In general, Oracle Corporation advises using a catalog when you manage multiple databases."

Which can also be read to mean 'we don't advise it for a single database'.

And then, later, explicity they say:

"Hence, unless you manage a network of databases, you may choose to avoid the overhead and use the control file as the exclusive repository of metadata"

There's also a line in the new features training course material which states that something along the lines of 'unless your backup requirements are unusual or complex, we advise not to use a catalog'.

I can dig out the specific reference from that document if you wish, but not right this minute.

:-> Received on Wed Jun 25 2003 - 06:29:26 CDT