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

Home -> Community -> Usenet -> c.d.o.server -> URGENT:Help for recreate CTRL-File with damaged DATAFILE needed

URGENT:Help for recreate CTRL-File with damaged DATAFILE needed

From: Denis Assanbaev <Denis.Assanbaev_at_isb-ka.de>
Date: Sat, 16 Jan 1999 14:57:22 +0100
Message-ID: <36A09AC2.193FD9BA@isb-ka.de>


Dear experts,
could anybody help me to get database started (in order to do "DROP TABLESPACE RBS;"
= drop RB-tablespace
immediatly after starting)
in situation , when:
1. The single datafile form tablespace RBS has been overriden from ANOTHER DATABASE, so I become
error message when trying to recreate controlfiles with this file included.
2. and there are no good controlfiles.
3. The data in this tablespace is not of interest, there were only to rollback segs in it.
?

I need some parameter in INIT<sid>.ora in order to :
- recreate controlfiles without this Datafile (it works but I get
trouble while starting DB after that)
- and then to start DB (at the moment if the File has not been
incklusded
into CREATE CONTROLFILE... I get internal error while opening DB)

Thanx in advance.

Denis


Received on Sat Jan 16 1999 - 07:57:22 CST

Original text of this message

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