Re: controlfile recovery

It's 8.1.7
Actually I wa able to recover control file and then using until scn was able to recover and open the db ( after wrote last mail ). But I was not sure what I did to rcover .
So I decided to start process again .

1. I did a resetlogs last time and then took backup .
2. Created some objects in tablespace ( just to verify I get them back ).
3. lost control files .
4. tried to recover control file from backup piece . ( success )
5. try to restore and recover database ( failed !!!! ) this time I got error

RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

I thought may be control file doesn't have latest info about this backup ( after restelogs )
tried using SNCFSID.ora file .
same thing . Not able to recover so far .

-ak

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, April 25, 2003 3:22 PM

> 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 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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: oramagic_at_hotmail.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).