RE: RMAN without a repository and a total site loss
- From: "William Wagman" <wjwagman@xxxxxxxxxxx>
- To: <don@xxxxxxxxx>, <gkatteri@xxxxxxxxxxx>
- Date: Wed, 18 Apr 2007 12:05:08 -0700
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@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Don Seiler
Sent: Wednesday, April 18, 2007 9:32 AM
To: gkatteri@xxxxxxxxxxx
Cc: ryan_gaffuri@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx> 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@xxxxxxxxxxx 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
