Re: Archive logs

From: David Sisk <davesisk_at_travelin.com>
Date: 1998/02/15
Message-ID: <6c7nf8$std$1@lal.interserv.com>#1/1

Sorry to interrupt, but this is not quite correct. Never EVER delete your redo logs! Your database cannot function without them. You can delete your archive logs after they are backed-up. If you run your database in noarchivelog mode, it will not generated archive logs. However, you will not be able to do a media recovery, only an instance recovery. Running you database in archivelog mode is a good choice, since you can do media recovery, hot-backups, etc.

Dave Sisk
Certified Oracle DBA

H. Fellinghauer wrote in message <34e17982.10938668_at_news>...
>On Wed, 11 Feb 1998 10:44:50 +0800, "Vaughan Castine"
><vaughan_at_unforgettable.com> wrote:
>
>>Would I be correct in assuming that once a dataabse has been shutdown
>>(either normal or immediate) the archive logs can be deleted?
>
>No, don't do this!
>Redo log are needed for database recovery. If you don't want to have
>redo logs generated run your database in noarchivelog mode.
>
>BTW, you can delete all the redo log files whenever you made a full
>backup.
>
>cu
> Harry
Received on Sun Feb 15 1998 - 00:00:00 CST