Data Protector Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

SAP/R3 Backup Specification Errors

Highlighted
Frequent Advisor

SAP/R3 Backup Specification Errors

[ Edited ]

I am having issues with using the SAP/R3 backup specifications within Data Protector for our SAP Oracle backups. Here is the backup text:

 

BR0051I BRBACKUP 7.00 (52)

BR0055I Start of database backup: beiyuemf.anf 2012-07-11 15.47.57

BR0484I BRBACKUP log file: D:\oracle\sm1\sapbackup\beiyuemf.anf

BR0280I BRBACKUP time stamp: 2012-07-11 15.47.57

BR0301E SQL error -27046 at location BrInitOraCreate-5, SQL statement:

'/* BRBACKUP AT PROF_CONN */ CREATE PFILE = 'D:\oracle\SM1\102\database\sapSM1.ora' FROM SPFILE = 'D:\oracle\SM1\102\database\spfileSM1.ora''

ORA-27046: file size is not a multiple of logical block size

OSD-04012: file size mismatch (OS 3627)

BR0303E Determination of Oracle version failed

 

BR0056I End of database backup: beiyuemf.anf 2012-07-11 15.47.57

BR0280I BRBACKUP time stamp: 2012-07-11 15.47.57

BR0054I BRBACKUP terminated with errors

[Major] From: OB2BAR_OMNISAP@<Company> "OMNISAP"  Time: 7/11/2012 3:47:59 PM

      BRBACKUP D:\usr\sap\SM1\DVEBMGS00\exe\brbackup.exe -t online -d util_file -c -m all -u sapbackup/******* returned 3

 

BR0002I BRARCHIVE 7.00 (52)

BR0006I Start of offline redo log processing: aeiyuemh.cds 2012-07-11 15.47.59

BR0252E Function fopen() failed for 'L:\oracle\SM1\saparch\aeiyuemh.cds' at location main-6

BR0253E errno 2: No such file or directory

BR0121E Processing of log file L:\oracle\SM1\saparch\aeiyuemh.cds failed

 

BR0007I End of offline redo log processing: aeiyuemh.cds 2012-07-11 15.47.59

BR0280I BRARCHIVE time stamp: 2012-07-11 15.47.59

BR0005I BRARCHIVE terminated with errors

[Major] From: OB2BAR_OMNISAP@<Company> "OMNISAP"  Time: 7/11/2012 3:48:01 PM

      BRARCHIVE D:\usr\sap\SM1\DVEBMGS00\exe\brarchive.exe -d util_file  -cds -c -u sapbackup/******* returned 3

 

 

[Normal] From: <Company> "z_SM1_SERVER"  Time: 7/11/2012 3:48:01 PM

      OB2BAR application on "<Company> " disconnected.

 

[Critical] From: <Company> "z_SM1_SERVER"  Time: 7/11/2012 3:48:01 PM

      None of the Disk Agents completed successfully.

      Session has failed.

 

[Normal] From: <Company> "z_SM1_SERVER"  Time: 7/11/2012 3:48:01 PM

 

      Backup Statistics:

         

            Session Queuing Time (hours)         0.00       

            -------------------------------------------     

            Completed Disk Agents ........          0         

            Failed Disk Agents ...........          0         

            Aborted Disk Agents ..........          0         

            -------------------------------------------     

            Disk Agents Total  ...........          0         

            ===========================================     

            Completed Media Agents .......          0         

            Failed Media Agents ..........          0         

            Aborted Media Agents .........          0         

            -------------------------------------------     

            Media Agents Total  ..........          0         

            ===========================================     

            Overall Deduplication Ratio ..          -           

            ===========================================     

            Mbytes Total .................       0 MB       

            Used Media Total .............          0         

            Disk Agent Errors Total ......          0   

 

 

============================================================================

                      Session failed!

============================================================================

 

I have Oracle BAckup Specs built for these databases as well, and they run without errors. But with BRtools, I get failures. Can someone shed some light on these particular errors, so I can begin isolating this issue? Thanks!

 

Chris

1 REPLY
Frequent Advisor

Re: SAP/R3 Backup Specification Errors

Check with ur DB admin on the following errors:

 

BR0301E SQL error -27046 at location BrInitOraCreate-5, SQL statement:

'/* BRBACKUP AT PROF_CONN */ CREATE PFILE = 'D:\oracle\SM1\102\database\sapSM1.ora' FROM SPFILE = 'D:\oracle\SM1\102\database\spfileSM1.ora''

ORA-27046: file size is not a multiple of logical block size

OSD-04012: file size mismatch (OS 3627)

BR0303E Determination of Oracle version failed

 

BR0056I End of database backup: beiyuemf.anf 2012-07-11 15.47.57

BR0280I BRBACKUP time stamp: 2012-07-11 15.47.57

BR0054I BRBACKUP terminated with errors

 

Backup spec is OK