Skip to Content

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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply