RE: Re[2]: HELP!!! : Can't start database - Rollback Datafiles a

Hi to all,
Thanks for the comments, but none of them worked for me, I tried putting a comment in the init.ora file to the rollback segments line to recreate the controlfile. No success. I did get a message telling me that there was a 'MISSING000' datafile in $ORACLE_HOME/dbs, and tried to do a offline drop command, but had no success either..
Finally I gave up (time was running), and recreated the DB with the crdb scripts (with all the appropriate structures) and did a full import... everything is ok now, but I would appreciate if you could let me know what where my options beside the ones you already pointed out. Thanks for any aditional comments,
Veronica.

-----Mensaje original-----
De: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com] Enviado el: Friday, January 31, 2003 4:40 PM Para: Multiple recipients of list ORACLE-L Asunto: Re[2]: HELP!!! : Can't start database - Rollback Datafiles a

Steve,

    Not totally true. We did something similar, except that we forgot one of
the temp tablespace datafiles. Oracle in it's infinite wisdom created a file
'MISSING00064' in $ORACLE_HOME/dbs. The only way out of that is to offline drop
the datafile while mounted, meaning you've read the controlfile. Then when you
open the database the tablespace stays offline & you can drop it and it's contents thereby cleaning up the data dictionary. Yes, you can't do that with
the rollback segments on line either, which is why you need to comment them out
of the init.ora.

Dick Goulet

____________________Reply Separator____________________
Author: Stephane Faroult <sfaroult_at_oriole.com>
Date:       1/31/2003 2:14 PM

Veronica Levin wrote:
>
> Hi guys, I need help!
> At this moment, it doesn't matter how I messed everything up, but
> Development server is down.
> Had to recover operating system with a two month old backup.
> Oracle motor resides in the MkSysB backups, so some files where replaced,
> some datafiles where lost, and control file is mixed up.
> I can mount the database, but can't open it because rollback datafiles
(and
> filesystem) where lost in the crash. Had to rebuild the filesystem, but
I'm
> not able to rebuild the controlfile due to datafiles errors on the
rollback
> tablespaces.
> I tried, with no success, to rebuild the controlfile leaving out the
> rollback datafiles, but that didn't work.
> What am I missing here???
> Is there a way I can recover the database without having to rebuild it?
> I do have a tape with a full backup (from last weekend), and I'm leaving
> that as a last resource. I also have full export from yesterday, wich I
can
> download too.
> I made changes to the physical structure of the database today today, and
> would have to rebuild many filesystems to download that tape....but I will
> if I have to.
> I would appreciate any help you can give me!!!!
> please! (I've been on this matter for 6 hours already!)
> thanks,
> Vero.

Veronica,

 Normally you should be able to reopen your database by rebuilding the controlfiles WITHOUT the rollback segment tablespace if :

1. You comment out the rollback_segments = line in your init.ora (otherwise Oracle will try to put them online)
2. You create your controlfile with RESETLOGS (your current redo log may contain references to a rollback segment). Please understand that this will be bad for the integrity of your data. Typically, if a transaction was going on at the moment of the crash, it will have been 'auto-committed' instead of being rolled back as you would expect since Oracle will become unable to undo the changes. Have your users check everything, and perhaps it would be wise to force constraints to be checked.

 Then you should be able to recreate your rollback segment tablespace and your rollback segments.

Good luck.

-- 
HTH,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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: 
  INET: dgoulet_at_vicr.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: Veronica Levin
  INET: vlevin_at_victoria.com.ni

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