Re: best way to backup rman repository

On Apr 3, 9:38 pm, Patrick Boulay <boul..._at_free.fr> wrote:
> I guess logical exports and archived log mode for doing hotline backups ...
> use of control files for rman
> any suggestion ?
> any background experience ?

Logical exports correct form the basis of one way to handle backing up a recovery catalog. Of course you can always use rman to backup rman right? ( Backing up the recovery catalog database as a target database itself ).

Some vendor backup software will also take exports "automagically". HP sells data protector and it "adds to" rman backups that use a recovery catalog database an export of the recovery catalog. Kind of handy that, having the tape that contains the backup of a target database also have the export of the recovery catalog.

Do you have the Freeman and Hart rman book? I recommend purchasing that.

If you do decide to start getting exports of the recovery catalog database on a regular basis then it makes "how you backup" that database much less critical. You may be able to get away with taking down ( shutting down ) the rcat every once in a while and getting an old fashioned "copy the files to a different directory" cold backup.

There's lots of options. Make sure you understand your rational for picking one set of choices over another, get it documented, tested out, etc. Received on Tue Apr 03 2007 - 12:38:43 CDT