Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help - lost rollback files
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