RE: RMAN without a repository and a total site loss
- To: <jim.silverman@xxxxxxxxxxx>, <don@xxxxxxxxx>, <gkatteri@xxxxxxxxxxx>
- Date: Wed, 18 Apr 2007 13:31:13 -0700
Jim,
I understand that part but I can also do the same thing if I have backed
up the controlfile without having used autobackup. So for example if the
last step of my RMAN procedure is...
BACKUP FORMAT '/somedisk/ctrlfile.bak' CURRENT CONTROLFILE;
Then when I need to recover and I have /somedisk/ctrlfile.bak available
then all I have to do is startup the database nomount and from rman
RESTORE CONTROLFILE from '/somedisk/ctrlfile.bak';
I have done that when testing restores from backups and it works. I must
also make sure I am backing up my spfile and can restore it as well so
basically I still don't understand the difference between the above
statement and RESTORE CONTROLFILE from AUTOBACKUP;
Thanks.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: jim.silverman@xxxxxxxxxxx [mailto:jim.silverman@xxxxxxxxxxx]
Sent: Wednesday, April 18, 2007 12:25 PM
To: William Wagman; don@xxxxxxxxx; gkatteri@xxxxxxxxxxx
Cc: ryan_gaffuri@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: RMAN without a repository and a total site loss
The primary benefit of having an AUTOBACKUP of the controlfile is that
you can restore the most recent controlfile when you have no other
information available. The following text is copied, verbatim, from the
10g Backup and Recovery Advanced User's Guide:
A control file autobackup lets you restore the RMAN repository contained
in the control file when the control file is lost and you have no
recovery catalog. You do not need a recovery catalog or target database
control file to restore the control file autobackup. For example, you
can issue:
RESTORE CONTROLFILE FROM AUTOBACKUP;
After you restore and mount the control file, you have the backup
information necessary to restore and recover the database. You can
connect to the target instance in NOCATALOG mode and recover the
database. You can also create a new recovery catalog and register the
target database. The RMAN repository records in the control file will be
copied to the new recovery catalog.
HTH...
=====================================
Jim Silverman
Senior Systems Database Administrator
Solucient, LLC - A Thomson Company
Telephone: 734-669-7641
FAX: 734-930-7611
E-Mail: jim.silverman@xxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of William Wagman
Sent: Wednesday, April 18, 2007 3:05 PM
To: don@xxxxxxxxx; gkatteri@xxxxxxxxxxx
Cc: ryan_gaffuri@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: 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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
