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 -> Re: Help - lost rollback files

Re: Help - lost rollback files

From: Alexandre Leite <aleite_at_sysdesign.com.br>
Date: Thu, 25 Mar 1999 09:28:30 -0300
Message-ID: <7dda1p$lhd$1@srv4-poa.nutecnet.com.br>


Hi Guys,

If any rollback segment was active in the moment of crash, it's not possible to remove
the datafile of the controlfile.

You can try to modify "rollback_segments" parameter in init.ora to _corrupted_rollback_segments. This parameter isn't documentary in Oracle Manuals.

Regards,
Alexandre Leite.
OCP Note, your database will be inconsistent after recovery.

Devinder Pal Singh escreveu na mensagem <36F93E0B.14E5B94D_at_pharma.novartis.com>...
>I think you can proceed this way.
>1) Modify your init.ora and remove the entry for those rollback segments.
>2) Mount the database and do
>alter database datafile offline drop;
>3) May be you have to drop the tablespace also once you open the database.
I
>dont remember exactly.
>You wont be able to recover anything, but atleast you can open your
database.
>
>
>Pete wrote:
>
>> I forgot to say.
>>
>> It's Oracle 7
>>
>> Cheers
>> Pete <peter_bruton_at_yahoo.com> wrote in message
>> news:7dac29$fv9$1_at_starburst.uk.insnet.net...
>> > hope someone can help. I'm new to DBA stuff, and I've hit a problem.
One
>> > of my hard drives failed and needed replacing. The disk that failed
>> > contains my rollback info and I've discovered to my horror that
NTbackup
>> > failed to backup anything from that drive (I assume it's because the
>> > database was never shutdown). None of the other disks were affected so
>> all
>> > other datafiles are OK
>> >
>> > As a result of this Oracle won't start, I'm assuming that this is
because
>> of
>> > the missing files. Is there any way for me to start Oracle without the
>> > rollback files and recreate them? Or is there another solution.
>> >
>> > Thanks for your help
>> >
>> > Pete
>> >
>> >
>
Received on Thu Mar 25 1999 - 06:28:30 CST

Original text of this message

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