How to Handle long running backup

This document is based on my personal experience and all the suggestions and feedbacks are welcome to improve this.

How to Handle long running backup

Syntomes :-

Backup is running longer than expected and not canceling as well .
$SAPBACKUP%\.lock.brb no lock file at the location.( if there remove the lock.brb file and Run the backup)
Other backup also failed due to last backup running

When we will check failed backup log below error will show

Action need to be taken:-

You can solve this problem in the following ways:

Start SQLPLUS:

sqlplus “/as sysdba“

SQL> select status from v$backup;

STATUS

——————

ACTIVE

No of rows selected.

Note:- STATUS=ACTIVE means All the tables spaces are on backup status

If all active put the below command on SQL;

SQL> alter database end backup;

Database altered.

SQL> select status from v$backup;

STATUS

——————

NOT ACTIVE

N No of rows selected.

SQL>

Note :- STATUS= NOT ACTIVE :- Means now tables paces are not in backup status

Run the backup again and monitor.

Thank you

Sadiq Iqbal