BR0100E Internal error for 'backup_status: at location BrDbfBackCheck-3

[Amal_aloun_matrouk]

Hello SAP Experts;

In my SAP ERP system running on Oracle DB, lately I am noticing my backup is failing with the following errors:

BR0100E Internal error for 'backup_status: /oracle/SID/sapdata2/sr3_127/sr3.data127' at location BrDbfBackCheck-3

BR0340I Switching to the next online redolog filefor database instance SID ...

BR0321I Switch to the next online redolog file for database instance SID successful

BR0202I Saving space_log

BR0301E SQL error -1142 at location BrTspBackAlter-3, SQL statement:

'/* BRBACKUP */ ALTER TABLESPACE "PSAPSR3" END BACKUP'

ORA-01142: cannot end online backup - none of thefiles are in backup

BR0318E 'Alter tablespace PSAPSR3 end backup' failed

BR0054I BRBACKUP terminated with errors

I tried to re-run it, but the same errors keep coming, I am monitoring the logs via DB13.

Your feedback will be appreciated.

Best regards

Amal Aloun

[janos_mucsi-besze]

Hi Amal,

BRBACKUP and so BR*Tools is working fine.

There is a problem with the data file '/oracle/SID/sapdata2/sr3_127/sr3.data127'. 

Here is what to do:

1.) Check if the file exists on the disk. You can check this e.g. with "ls -al" command

2.) If the file exists, check if the file is in a correct status and it is online
SQL> select FILE#,NAME,STATUS from v$datafile where name like '%sr3.data127%';
SQL> select FILE_ID,FILE_NAME,STATUS from dba_data_files where FILE_NAME like '%sr3.data127%';

3.) Perform the necessary changes to bring the file ONLINE.

In case the file is not present on the disk, use a backup and recover the datafile.

Regards,

János