Database instance SID shutdown during online backup

[former_member229807]

Hello,

We are facing issues during online backup in production system.

We got below error during online backup :

BR0280I BRBACKUP time stamp: 2016-02-04 05.34.03
BR0315I 'Alter database begin backup' successful
BR0280I BRBACKUP time stamp: 2016-02-04 05.34.03
BR0229I Calling backup utility with function 'backup'...
BR0278I Command output of 'F:\usr\sap\SID\SYS\exe\uc\NTAMD64\backint.exe -u SID -f backup -i I:\oracle\SID\sapbackup\.beskzkob.lst -t file
WARNING: sort_backup_type not specified in .utl file
WARNING: default sort_backup_type to <size> for backup
********************************************************************************
Program:##F:\usr\sap\SID\SYS\exe\uc\NTAMD64\backint.exe 7.7
Input File:##I:\oracle\SID\sapbackup\.beskzkob.lst
Profile:##E:\oracle\SID\11204\database\initSID_Online.utl
Function:##BACKUP
Backup Type:##BACKUP_FILE
********************************************************************************
BR0280I BRBACKUP time stamp: 2016-02-04 06.52.01
BR0312E Database instance SID shutdown during online backup
BR0278I Command output of 'F:\usr\sap\SID\SYS\exe\uc\NTAMD64\brconnect.exe':
BR0801I BRCONNECT 7.20 (35)
PID=10116
BR0280I BRCONNECT time stamp: 2016-02-04 06.51.25
BR0312E Database instance SID shutdown during online backup
BR0280I BRCONNECT time stamp: 2016-02-04 06.51.25
#SIGNAL SENT: 22
BR0252W Function remove() failed for 'I:\oracle\SID\sapbackup\.beskzkob.lst' at location BrCleanup-6
BR0253W errno 13: Permission denied
BR0280I BRBACKUP time stamp: 2016-02-04 06.52.20
BR0317I 'Alter database end backup' successful
BR0056I End of database backup: beskzkob.anf 2016-02-04 06.52.02
BR0280I BRBACKUP time stamp: 2016-02-04 06.52.20
BR0054I BRBACKUP terminated with errors

On checking the event viewer logs we found that on the same time backup fails it gives below warning in system log :

The IO operation at logical block address 7c3a310 for Disk 1 was retried.

We have restarted SAP application, Database and even rebooted the server but it didnt resolve the issue. We refer note 2031239 but it is not applicable in our case.

BR Backup log is attached.

Please suggest.

Regards,

Ateek Shaha

Backup_log.txt.zip

[former_member229807]

Hello,

Issue was with the DISK mapping, During backup the disk was prompting error and detached on the same time which i found in eventlog viewer and same was reported to server team.

Now backup is running fine.

Thanks everyone for your reply.

Best Regards,

Ateek

[former_member215439]

Hi Ateek,

     May I know the steps/procedure how you backup your database intance?

Regards,

JEHizon

[former_member802385]

Hi Ateek,

As per my experience the same issue comes with me three times.

i have rename the file .lock.brb with new name .lock.brbold

Solution:-

go to path

\oracle\SID\sapbackup

see the file with unix command

#ls -l .lock.brb

you will find one lock file

in the same path you rename the .lock file with .lock.brbold name etc. with mv command in unix

after rename the file you schedule the online backup from db13 and check it this will work as i apply the same method three times.

All the best with hope.

anil

[Former Member]

Dear Ateek

Try to take backup through ORASID user

may be it requires permission

Regards

SA

[Former Member]

Hi syed,

Thanxs a lot. solved my issue

[Former Member]

Please to execute your command by 'run as administrator' by the BR*Tools or CMD application.

Regards,

Laurent M.

[Former Member]

Provide the Backup type and check the brtools permissions and respective paths.Not getting then go and find respective note @support.sap.com/notes.

Regards,

Manoj D.

[Former Member]

Hi, check backup_type parameter.

By default is set to: offline.

/ Magnus

[Brindavan_M]

Hi,

As per the  backup log there is" BR0253W errno 13: Permission denied".  could you check the backuplo owneship and permission of the file and also check the perimission in whole directory " /oracle/SID/sapbackup".

Thanks,

Brindavan

[Former Member]

Have a look at the Oracle alert log file.

Which entries are there at the time of the shutdown?

[former_member229807]

I have checked the oracle alert log file but could not see any information about shutdown of database.

Regards,

Ateek.

[Former Member]

Hi Ateek.

can you share with us, the last 100 lines from de alert log from the moment the backup fail ?

Regards.

Osvaldo Ferreira