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: File limit reached

Re: File limit reached

From: terry norman <scott_at_tiger9.freeserve.co.uk>
Date: Sat, 4 Sep 1999 22:44:38 +0100
Message-ID: <7qsb6d$8qa$1@news6.svr.pol.co.uk>


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

Original text of this message

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