BR0328E: Database file is already in Backup Status

Symptom

You are getting error “BR0328E Database file /oracle/SID/sapdata1/xxx/xxx.data1 of tablespace PSAPxxx is already in backup status”.

Solution

1. Go to transaction code DB02. Click on current size. Check if the Backup is ACTIVE, if ACTIVE, continue to below steps. (Alternatively, you can check via SQL*Plus)

SQL> select STATUS from V$BACKUP;

STATUS
------------------
NOT ACTIVE
NOT ACTIVE
NOT ACTIVE
NOT ACTIVE

1. Login to the operating system as ORASID, go to SQL*Plus and execute below command

SQL> alter tablespace <TABLESPACE-NAME> end backup;

Tablespace altered.

2. Go to transaction code DB02 again, click refresh and check the backup status is not active. Rerun the backup again.