Delete Old archive log- URGENT

Hi all,
Database is hanging error message
check alert log

[Edited by richardana on 11-20-2001 at 01:31 PM]

As long as they have been backed up, sure, delete them.

Prevention is better than cure.
Thanks

[Edited by richardana on 11-20-2001 at 01:31 PM]

to be very sure for recovery sake,
just delete the archive log not later than the last offline backup.

Quote:

---

Originally posted by richardana
How ? this is my first time and I do not want screw anything
Please give me an example of how. I know it sounds stupid but prevention is better than cure
Thanks

---

You can delete them with an OS command. For example, on unix, you can:
find /u01/oraarch/mysid/ -mtime +1 -exec rm -f {} \;

Hello,

I you are not sure about backup, you can also look for free space in your machine and move some archivelog files to this new location.

Hope this helps

Regards

Thanks to all of you

Yeah, you can delete logs after you have taken backup.

Like in my case i take online backup of my database and archive log backup and delete the archived logs..