RE: RMAN without a repository and a total site loss
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "William Wagman" <wjwagman@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Apr 2007 15:59:16 -0700
That only applies to the autobackups after structural changes. I'm more
concerned with the autobackups after other backup activities, in which
case the controlfile autobackup goes to the first channel allocated,
which is tape in my case. For more detail see the sections at the
bottom of this page under "When RMAN Performs Control File Autobackups":
http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmc
onc1006.htm#BRADV111
I'm not positive, but I think that in the example given below, you would
have to set the controlfile autobackup format for the restore to match
the format used for the backup in order for rman to find it in a
non-default directory. I'm not sure why anyone would want to change the
format of the controlfile autobackups on disk to a non-default location
- seems like asking for trouble to me. I guess it would be okay as long
as it was well documented and known by all DBAs that they were stored in
an alternate location.
Regards,
Brandon
-----Original Message-----
From: William Wagman [mailto:wjwagman@xxxxxxxxxxx]
Sent: Wednesday, April 18, 2007 3:09 PM
To: Allen, Brandon; oracle-l@xxxxxxxxxxxxx
Subject: RE: RMAN without a repository and a total site loss
Brandon,
Ok, this is beginning to make sense but of course leads to one
additional piece which is unclear to me. As I understand it the default
location for autobackup pieces is the $ORACLE_HOME/dbs directory (as I
understand it that is true regardless of whether or not a catalog or the
controlfile is used as the repository). If one were to do the
following...
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'?/oradata/cf_%F';
Such that the location is no longer the default is it also unnecessary
to specify the location when doing a restore from autobackup? If I am
understanding you correctly it sounds like the restore from autobackup
will find it wherever? I think that is the piece I am missing. Unless
specified as part of the restore, how does RMAN know where to look for
the piece containing the autobackups? Don't I still have to know where
it is?
Thanks.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: Allen, Brandon [mailto:Brandon.Allen@xxxxxxxxxxx]
Sent: Wednesday, April 18, 2007 2:16 PM
To: William Wagman; oracle-l@xxxxxxxxxxxxx
Subject: RE: RMAN without a repository and a total site loss
Bill,
I think there is a key point you may be missing. In your example you
have to know that you backed up the file to '/somedisk/ctrlfile.bak' in
order to restore it. In case of tape backups, you would need to know
the handle of the backup piece on tape, and that information isn't
always readily available, especially after a disk failure when you have
lost your recovery catalog and/or control files and your backup logs.
The "restore ... from autobackup" commands can find the spfile & control
file in your tape library w/o any knowledge other than your dbid.
Regards,
Brandon
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
