Re: Deleteing archive logs

Depending on your backup strategy.
The Archive logs are need if you need to recover to a point in time in the past or to recover after a disk has crashed using your last HOT or COLD backup as a starting point.

If you do not have a plan in place you need to get one. You should test it on a test server.

Refer to the ORACLE Backup and Recovery guide for more iformation.

There is also a Chapter on it in my book: So You Want to be an Oracle DBA.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Bernd Maierhofer" <Bernd.Maierhofer_at_dato.at> wrote in message news:xEzc8.9075$hx1.100506_at_news.chello.at...
> 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
>
>
>
Received on Tue Feb 19 2002 - 16:09:29 CST