Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help - lost rollback files
The note at the end should have been marked in some way to show its importance.
There is a note available from Support (included in the back of the Oracle8
Backup and Recovery Workshop notes from Education) which details its use, but
here's the big proviso:
HTH. Pete
Alexandre Leite wrote:
> 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
> >> >
> >> >
> >
--
Regards
Pete
Peter Sharman Email: psharman_at_us.oracle.com WISE Course Development Manager Phone: +1.650.607.0109 (int'l) Worldwide Internal Services Education (650)607 0109 (local)San Francisco
SQL> select standard_disclaimer, witty_remark 2 from company_requirements;
Opinions are mine and do not necessarily reflect those of Oracle Corporation
"Controlling application developers is like herding cats."
Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!"
Bruce Pihlamae, long term ORACLE DBA
Received on Thu Mar 25 1999 - 11:05:21 CST