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

select min(backup_date) from your_most_recent_hot_backup_set

Whenever your oldest backup was taken - you need all of the archived redo logs since that point in time.
(unless you intend to offline drop that datafile during recovery)

David Yeung wrote:

> 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 - 17:13:04 CDT