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

This works:

select max(sequence#)
  from v$archived_log
 where to_char(first_time,'RRRRMMDD HH24:MI:SS')<

       (select min(to_char(time,'RRRRMMDD HH24:MI:SS'))
          from v$backup)

As v$backup has the most recent time for each datafile it was placed into backup mode.

that was a fun one.

Paul

Paul Drake wrote:
>
> 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 Tue Apr 17 2001 - 01:33:48 CDT