Re: [8i] redo logs

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<a7qprk$u28$1_at_lust.ihug.co.nz>...
> Try bouncing the Instance (shutdown - startup).
>
> You don't say what platform you are running on, but I've seen this on Unix,
> for example: deleting the files at the O/S level makes it seem like the
> files don't exist, but until Oracle really lets go of them, they seem to
> persist in the aether, somewhere, somehow. Shutting Oracle down usually
> gives the all-clear to the O/S to *really* go ahead and delete them.
>

It's not exactly the same. When you delete an opened file in Unix, the file _name_ is deleted from a directory but its i-node and its space stay used. You can reuse the file name but you won't get space back while the file stays opened by at least one process. When the last process closes the file its space is returned to the free list and i-node is marked as unused. ... Well, at least in the classical unix filesystems.

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.

Regards,
Igor

> Regards
> HJR
> --
> ------------------------------------------
> Resources for Oracle : www.hjrdba.com
> ============================
>
> "Frederic Payant" <fpayant_at_club-internet.fr> wrote in message
> news:34n1ausivk32qgvs7u0139vgdpf4m98iea_at_4ax.com...
> > Hi,
> >
> > 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 ?
> > Regards
> > Frederic PAYANT - junior DBA ;-)
Received on Tue Mar 26 2002 - 23:42:14 CST