Re: newbie ? about deletion of logs

There is no way, at least not if you are not using RMAN, and I don't know enough of RMAN to say whether RMAN is dealing with this issue. If you use cold backup you can safely delete all logs after a (stress!!) successful(ly verified) backup.
If you are not using any third party sw and are using hot backup, there is a script in the Oracle 8 DBA Handbook dealing with deleting archivelogs after hot backup.

Hth,

--
Sybrand Bakker, Oracle DBA
Verna Legaspi <verna.legaspi_at_attws.com> wrote in message news:826pii$ijt$1_at_redftp.redftp.attws.com...
> Hi everyone,
>
> I just want to confirm that there's not automatic way, through Oracle, of
> deleting any log files. I have inherited Oracle 7.3.2, 805, 8i databases,
> and OAS 3 & 4. That's a lot of potential logging. We've had several
> "emergencies" of disks running out of space for logging. Is it true that
> log files are not deleted automatically by Oracle? If we want it done, is
> it probably via a cron job to first store them to tape, and then delete
> them? Or is there some way via Oracle to have this done?
>
> TIA,
> Verna
>
>
>
Received on Thu Dec 02 1999 - 16:24:38 CST