/oracle/SID/sapbackup is full

[Former Member]

Hi Experts, Our SAP system is running on OS: HP-UX, DB: Oracle, We are in new installation and backup is running using BRtools(DP). Today i seen the /oracle/SID/sapbackup filesystem is used 96 Percent. There are lots of file like arch1_1765_883920400.dbf.Z and besarrzc.anf. How should I clean these and what is the thumb rule ? Please help me. THanks Asad

[Former Member · Accepted solution]

Hi Asad,

As we know sapbackup stores BRTools DB backup related summary and log files. The file "besarrzc.anf" is the detail log file for BRTools backup run. This is only required when you want to restore that backup again using BRTools. Other file seems to be a zip file for your archived log file which you can delete if you have a valid backup of that present in other media.

There is no thumb rule for cleaning up this directory. It is like delete old BRTools files which are not required as you are not going to restore that old backup in your database. There must be some policy in your organization to retain these files.

Regards,

GS

[Former Member · Accepted solution]

Thanks GS, For your reply. In our landscape there are total 9 systems, using the same backup policy running. But in some systems there are no Zip file of archived log file. But some systems are having these. what could be the issue? And one more query,, why the archive log zip file exist at sapbackup directory? Thanks Asad

[ashish_mishra2 · Accepted solution]

Please check crontab scheduler of orasid and root user, there might be some maintenance scripts scheduled by your OS administrator.

To do regular housekeeping of DBA maintenance job locations such as sapcheck, sapreorg , sapbackup... please schedule DB13 - Cleanup logs DBA operation on weekly basis. This will take care of the space.

Cheers !!!

Ashish

[fidel_vales · Accepted solution]

Hi,

As Mishra mentioned, you should schedule a cleanup that will delete files older than 30 days.

The file you mention is a backup of a redo file. Depending on what operation you do you will find them.

[Former Member · Accepted solution]

Hi Asad,

Please check there might be some scripts who copy archive log files and compressing it and saving them in sapbackup location. Do you see them getting copied on daily basis?

SAP does not compress and copy them into sapbackup directory automatically.

As Ashish Mishra discussed please run cleanup jobs from db13 that will clean old BRTools log files from sapbackup/sapcheck/saparch directories.

Regards,

GS

[former_member207186 · Accepted solution]

Hi,

Regarding this issue, you can also refer to point 10 of SAP Note 651812 - "FAQ: BR*TOOLS and SAPDBA".

Regards,

Bíborka