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:
- 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