Backup error QA Server

[Former Member]

Dear all,

Online backup got failed , pls check the below logs .

09.08.2010 12:26:48 Job started

09.08.2010 12:26:48 Step 001 started (program RSDBAJOB, variant &0000000000028, user ID S2K_BASIS)

09.08.2010 12:26:48 Execute logical command BRBACKUP On host SAPDEVQA

09.08.2010 12:26:48 Parameters:-u / -jid ALLOG20100809122647 -c force -t online -m all -p initIRQ.sap -a -c force -p initIRQ.sap -c

09.08.2010 12:26:48 ds

09.08.2010 12:26:48 BR0051I BRBACKUP 7.00 (48)

09.08.2010 12:26:48 BR0055I Start of database backup: bedvyqyq.ant 2010-08-09 12.26.48

09.08.2010 12:26:48 BR0252E Function fopen() failed for '/oracle/IRQ/sapbackup/bedvyqyq.ant' at location main-9

09.08.2010 12:26:48 BR0253E errno 28: No space left on device

09.08.2010 12:26:48 BR0121E Processing of log file /oracle/IRQ/sapbackup/bedvyqyq.ant failed

09.08.2010 12:26:48

09.08.2010 12:26:48 BR0056I End of database backup: bedvyqyq.ant 2010-08-09 12.26.48

09.08.2010 12:26:48 BR0280I BRBACKUP time stamp: 2010-08-09 12.26.48

09.08.2010 12:26:48 BR0054I BRBACKUP terminated with errors

09.08.2010 12:26:48 External program terminated with exit code 3

09.08.2010 12:26:48 BRBACKUP returned error status E

09.08.2010 12:26:48 Job finished

Kindly advise

[Former Member]

Issue has been resolved after make the free space on Oracle/IRQ ...

[Former Member]

Hi,

Please check if there is sufficient free space in "/oracle/IRQ/sapbackup/"

Can you post the output of below command ?

#df -g

Regards.

Rajesh Narkhede

[Former Member]

Hi Rjaesh ,

I have checked space of oracle/IRQ , its shows 100% .

let me know to resolve that issue ..

Kindly advise

[Former Member]

Hi Rajesh ,

Pls check the file system space for QA server (Oracle/IRQ)

ev/oraqacsidlv 12.00 12.00 0.00 100% /oracle/IRQ

ev/oraqachomelv 15.00 3.53 11.47 24% /oracle/IRQ/102_64

ev/sapqacreorglv 2.00 0.02 1.98 1% /oracle/IRQ/sapreorg

ev/qacdata1lv 59.00 48.19 10.81 82% /oracle/IRQ/sapdata1

ev/qacdata2lv 55.00 44.31 10.69 81% /oracle/IRQ/sapdata2

ev/qacdata3lv 62.00 52.49 9.51 85% /oracle/IRQ/sapdata3

ev/qacdata4lv 58.00 47.80 10.20 83% /oracle/IRQ/sapdata4

ev/oqaclogalv 0.50 0.11 0.39 22% /oracle/IRQ/origlogA

ev/oqaclogblv 0.50 0.11 0.39 22% /oracle/IRQ/origlogB

ev/mqaclogalv 0.50 0.10 0.40 20% /oracle/IRQ/mirrlogA

ev/mqaclogblv 0.50 0.10 0.40 20% /oracle/IRQ/mirrlogB

ev/oraarchqaclv 30.00 21.79 8.21 73% /oracle/IRQ/oraarch

Kindly advise to resolve space issue ...

[Former Member]

Hi,

What is the size of "/oracle/<SID> ?

You can find and delete "core" file under /oracle/<SID>/saptrace/background

Also try to clean up old log file from /oracle/<SID>/saptrace/background and usertrace.

It would be better to increase the size of "/oracle/<SID> mount point.

Regards.

Rajesh Narkhede

[Former Member]

Hi Rajesh ,

Oracle/IRQ size is 12GB ..

[Former Member]

Hi,

You should increase the size of /oracle/<SID to 20GB.

Have you checked the old logs and "core" file ?

Cleaning up the same will free up some space...

Regards.

Rajesh Narkhede

[Former Member]

Hi Rajesh ,

pls check the below output.

ROOT@SAPDEVQA:/oracle/IRQ/sapbackup#du -g /oracle/IRQ/saptrace

3.59 /oracle/IRQ/saptrace/background

8.38 /oracle/IRQ/saptrace/usertrace

11.97 /oracle/IRQ/saptrace

ROOT@SAPDEVQA:/oracle/IRQ/sapbackup#

more than 8 GB spaces are occupied /oracle/IRQ/saptrace/usertrace , let me know what are the old logs i have to be delete /oracle/IRQ/saptrace/usertrace , kindly provide detail info for deletetion of old logs in this directory (/oracle/IRQ/saptrace/usertrace)

Kindly advise

[Former Member]

Hi Rajesh ,

I have checked /oracle/IRQ/saptrace/background and i found alert_IRQ.log (it occupied more than 1 GB space ) ,

shall i delete alert_IRQ.log ,its advisable .

Kindly advise

[Former Member]

Hi Sathish,

It is not advisable to delete "alert_<SID>.log" file as it contains useful trace regarding oracle activities. The same will helpful in case of troubleshooting oracle related issues.

What you can do is, first backup the current "alert_<SID>.log" and then delete it.

Rather deleting, use the below command to erase the contents of this log file..

#su - ora<sid>
# echo > /oracle/<SID>/saptrace/background/alert_<SID>.log

Next find *.old files under usertrace, saptrace and background directory and delete them.

Regards.

Rajesh Narkhede

[volker_borowski2]

Hi,

check out help.sap.com for options to brconnect-run "cleanup logs".

There are some 20 initSID.sap parameters, you can twist to decide how long you want

to keep backup-logs, disk-backups, oracle-tracefiles and so on.

Then schedule "brconnect -c -u / -f cleanup" periodicly and it will take care of all your logs.

For the alert log, you should set up a logrotate. This is easy, because Oracle is not

holding an active file handle to the alert log. It reopens as needed. Now an alert log of

1GB really takes some performance, because every logswitch needs to seek end-of-file

in the alert log, so this will increase log-switch-time!

Just rename the log to ".old", and do a logswitch, to verify, that a new file is created.

If this does not happen, somethings wrong with the permissions of directory ".../background"

You can then compress the log with a utility of your choice and will get back ~70-80% of space.

Schedule this once a month, depending on your log-growing situation.

Watch out for the listener.log in $ORACLE_HOME/network/log.

The listener holds a permanent handle to this file, SO DO NOT SIMPLY MOVE IT.

You need to restart the listener in addition to make it write a new log!

Volker

[Former Member]

HI,

The error is showing that no space is left on the device.

Thanks&Regards

Prashant