Re: How long should the archive log file be kept?

From: Yang <yg.yang_at_wanadoo.fr>
Date: Mon, 16 Apr 2001 19:48:18 +0200
Message-ID: <9bfbal$4fv$1@wanadoo.fr>

This depends on how many archive logs you have generated per day. The more you have, the often you should make cold/hot backup and then delete your old archive logs.

David Yeung wrote in message <3ADA819E.EF2B212E_at_ust.hk>...
>We are running Oracle8i in archive mode. After each tablespace is backed up
>with steps:
>
> alter tablespace begin backup
> .. copy the datafiles to tapes ...
> alter tablespace end backup
>
>Can we discard the older archive log files which were created before the
>backup?
>
>Usually, how long should the archive log file be kept after a full hot
backup?
>
>Thanks
>
>david
Received on Mon Apr 16 2001 - 12:48:18 CDT