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:

1. login to the System at OS level

2. Go to Start

3. Go to Run

4. Type cmd and enter

Start SQLPLUS:

sqlplus “/as sysdba“

SQL> select status from v$backup;

STATUS

——————

ACTIVE

ACTIVE

ACTIVE

ACTIVE

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

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

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