oraarch is full

[Former Member]

The oraarch partition is going to be out of space very soon so can anybody tell me as to how to shrink & delete the oraarch (archive log) so as to avoid the space problem

[Former Member]

Hi Daniel,

If you do backup the archive and use save_delete method or double_save_delete/second_copy_delete,delete

than the archive file will be delete automatically after the file archive get backup.

Please check your init<SID>.sap file for the setting:

1. brarchive function [save | second_copy | double_save | save_delete

2. | second_copy_delete | double_save_delete | copy_save

3. | copy_delete_save | delete_saved | delete_copied]

4. default: save

archive_function = copy_delete_save

Hope this help.

Fendi

[Former Member]

Hi Daniel

This is commonly known as 'Archiver Stuck'. Please have a look at sap note 391 - Archiver Stuck.

If the oraarch Dir is full your database (and the SAP system) will hang. The *.dbf files are your archived redo logs containing all the changes happening in your system. They are needed if you do a restore / recovery of your database and should be saved to tape.

Regards, Michael

[stefan_koehler]

Hi Daniel,

if you run your database in archive mode.. you have to backup your archivelogs and after that you can delete them.

BR*Tools are providing the needed functions for that:

http://help.sap.com/saphelp_nw70/helpdata/en/70/65d70054154c6a8aee4cda5c9e4736/content.htm

If you only delete them you are not able to recover your database after an online backup

Regards

Stefan