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

From: David Pomphrey <High.Flight_at_btinternet.com>
Date: Sun, 22 Apr 2001 03:02:45 +0100
Message-ID: <3AE23BC5.2107@btinternet.com>

THe backup must be full, a full HOT backup or a full COLD backup.

D.P.

andrew_webby at hotmail wrote:
>
> You should *only* delete archive log files *after* a successful full cold
> backup. Otherwise your backup is useless.
>
> "David Yeung" <dyeung_at_ust.hk> wrote in message
> news: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 Sat Apr 21 2001 - 21:02:45 CDT