Re: Q: Deleteing archive logs

Bernd Maierhofer wrote:
>
> Hi and thanks for an answer:
>
> I have a Oracle-DB running with archive log set to on. The archive log list
> says that the next archive log to be archived is 307 while the oldest ist
> 306.
>
> Does this mean, that I I can delete the archives 1 to 306, because the Db
> already contains the changes which are in these archive logs? Or does this
> mean that depending on the db version I restore I eventually need older
> archive logs to restore all changes up to now?
>
> How do I decide which archive logs I can delete?
>
> Thanks and cheers!
>
> --
> Bernd Maierhofer
> www.dato.at www.teach-it.at

You need every archive log from your last backup to the current point in time (and probably from the backup before that if you don't trust your tapes fully). Whether those archives are on the system or offline on tape is up to you...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."