Skip to Content

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

NEw1.png

When we will check failed backup log below error will show

/wp-content/uploads/2014/05/new2_445712.png

Action need to be taken:-

You can solve this problem in the following ways:

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

/wp-content/uploads/2014/05/new3_445713.png

Thank you

Sadiq Iqbal

Be the first to leave a comment
You must be Logged on to comment or reply to a post.