Online Backup issue on sql server

[Former Member]

Dear All,

Backup failed due to the below reason , kindly suggest on this.

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:

PSAPSR3, PSAPSR3701, PSAPSR3USR, PSAPYBMCD, PSAPYBMCI

BR0280I BRBACKUP time stamp: 2011-11-09 20.00.09

BR0057I Backup of database: BIQ

BR0058I BRBACKUP action ID: behelvyk

BR0059I BRBACKUP function ID: anf

BR0110I Backup mode: ALL

BR0077I Database file for backup: M:\oracle\BIQ\sapbackup\CNTRLBIQ.DBF

BR0061I 21 files found for backup, total size 99734.016 MB

BR0143I Backup type: online

BR0130I Backup device type: util_file_online

BR0109I Files will be saved by backup utility

BR0142I Files will be switched to backup status during the backup

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRBACKUP time stamp: 2011-11-09 20.00.09

BR0229I Calling backup utility with function 'backup'...

BR0278I Command output of 'E:\usr\sap\BIQ\SYS\exe\uc\NTAMD64\backint.exe -u BIQ -f backup -i M:\oracle\BIQ\sapbackup\.behelvyk.lst -t file_online -p C:\oracle\BIQ\112\databas

WARNING: sort_backup_type not specified in .utl file

WARNING: default sort_backup_type to <size> for backup

********************************************************************************

Program:##E:\usr\sap\BIQ\SYS\exe\uc\NTAMD64\backint.exe 7.0

Input File:##M:\oracle\BIQ\sapbackup\.behelvyk.lst

Profile:##C:\oracle\BIQ\112\database\initBIQ.utl

Function:##BACKUP

Backup Type:##BACKUP_FILE_ONLINE

********************************************************************************

09:08:09.441 [3668.4484] <1> : Requested to keep <D:\ORACLE\BIQ\SAPDATA2\SR3_1\SR3.DATA1> in backup mode/offline.

BR0280I BRCONNECT time stamp: 2011-11-10 09.08.10

[Former Member]

closing the thread

[Former Member]

closing the thread

[Former Member]

Backup Type:##BACKUP_FILE_ONLINE

********************************************************************************

09:08:09.441 [3668.4484] <1> : Requested to keep <D:\ORACLE\BIQ\SAPDATA2\SR3_1\SR3.DATA1> in backup mode/offline.

BR0280I BRCONNECT time stamp: 2011-11-10 09.08.10

#BEGIN D:\ORACLE\BIQ\SAPDATA2\SR3_1\SR3.DATA1

BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0280I BRCONNECT time stamp: 2011-11-10 09.08.10

09:08:12.453 [3668.4484] <1> : <D:\ORACLE\BIQ\SAPDATA2\SR3_1\SR3.DATA1> is kept in backup mode/offline.

[3668.01] 09:08:10 INF - Data buffer size = 131072

09:08:12.461 [3668.4484] <1> : Backup of <D:\ORACLE\BIQ\SAPDATA2\SR3_1\SR3.DATA1> is in progress.

[3668.01] 09:08:14 INF - Using Media ID 626AAK for Backup ID GSAPNPBIQ-BKP_1320916070

09:27:37.542 [3668.4484] <1> : Requesting to release <D:\ORACLE\BIQ\SAPDATA2\SR3_1\SR3.DATA1> from backup mode / bring online.

09:27:37.542 [3668.4484] <1> : Requested to keep <D:\ORACLE\BIQ\SAPDATA2\SR3_2\SR3.DATA2> in backup mode/offline.

BR0280I BRCONNECT time stamp: 2011-11-10 09.27.38

#END D:\ORACLE\BIQ\SAPDATA2\SR3_1\SR3.DATA1

BR0317I 'Alter tablespace PSAPSR3 end backup' successful

BR0280I BRCONNECT time stamp: 2011-11-10 09.27.38

BR0280I BRCONNECT time stamp: 2011-11-10 09.27.41

#END D:\ORACLE\BIQ\SAPDATA2\SR3_4\SR3.DATA4

BR0317I 'Alter tablespace PSAPSR3 end backup' successful

BR0280I BRCONNECT time stamp: 2011-11-10 10.26.11

BR0280I BRCONNECT time stamp: 2011-11-10 10.26.15

#BEGIN D:\ORACLE\BIQ\SAPDATA2\SR3_5\SR3.DATA5

BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0280I BRCONNECT time stamp: 2011-11-10 10.26.16

10:26:17.103 [3668.4484] <1> : <D:\ORACLE\BIQ\SAPDATA2\SR3_5\SR3.DATA5> is kept in backup mode/offline.

10:26:17.111 [3668.4484] <1> : Backup of <D:\ORACLE\BIQ\SAPDATA2\SR3_5\SR3.DATA5> is in progress.

10:46:00.203 [3668.4484] <1> : Backup of <D:\ORACLE\BIQ\SAPDATA2\SR3_1\SR3.DATA1> is failed due to <Error 150 : Server Status: termination requested by administrator>.

10:46:00.203 [3668.4484] <1> : Backup of <D:\ORACLE\BIQ\SAPDATA2\SR3_2\SR3.DATA2> is failed due to <Error 150 : Server Status: termination requested by administrator>.

10:46:00.203 [3668.4484] <1> : Backup of <D:\ORACLE\BIQ\SAPDATA2\SR3_3\SR3.DATA3> is failed due to <Error 150 : Server Status: termination requested by administrator>.

10:46:00.203 [3668.4484] <1> : Backup of <D:\ORACLE\BIQ\SAPDATA2\SR3_4\SR3.DATA4> is failed due to <Error 150 : Server Status: termination requested by administrator>.

10:46:00.203 [3668.4484] <1> : Backup of <D:\ORACLE\BIQ\SAPDATA2\SR3_5\SR3.DATA5> is failed due to <Error 150 : Server Status: termination requested by administrator>.

10:46:00.203 [3668.4484] <1> : Backup of <D:\ORACLE\BIQ\SAPDATA2\SR3_6\SR3.DATA6> is failed due to <Error 150 : Server Status: termination requested by administrator>.

10:46:00.203 [3668.4484] <1> : Backup of <D:\ORACLE\BIQ\SAPDATA3\SR3701_1\SR3701.DATA1> is failed due to <Error 150 : Server Status: termination requested by administrator>

10:46:00.203 [3668.4484] <1> : Backup of <D:\ORACLE\BIQ\SAPDATA3\SR3701_2\SR3701.DATA2> is failed due to <Error 150 : Server Status: termination requested by administrator>

10:46:00.204 [3668.4484] <1> : Backup of <D:\ORACLE\BIQ\SAPDATA3\SR3701_3\SR3701.DATA3> is failed due to <Error 150 : Server Status: termination requested by administrator>

10:46:00.204 [3668.4484] <1> : Backup of <D:\ORACLE\BIQ\SAPDATA3\SR3701_4\SR3701.DATA4> is failed due to <Error 150 : Server Status: termination requested by administrator>

Kindly advise

[Former Member]

As far as I understand, you are trying take backup of 'oracle' on 'TSM'.

It seems that the backup was canceled or terminated from TSM server side if you haven't done it from SAP side by yourself.

Once contact your TSM team to get to know what happened on TSM side when this backup was running and terminated in between.

Thanks