cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos
103

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

Accepted Solutions (0)

Answers (1)

Answers (1)

janos_mucsi-besze
Product and Topic Expert
Product and Topic Expert
0 Kudos

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