DB13 error: 0003 Error during initialization

[Former Member]

Dear All,

Since last 2 days, Production backup is getting failed with error "0003 Error during initialization".

Strangely, there are no related logs to investigate further... Nothing was changed in backup related configurations.

We are using Tivoli (TSM) backup solution..

System Details: HP-UX 11.31i, Oracle10g (10.2.0.4), ECC 6.0

In DB13 Action logs, it is showing following details only...

Action: Whole database offline backup

Brbackup logfile : bedjjsnb.log ##### Actually it should show filename something like "bedjjsnb.aff"

Return Code : 0003 Error during initialization

When I click on "Show Actiion/Detail log", it shows nothing... (Log file does not exists..)

There is no file with above filename in /oracle/<SID>/sapbackup and in back<SID>.log

I have checked below things :

1. BRTOOL permissions (As per note 113747 - Permissions for DBA tools BRTools and SAPDBA)

2. /oracle/<SID>/sapbackup permissions (it is 755 with ora<sid>:dba ownership)

3. I have checked /var/adm/syslog/syslog.log, but there is no error.

4. Test for communication between SAP server and Tivoli is OK.

5. TSM Session query is also returning desired result.

6. I made sure that there are free and scratched tape in TSM for SAP backup pool.

7. No other backup was running at the time of SAP backup.

I have tried taking backup on DISK which is successful without any errors or warnings.

What else I can check ? Am I missing something ?

Any inputs will be highly appreciated...

I will try to fire backup manually later in the evening after business hours to see what exactly going wrong in between.

Regards.

Rajesh Narkhede

[former_member189546 · Accepted solution]

Hello,

Please execute command 'brbackup -q' on os level

Also try

increase tape_size (in initSID.sap)

regards,

John Feely

[Former Member · Accepted solution]

Hi John,

See the last few lines from output below: (SID and Hostname removed...)

BR0110I Backup mode: ALL
BR0077I Database files for backup:
/oracle/<SID>/origlogA/log_g11m1.dbf
/oracle/<SID>/origlogB/log_g12m1.dbf
/oracle/<SID>/origlogA/log_g13m1.dbf
/oracle/<SID>/origlogB/log_g14m1.dbf
/oracle/<SID>/origlogA/cntrl/cntrlHRP.dbf
BR0061I 53 files found for backup, total size 133738.270 MB
BR0143I Backup type: offline
BR0130I Backup device type: util_file
BR0109I Files will be saved by backup utility
BR0124I Query option set - no processing

BR0056I End of database backup: bedjndvn.qub 2010-06-04 17.01.32
BR0280I BRBACKUP time stamp: 2010-06-04 17.01.32
BR0052I BRBACKUP completed successfully
<HOSTNAME>:ora<sid>>

Nothing seems to be wrong...

Regards.

Rajesh Narkhede

[former_member204746 · Accepted solution]

there is a problem with TSM server... or your TSM client.

check *.utl files used in you ORACLE_HOME dbs directory. you can test connectivity by using program BACKFM.

you should ask your TSM admin to check that out. I do not believe that the problem is on Basis' side. Your TSM admin has much more logs on his side.

[Former Member · Accepted solution]

Thanks Erric,

It is still mistery what was the problem...

The problem was definately at Tivoli end. I didn't change anything at my end to see what goes wrong while backup is started...

But later, in the evening after business hours when I fired the backup, it was started and completed successfuly as normal.

The strange thing, When I sits with TSM Admin, there was no logs related to SAP backup. Even we couldn't see any session initiated from SAP server. TSM admin is still trying to come on some conclusion...

Anyway, the problem is resolved now...

I am also trying to trace root cause why there was no communication between TSM and SAP at the time of backup.

Thank for your support....

Regards.

Rajesh Narkhede