Oracle-L: RE: controlfile recovery

From: Nelson, Allan <anelson_at_midf.com>
Date: Fri, 25 Apr 2003 14:22:07 -0800
Message-ID: <F001.00589F5C.20030425142207@fatcity.com>

'recover database using backup controlfile' is probably the syntax you need. Hope you have all your archive logs.

Allan

-----Original Message-----

From: oramagic_at_hotmail.com [mailto:oramagic_at_hotmail.com] 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

This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Nelson, Allan
INET: anelson_at_midf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: 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:07 CDT