Veritas-bu

[Veritas-bu] Database Extension (Oracle) Recovery Catalog

2001-08-22 11:06:12
Subject: [Veritas-bu] Database Extension (Oracle) Recovery Catalog
From: adamlapizza AT hotmail DOT com (ADAM)
Date: Wed, 22 Aug 2001 11:06:12 -0400
Thank you for the reply, you did mentioned that great docs out there that
can be used to make sure the configuration gets done correctly. Do you have
them, if you do can you please forward them?

Thanks,

Adam


----- Original Message -----
From: "Penelope Carr" <Penelope.Carr AT veritas DOT com>
To: "ADAM" <adamlapizza AT hotmail DOT com>; "Steve Dvorak" <sdvorak AT veritas 
DOT com>;
"'Dennis Dwyer'" <dfdwyer AT tecoenergy DOT com>;
<veritas-bu AT mailman.eng.auburn DOT edu>
Sent: Wednesday, August 22, 2001 10:26 AM
Subject: RE: [Veritas-bu] Database Extension (Oracle) Recovery Catalog


> 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
>

<Prev in Thread] Current Thread [Next in Thread>