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:
- login to the System at OS level
- Go to Start
- Go to Run
- 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