RE: Backup best practice

From: Goulet, Richard <>
Date: Thu, 20 Oct 2011 18:03:54 +0000
Message-ID: <>

Best practice I believe is to use both the recovery catalog, which you've hopefully replicated to another server in preferably another data center, and having it in the control file. We do routine restores of production databases to different machines every 6 months and intentionally don't use the recovery catalog. Here are the steps we follow:

set dbid 3836706798;
{ set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK   TO 'oracle8:[backup.tcprd1]tcprd1_%F.';   restore controlfile from autobackup;
alter database mount;

Obviously the dbid and file locations will be as per your environment, but this does work.

Richard Goulet
Senior Oracle DBA/Na Team Leader

-----Original Message-----

From: [] On Behalf Of Storey, Robert (DCSO) Sent: Thursday, October 20, 2011 1:25 PM To:
Subject: Backup best practice

Okay, looking at a best practices kind of question.  

I am setting up a machine to hold the catalog/repository for RMAN backups of my dbs. And, I even will schedule the backups of the backup machine to be done by RMAN.  

However, what is the best practice for storing this machines backup metadata? It would seem that you have to store it in the controlfile and use other methodologies to safeguard the information. To me, you can't use the catalog because if it dies, how do you do a restore of your backup machine if your metadata and such about the in the dead machine?  

A suggestion in my class to day was that you could still use RMAN to restore the backup machine using the DUPLICATE command, as long as you had access to the the proper backup set pieces.  



-- Received on Thu Oct 20 2011 - 13:03:54 CDT

Original text of this message