Re: How to sve (backup) RMAN Catalog ?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 13 Feb 2002 18:08:43 +1100
Message-ID: <3c6a1108$0$18474$afc38c87@news.optusnet.com.au>

You are sort-of supposed to house a secondary catlog in another database (usually your main target for primary backups) which protects the catalog. The catalog protects the primary database(s), including the one containing the catalog. I'm always reminded of that Albrecht Dürer engraving of an arm drawing an arm drawing an arm....

But, given that the catalog is supposed to be a pathetically small database, a simple export is usually sufficient.

And if all else fails, you can sit there for days issuing 'change catalog' commands, manually adding in to a re-constructed catalog details of all prior backup sets created by RMAN.

Regards
HJR "Andreas Wizemann" <AWizemann_at_fvvag.de> wrote in message news:a4uj6ugdb811m8fcqfp54q4quhu7nrol4u_at_4ax.com...
> Hi,
> we are backing up our databases with rman using a rman-catalog which
> resides in its own database. How should (could) i backup THIS database
> ?
> Only by doing export ?
> Only by doing a cold backup using the os cp command for all files ?
> Or should i use also rman but with the nocatalog option ?
> It all runs on AIX 433 using rman with TSM and TDP.
>
> Regards
> Andreas Wizemann
Received on Wed Feb 13 2002 - 01:08:43 CST