| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: controlfile recovery
AK - Congratulations on getting Robert's book. This issue of recovering the
controlfile depends somewhat on which Oracle version you are using. I think
this is easier in Oracle 9i. I started working on Oracle 8i recovery before
Robert's book was available. I was not able to recover the controlfile from
the RMAN backup. I found it easier to ALTER DATABASE BACKUP CONTROLFILE TO
'XXX'; after the RMAN backup. I included that in my RMAN script and have
been able to recover databases on another server.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Friday, April 25, 2003 4:32 PM
To: Multiple recipients of list ORACLE-L
Can you reply to this before heading to IOUG .
I am testing restoration controlfile from RMAN backup . with nocatalog option .
Is there any way you can recover controlfile if database is not mounted .
I used dbms_backup_recovery package as described in Robert's book . But
looks like lost somewhere because after restoring control file database
complains system01.dbf is from past backup .
Logically seems okay , scn in control file might be different then what is
in datafile header . But now what ?
I try to recover database and it is saying recovery using backup controlfile
must be done.
I am lost . any I idea what I am doing wrong here .
thanks,
-ak
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Apr 25 2003 - 17:22:06 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |