Veritas-bu

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

2001-08-21 14:19:01
Subject: [Veritas-bu] Database Extension (Oracle) Recovery Catalog
From: trosamond AT uslec DOT com (Rosamond, Travis)
Date: Tue, 21 Aug 2001 14:19:01 -0400
High Adam,

We are running ORACLE 8 RMAN now... And without the catalog we have
experienced timeouts on the restore of files... 

The backup is not really impacted without the catalog. 

We saw it in the recovery. 

We setup and tested with a catalog last weekend with a DB that is just under
a TB in size. With the catalog we did have a better result and was able to
restore the DB. It was a LONG process but worth the effort in the end. It
helped me to demonstrate to the DB staff that there was a better way to
backup and recover the DB in the event it was needed. And it also showed
that the target database control file was slow and not a reliable source for
the recovery process.

With the catalog I was able to recover in about 24 hours (started early
Saturday afternoon). With the target database control file we were still
waiting for it to finish last night around 11pmEST (started mid afternoon
Sunday)...

So the choice is in what you want in your recovery and how long it can be
down.

Travis Rosamond
SR. Unix Admin.

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