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
Greetings,
I have been following the discussion re autobackup of the controlfile and as a result have been doing some investigation and still have one question. I don't understand what additional safety is provided by doing an autobackup of the controlfile as opposed to BACKUP CURRENT CONTROLFILE as the last step of the backup procedure. I realize that the spfile is backed up as part of the autobackup and as I understand it changes to database structure cause the controlfile and spfile to be backed up (or so the docs say). But if I have the backup piece containing the controlfile and can restore a controlfile from. I've done that. Is the added protection of having an spfile and controlfile in sync the primary gain or are there other pieces I am missing?
Thanks.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Don Seiler
Sent: Wednesday, April 18, 2007 9:32 AM
To: gkatteri_at_fastmail.fm
Cc: ryan_gaffuri_at_comcast.net; oracle-l_at_freelists.org
Subject: Re: RMAN without a repository and a total site loss
In my system recovery internal docs I have this page bookmarked:
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmr ecov004.htm#sthref734
But yes you'll definitely want controlfile autobackup on.
Don.
On 4/17/07, GovindanK <gkatteri_at_fastmail.fm> wrote:
>
>
>
> Ryan
>
> Lot of ideas have been given about this thread. Autobackup is one good
> concept. It is preferred you put the dbid as part of the media handle
or
> wherever you can plug that in.
>
> If you have the logfile, you can restore the control file as
>
> rman nocatalog , connect target, set dbid , restore controlfile from
> 'cf_respective_handle';
>
> This will give you a good starting point. Then etc and restore the
db.
>
> Optionally you can backup/restore your spfile too
>
>
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/rcms
ynta46.htm#93304
>
> If you do not have backup of the init.ora /spfile you would need to
create
> one.
>
> HTH
>
> GovindanK
>
> On Tue, 17 Apr 2007 20:42:39 +0000, ryan_gaffuri_at_comcast.net said:
>
> 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?
-- Don Seiler oracle: http://seilerwerks.blogspot.com ultimate: http://www.mufc.us -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 18 2007 - 14:05:08 CDT
![]() |
![]() |