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

I was having a bit of trouble following your post, but it sounds like you know you have trashed RBS and your trying to create controlfile without it. When you try to start the database, it hasn't got rollback segs to work with. Is that right?

If you could get the database up far enough to vary the original system rollback segment online (and maybe the real online rollback segs offline), you might be fine it seems.

But more important, the main problem that might make it impossible is that the data dictionary probably still thinks there is a RBS tablespace that ought to be online and ready to go.

If its critical that you get this data back, I'm thinking directly edit the system datafile? Ouch! There are not many system programmers that good in these days of windows and I'm certainly not one.

Denis Assanbaev wrote in message <36A09AC2.193FD9BA_at_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 - 23:30:49 CST