Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: File limit reached
I've had exactly this problem and I re-created the controlfile by editing
the output from "alter database backup controlfile to trace" and afaik the
db was in archive log mode but I didn't have any problems. That's at 7.1.6 -
I think!
regards,
Terry.
Erwin Dondorp <erwindon_at_wxs.nl> wrote in message
news:37D12D3D.E639F79A_at_wxs.nl...
> Thanks Nuno, I was wrong with that.
>
> Erwin
>
> Nuno Souto wrote:
>
> > Erwin Dondorp <erwindon_at_wxs.nl> wrote in message
> > news:37D0F076.C16EC1FE_at_wxs.nl...
> > > snip
> > > The bad news is that you have to recreate your database or upgrade to
at
> > > least 8.0.
> > >snip
> >
> > Actually, no. He can just re-create the controlfile with a larger number
of
> > files.
> > The create controlfile command works fine even in V6, let alone V7.
> > But this has to be done with archive log off or other problems will come
up.
> >
> > --
> > Cheers
> > Nuno Souto
> > nsouto_at_nsw.bigpond.net.au.nospam
> > Is there a nospam domain?
> > http://www.users.bigpond.net.au/the_Den
>
> --
> Erwin Dondorp
> <http://www.wxs.nl/~erwindon>
>
>
Received on Sat Sep 04 1999 - 16:44:38 CDT
![]() |
![]() |