Re: [8i] redo logs

nsouto_at_optushome.com.au.nospam (Nuno Souto) wrote in message news:<3ca18a88.3004241_at_news-vip.optusnet.com.au>...
> Igor Laletin doodled thusly:
>
> >
> >Frederic can't create a file with the same _name_ which means either
> >oracle still has it in the data dictionary or file is still in the
> >filesystem.
> >
> >> > I've a very little problem with my Oracle 8.1.7 database :
> >> > I had to resize my 3 redo log files, so I created 3 new redo logs,
> >> > with datafiles numbered from 4 to 6 and drop the tree old ones. Then I
> >> > removed the files corresponding to old redo logs.
> >> > I then decided to create three others redo logs numbered from 1 to 3.
> >> > And I couldn't because Oracle said me they already existed.
> >> > Is this a normal comportement or did I forget anything ?
>
>
> Could this be Frederic deleted only one side of the redo log group?

Doesn't sound like that. I'd say he deleted the files in fs but failed to do so in oracle. Or other way. (As usual) there is no error message and/or spool file so we can't really tell. There is no point in guessing, not enough info -> can't help -> sorry mate. I squeezed in because of inodes not redos. BTW forgot to add that inodes are also locked (at least in hp-ux) for binaries currently running. The last reference can't be deleted but can be renamed. You can reuse the name after mv.

Cheers,
Igor

> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Received on Wed Mar 27 2002 - 21:22:30 CST