Re: Removing the Archived logs question

You only need the archive logs if you might need to restore to a point earlier than the cold backup.

If you don't have that need, then you can also delete the archive logs that are before your hot backups also. This is assuming that you are doing a full hot backup.

Just a note, if you are using 8.0 and greater, use rman. It actually will create a report that can be used to delete those files that you really don't need to recover.

Pete Sharman <psharman_at_us.oracle.com> wrote in message news:37CC1CE6.9B5587E0_at_us.oracle.com...
> Tapan
>
> Depends on whether you'll ever have the need to recover to before the cold
> backup. If you do, you'll need the archive files. If not, you don't.
>
> Of course, this all begs the question of how you verify the cold backup
has
> worked, since the only real way of checking this is to restore and see if
> the database restarts.
>
> HTH.
>
> Pete
>
> Tapan Trivedi wrote:
>
> > Hi all .
> > I have a general question about hot backups and the nice stuff.If I do a
> > hot backup daily and a cold backup weekly do I need to keep the hot
> > backups before the cold backups. I am trying to arrive at disk capacity
> > requirements for the present systems.
> > So lets say that my hot backups are daily at night. Every Saturday
> > night I do a cold backup. Do I need to keep the archived logs before
> > that Saturday night after the cold backup has been verified ? Also any
> > tips on how to determine if the online redo logs are filled up totally
> > before the switch occurs ??
> >
> > Tapan H Trivedi
>
Received on Wed Sep 01 1999 - 00:14:46 CDT