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

From: James Williams <willjamu_at_mindspring.com>
Date: Mon, 16 Apr 2001 16:06:32 GMT
Message-ID: <3adb1814.60094218@nntp.mindspring.com>

On Mon, 16 Apr 2001 13:22:38 +0800, David Yeung <dyeung_at_ust.hk> wrote:

You only need enough to do forward recovery from your last hot or cold backup. I keep about 30 days worth myself in case I need to use Log Miner to analyze. Also, depnends on frequency for backup.

>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 - 11:06:32 CDT