SAP offline backup not working

[Former Member]

My offline Backup is not working . I have windows 2012 R2 in production environment and there is Windows cluster environment.

Log is as below:

SAP_SCHEDULED = 1 SAP_USER_INITIATED = 0 SAP_SERVER = phltpc-prdbkp.lthed.com SAP_POLICY = Weekly_Offline SAP_SCHED = SAP_SNC_SCHED = Full_Offline BR0051I BRBACKUP 7.40 (12) BR0055I Start of database backup: bevbbxgu.aff 2017-01-29 09:27:56 BR0484I BRBACKUP log file: K:\oracle\LPP\sapbackup\bevbbxgu.aff BR0477I Oracle pfile F:\oracle\LPP\11204\database\initLPP.ora created from spfile F:\oracle\LPP\11204\database\spfileLPP.ora BR0280I BRBACKUP time stamp: 2017-01-29 09:27:58 BR0057I Backup of database: LPP BR0058I BRBACKUP action ID: bevbbxgu BR0059I BRBACKUP function ID: aff BR0110I Backup mode: ALL BR0077I Database files for backup: I:\ORACLE\LPP\MIRRLOGA\LOG_G11M2.DBF I:\ORACLE\LPP\MIRRLOGB\LOG_G12M2.DBF I:\ORACLE\LPP\MIRRLOGA\LOG_G13M2.DBF I:\ORACLE\LPP\MIRRLOGB\LOG_G14M2.DBF H:\oracle\LPP\origlogA\cntrl\cntrlLPP.dbf BR0061I 50 files found for backup, total size 206241.682 MB BR0143I Backup type: offline_force BR0130I Backup device type: util_file BR0109I Files will be saved by backup utility at file level BR0126I Unattended mode active - no operator confirmation required BR0280I BRBACKUP time stamp: 2017-01-29 09:27:58 BR0307I Shutting down database instance LPP ... BR0278E Command output of 'F:\oracle\LPP\11204\BIN\sqlplus /nolog < K:\oracle\LPP\sapbackup\.bevbbxgu.spi': SQL*Plus: Release 11.2.0.4.0 Production on Sun Jan 29 09:27:58 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. SQL> Connected. SQL> SQL> SQL> SQL> SQL> SQL> SQL> ORA-03113: end-of-file on communication channel SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options BR0280I BRBACKUP time stamp: 2017-01-29 09:28:06 BR0279E Return code from 'F:\oracle\LPP\11204\BIN\sqlplus /nolog < K:\oracle\LPP\sapbackup\.bevbbxgu.spi': 0 BR0302E SQLPLUS call for database instance LPP failed BR0309E Shutdown of database instance LPP failed BR0280I BRBACKUP time stamp: 2017-01-29 09:28:06 BR0301E SQL error -12560 at location BrDbConnect-3, SQL statement: 'CONNECT /' ORA-12560: TNS:protocol adapter error BR0310E Connect to database instance LPP failed BR0056I End of database backup: bevbbxgu.aff 2017-01-29 09:28:06 BR0280I BRBACKUP time stamp: 2017-01-29 09:28:06 BR0054I BRBACKUP terminated with errors Execution of BRBACKUP command failed - exiting

_________________________________________________________________________

Please help on the same

[janos_mucsi-besze]

Hi Utkarsh,

I see here several things:

1.) Backing utility is used

(BR0130I Backup device type: util_file)

2.) Offline backup is used

(bevbbxgu.aff) - where aff stands for: a - whole database backup, f - offline backup, f - external backup utility

3.) The provided log does not contain the exact command used.

I suggest you to check note #378648 - Offline backup support with Oracle Fail Safe

and get in touch with our Backint partners (note 83792 - SAP partners who support the BACKINT/SPLITINT interface) because in such cases they have to check first if there is no issues on their software/hardware side.

Regards,

János

[tan_michael]

Hi Utkarsh,

Have you checked the initLPP.sap? in /oracle/LPP/11204 and have you shutdown the database when you're performing an offline backup?

[tan_michael]

/oracle/LPP/11204/database * correction