Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN without a repository and a total site loss

RE: RMAN without a repository and a total site loss

From: Rich Holland [oramail] <>
Date: Tue, 17 Apr 2007 17:25:08 -0400
Message-ID: <027a01c78136$e0a4c3e0$da6412c6@CABLOE21441>

  1. restore the OS & $ORACLE_HOME file systems
  2. restore the most recent control file after the last backup (either having backed it up separately or via autobackup)
  3. use that control file to restore the rest of the database

The actual procedure will depend on things like:

            Do you stage the backups to disk and then slurp those files off to tape somewhere?

            Do you use some kind of library software (e.g. Veritas, Legato, etc) to manage tapes?  

I've been at sites which did both. with management software there's a way to query the backup catalog; the control files should be backed up with a recognizable file name that you can use with a wildcard search to find the most recent one.. If you're staging to disk and using file-based backup to tape rather than SBT, just restore your staging area, then restore Oracle from there.  

You definitely need the most recent control file backed up separately AFTER the backup runs.. Since without a catalog the backup information is stored in the control file. That backup can be a separate controlfile only backup, or can be done with controlfile autobackup; I've used both to do bare metal recovery tests.  

Backing up the control file to trace is a nice to have, but won't help much in a restore, as the backup set information is not included in the trace file.  


From: [] On Behalf Of
Sent: Tuesday, April 17, 2007 4:43 PM
Subject: RMAN without a repository and a total site loss  

I am using RMAN without the repository. I want to plan in case we have a total site loss and all I have left are my tape backups which are all compressed backupsets.  

So my control files with my catalog are gone. What do you recommend as the best way to recover if this happens? Should I backup my control files seperately on top of the backupset? Should I do backup controlfile to trace?

Received on Tue Apr 17 2007 - 16:25:08 CDT

Original text of this message