RE: RMAN without a repository and a total site loss
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <wjwagman@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Apr 2007 14:15:44 -0700
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
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
RESTORE CONTROLFILE from '/somedisk/ctrlfile.bak';
I have done that when testing restores from backups and it works.
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:
