[HELP] Redolog backup error when 100%

[Former Member]

Dear Experts,

I have problem with redolog backup. Here is the error result.  Database backup is successfully.

Percentage done for redolog backup is 100%

BR0204I Percentage done: 100.00%, estimated end time: 6:57

BR0001I **************************************************

BR0016I 187 offline redo log files processed, total size 51137.456 MB

BR0202I Saving space_log

BR0203I to /dev/rmt/0mn ...

BR0202I Saving det_log

BR0203I to /dev/rmt/0mn ...

BR0202I Saving sum_log

BR0203I to /dev/rmt/0mn ...

BR0280I BRARCHIVE time stamp: 2013-01-04 06.57.15

BR0226I Rewinding tape volume in device /dev/rmt/0m ...

BR0351I Restoring /oracle/AOP/sapreorg/.tape.hdr0

BR0355I from /dev/rmt/0mn ...

BR0278E Command output of 'LANG=C cd /oracle/PRD/sapreorg && /usr/sap/PRD/SYS/exe/run/brtools -f detach LANG=C cpio -iuvB .tape.hdr0 < /dev/rmt/0mn':

cpio: Cannot write ".tape.hdr0", errno 28, No space left on device

10 blocks

1 error(s)

BR0280I BRARCHIVE time stamp: 2013-01-04 06.58.19

BR0279E Return code from 'LANG=C cd /oracle/PRD/sapreorg && /usr/sap/PRD/SYS/exe/run/brtools -f detach LANG=C cpio -iuvB .tape.hdr0 < /dev/rmt/0mn': 1

BR0359E Restore of /oracle/AOP/sapreorg/.tape.hdr0 from /dev/rmt/0mn failed due to previous errors

BR0218E Checking label on volume in device /dev/rmt/0mn failed

Permission for /oracle/PRD/sapreorg ; /oracle/PRD/saparch is 777 and free space >90%

Kindly help me to find what the root cause for this issue.

Thank You

Edy

[Former Member · Accepted solution]

Additionally check the owners of brtools;

Note 113747 - Owners and authorizations for BR*Tools

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Hi Orkun,

Free space for /oracle/AOP/sapreorg is 94%

This is first time i got trouble with this error, before i got this error, the backup running well.

All permission same with the sapnotes that you give.

What should i do?

Thanks

Edy

[volker_borowski2 · Accepted solution]

Hello,

try the command manually, to validate if the error persists.

Ary you backing up as orasid or sidadm (DB13) ?

Try as the same user:

cd /oracle/AOP/sapreorg

cpio -iuvB .tape.hdr0 < /dev/rmt/0mn

ls -l .tape.hdr0

Normaly such an error is not lying.

Crosscheck if the FS is mounted read-only for whatever strange reason,

or is NFS mounted without enough host permissions.

Attaching output of

df -k

mount

ls -ld /oracle/AOP/sapreorg /oracle/AOP/sapreorg/.tape.hdr0

might help us diagnosing...

Any chance, that someone applied user-quotas to your filesystems.

Volker

[Former Member · Accepted solution]

Hi Volker,

Thank you for your response.

Backup was failed at 06:58 AM and on /var/adm/message, i found /oracle/AOP/sapreorg is full

Jan 4 04:14:20 eccprod ufs: [ID 845546 kern.notice] NOTICE: alloc: /oracle/AOP/sapreorg: file system full

Jan 4 04:18:25 eccprod last message repeated 37 times

Jan 4 06:58:19 eccprod ufs: [ID 845546 kern.notice] NOTICE: alloc: /oracle/AOP/sapreorg: file system full

Jan 4 08:02:50 eccprod last message repeated 15 times

Why this folder full? What kind of data store on this folder?

Thanks

Edy

[volker_borowski2 · Accepted solution]

Hi,

every time you do a structure change, a backup of the controlfile is stored there.

every time you change a parameter with brtools a backup of the spfile is stored there.

In case you do table exports, oracle dumpfiles are stored there.

In case you do real verify runs, the datafiles are restored to sapreog to do the verification.

I case such a run aborts old restored datafiles remain.

You can get rid of outdated stuff with "brconnect -c -u / -f cleanup".

Need to maintain several cleanup_*parameter in initSID.sap beforethe call.

Lost brbackup verification files need to be deleted manually.

And people tend to store stuff there 😉

Very often you find /oracle/stage symlinked to saprorg ...

Volker

[Former Member · Accepted solution]

Thank you volker for your explanation 🙂

[volker_borowski2 · Accepted solution]

Well,

although I did provide an explanation, the solution was provided by Orkun in the first response,

so you should change the rateing accordingly.

Volker

[Former Member]

Hi Edy,

>> BR0351I Restoring /oracle/AOP/sapreorg/.tape.hdr0

>>BR0355I from /dev/rmt/0mn ...

>>BR0278E Command output of 'LANG=C cd /oracle/PRD/sapreorg >>&& /usr/sap/PRD/SYS/exe/run/brtools -f detach LANG=C cpio -iuvB .tape.hdr0 < /dev/rmt/0mn':

>>cpio: Cannot write ".tape.hdr0", errno 28, No space left on device

Check free space under "/oracle/AOP/sapreorg"

Best regards,

Orkun Gedik