All,

There are alot of issues when not using the catalog database.  The main one
is the fact that the information gets stored in the control file of the
target database. You lose the control file you lose the target database as
well as your RMAN capabilities.  You also lose these features as well:

unable to use stored scripts
unable to do point-in-time restores of tablespaces
unable to do restores of any type since you have lost RMAN
Run into timeouts on restores

 
The catalog database is a very small database and takes little effort for
maintenance.  The information stored in the control file of the target
database is limited since it is only supposed to keep track of its own
database and not all the others for backups.

Point being since I have been using RMAN with NBU for over 7 years and
having been a oracle DBA in a previous life - I HIGHLY RECOMMEND A SEPARATE
RMAN CATALOG DATABASE!!  

The problem in the field is that few DBAs know RMAN as well as our own
consultants but we are working on a class to fix that.  Most DBAs don't want
to have to add another database to the group and are afraid of maintenance
and the fact they don't know it.  We provide the canned scripts and we have
some great docs out there that can be used to make sure the configuration
gets done correctly.  Not to mention the fact you have me as a resource for
help whenever you need it.

Thanks everyone,

Penelope

Penelope Carr
cell 914-439-4911
office 914-934-2404


-----Original Message-----
From: ADAM [mailto:adamlapizza AT hotmail DOT com]
Sent: Tuesday, August 21, 2001 1:06 PM
To: Steve Dvorak; 'Dennis Dwyer'; veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Database Extension (Oracle) Recovery Catalog


Hi Steve & Dennis,

I am not so famlier with Oracle, and I have one questoin regarding the
Recovery Catalog and Recovery Manager (RMAN) in the Admin Guide they say the
following:
The recovery catalog is a repository of information that is used and
maintained by Oracle8 Recovery Manager. Oracle8 Recovery Manager uses the
information in the recovery catalog to determine how to execute requested
backup and restore actions. Oracle recommends you use Oracle8 Recovery
Manager with a recovery catalog, especially if you have 20 (or more)
datafiles. However, you are not required to maintain a recovery catalog with
Oracle8 Recovery Manager. Because most information in the recovery catalog
is also available in the target database's control file, Oracle8 Recovery
Manager supports an operational mode where it uses the target database
control file instead of a recovery catalog. This operational mode is
appropriate for small databases where installation and administration of
another database for the sole purpose of maintaining the recovery catalog
would be burdensome.

Lets say that I do not use the Recovrey Catalog, is there any know issues in
my case?

Thanks for your help.

Adam

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu