Re: [8i] redo logs

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 27 Mar 2002 08:38:59 +1100
Message-ID: <a7qprk$u28$1@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.

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 - 15:38:59 CST