Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: HELP!!! : Can't start database - Rollback Datafiles are missing -

Re: HELP!!! : Can't start database - Rollback Datafiles are missing -

From: <tim_at_sagelogix.com>
Date: Fri, 31 Jan 2003 13:30:29 -0800
Message-ID: <F001.0054110D.20030131133029@fatcity.com>


What is your TAR number?

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: tim_at_sagelogix.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 Jan 31 2003 - 15:30:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US