Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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: Luca Canali <Luca.Canali_at_cern.ch>
Date: Tue, 17 Apr 2007 23:06:37 +0200
Message-ID: <B18EB20A5208EB4DBE0DD2412549861C3101F1@cernxchg47.cern.ch>


Controlfile autobackup is meant to solve this problem + it's also a good idea to backup (print somewhere) the DBID of your DB(s)  

The restore procedure for the controlfile in the scenario you described is:  

rman TARGET /

set dbid=... (get the dbid from v$database on the target DB) run
{
# CUT or edit if needed ->
# set until time = "to_date('24-AUG-2006 00:00:00','dd-mon-yyyy
hh24:mi:ss')";
allocate channel t1 type sbt_tape;
restore controlfile from autobackup;
}
exit;
Cheers,
L.

PS: why compressed backupsets aren't they very slow and CPU consuming?  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ryan_gaffuri_at_comcast.net
Sent: Tuesday, April 17, 2007 10:43 PM
To: oracle-l_at_freelists.org
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?

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 17 2007 - 16:06:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US