cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Backup SAP Oracle Sap does not work

Hi guy,

I hava a problem with a backup sap on Oracle Rac whare ther is two Sap istance.

One work fine and one end in errror.

All data file and configuration file are saved but when the backup saved  utl file detect an error. C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl

 

 

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.48
#PFLOG.... c:\oracle\PP6\sapbackup\backPP62.log
#SAVED.... VXF1379019983
BR0278E Command output of '\\PROD64PRT2\sapmnt\PP6\SYS\exe\uc\NTAMD64\backint.exe -u PP62 -f backup -i c:\oracle\PP6\sapbackup\.bembsjqx.lst -t file -p C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl -c':
[9180] Error detected while reporting backup ids.
********************************************************************************

 

LOG OF BACKUP:

 

BR0051I BRBACKUP 7.20 (30)
BR0055I Start of database backup: bembsjqx.fnr 2013-09-12 22.58.03
BR0484I BRBACKUP log file: c:\oracle\PP6\sapbackup\bembsjqx.fnr

BR0101I Parameters

Name                           Value

oracle_sid                     PP62
oracle_home                    C:\ORACLE\PP6\11203
oracle_profile                 C:\ORACLE\PP6\11203\database\initPP62.ora
                               C:\ORACLE\PP6\11203\database\initPP61.ora
                               C:\ORACLE\PP6\11203\database\initPP6.ora
sapdata_home                   C:\oracle\PP6
sap_profile                    C:\ORACLE\PP6\11203\database\initPP6.rman_weekly.SAP
backup_mode                    FULL
backup_type                    online
backup_dev_type                rman_util
util_par_file                  C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl
rman_channels                  6
rman_filesperset               10
rman_maxopenfiles              10
rman_proxy                     no
rman_parms                     ENV=(NB_ORA_SAP=initPP6.rman.wee.utl)
rman_send                      'NB_ORA_POLICY=pol-psm.ac1368.sap.PP6.sapdbsrv2-vip'
                               'NB_ORA_SCHED=sch-app.wee'
                               'NB_ORA_CLIENT=sapdbsrv2'
rman_compress                  no
parallel_instances             PP61:/oracle/PP6/11203@PP61,
                               PP62:/oracle/PP6/11203@PP62
db_services                    no
asm_ora_sid                    +ASM
asm_ora_home                   /oracle/GRID/11203
asm_root_dir                   ASM
system_info                    ENTERPRISE\pp6adm SAPDBSRV2 Windows 6.1 Build 7601 Service Pack 1 AMD64
oracle_info                    PP6 11.2.0.3.0 8192 29 3939752 SAPDBSRV2 UTF8 UTF8 614571757 &PP6
sap_info                       SAPSR3DB
make_info                      NTAMD64 OCI_11201_SHARE Feb 13 2013
command_line                   \\server2\sapmnt\PP6\SYS\exe\uc\NTAMD64\brbackup.exe -c -u &&&&&/******* -d rman_util -t online -m full -p C:\ORACLE\PP6\11203\database\initPP6.rman_weekly.SAP

BR0116I ARCHIVE LOG LIST before backup for database instance PP62

Parameter                      Value

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +PP6_ARCH/pp6/oraarch
Archive format                 %t_%s_%r.dbf
Oldest online log sequence     26
Next log sequence to archive   29
Current log sequence           29               SCN: 3939752
Database block size            8192             Thread: 2
Current system change number   3941792          ResetId: 824381037

BR0116I ARCHIVE LOG LIST before backup for database instance PP61

Parameter                      Value

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +PP6_ARCH/pp6/oraarch
Archive format                 %t_%s_%r.dbf
Oldest online log sequence     71
Next log sequence to archive   74
Current log sequence           74               SCN: 3939755
Database block size            8192             Thread: 1
Current system change number   3941794          ResetId: 824381037

BR0118I Tablespaces and data files

Tablespace     TS-Status  F-Status  File                                                       Size   Id.     Device  Link    Type       MaxSize     IncrSize  BlkSize      CrtSize         CrtScn

PSAPSR3DB      ONLINE*    ONLINE+   +PP6_DATA/pp6/datafile/psapsr3db.258.824498071      11240742912    5          -4  NOLINK  ASM    34288435200     20971520     8192   1048576000         228574
PSAPSR3DB      ONLINE*    ONLINE+   +PP6_DATA/pp6/datafile/psapsr3db.257.824498069      11429486592    4          -4  NOLINK  ASM    34288435200     20971520     8192   1048576000         228306
PSAPTEMP       ONLINE#    ONLINE+   +PP6_DATA/pp6/tempfile/psaptemp.263.824501461       18664660992   -2          -4  NOLINK  ASM    34288435200     20971520     8192  18664652800        1031207
PSAPUNDO       ONLINE-    ONLINE+   +PP6_DATA/pp6/datafile/psapundo.259.824498071        1027612672    3          -4  NOLINK  ASM    34288435200     20971520     8192    629145600           3413
PSAPUNDO1      ONLINE-    ONLINE+   +PP6_DATA/pp6/datafile/psapundo1.264.824501569       1027612672    6          -4  NOLINK  ASM    34288435200     20971520     8192   1027604480        1031700
PSAPUNDO2      ONLINE-    ONLINE+   +PP6_DATA/pp6/datafile/psapundo2.265.824501573       1027612672    7          -4  NOLINK  ASM    34288435200     20971520     8192   1027604480        1032133
SYSAUX         ONLINE*    ONLINE+   +PP6_DATA/pp6/datafile/sysaux.261.824498073           587210752    2          -4  NOLINK  ASM    34288435200     20971520     8192    209715200           2188
SYSTEM         ONLINE*    SYSTEM+   +PP6_DATA/pp6/datafile/system.260.824498071           471867392    1          -4  NOLINK  ASM    34288435200     20971520     8192    471859200              8

BR0119I Redolog files

File                                                     Size  Group     Device  Status    Link    Type

+PP6_MLOG/pp6/onlinelog/group_11.256.824501337      536871424   11           -5  INUSE     NOLINK  ASM
+PP6_OLOG/pp6/onlinelog/group_11.256.824501337      536871424   11           -6  INUSE     NOLINK  ASM
+PP6_MLOG/pp6/onlinelog/group_12.257.824501339      536871424   12           -5  INUSE     NOLINK  ASM
+PP6_OLOG/pp6/onlinelog/group_12.257.824501339      536871424   12           -6  INUSE     NOLINK  ASM
+PP6_MLOG/pp6/onlinelog/group_13.258.824501343      536871424   13           -5  INUSE     NOLINK  ASM
+PP6_OLOG/pp6/onlinelog/group_13.258.824501341      536871424   13           -6  INUSE     NOLINK  ASM
+PP6_MLOG/pp6/onlinelog/group_14.259.824501347      536871424   14           -5  INUSE     NOLINK  ASM
+PP6_OLOG/pp6/onlinelog/group_14.259.824501347      536871424   14           -6  INUSE     NOLINK  ASM
+PP6_MLOG/pp6/onlinelog/group_21.260.824501359      536871424   21           -5  INUSE     NOLINK  ASM
+PP6_OLOG/pp6/onlinelog/group_21.260.824501359      536871424   21           -6  INUSE     NOLINK  ASM
+PP6_MLOG/pp6/onlinelog/group_22.261.824501363      536871424   22           -5  INUSE     NOLINK  ASM
+PP6_OLOG/pp6/onlinelog/group_22.261.824501361      536871424   22           -6  INUSE     NOLINK  ASM
+PP6_MLOG/pp6/onlinelog/group_23.262.824501367      536871424   23           -5  INUSE     NOLINK  ASM
+PP6_OLOG/pp6/onlinelog/group_23.262.824501365      536871424   23           -6  INUSE     NOLINK  ASM
+PP6_MLOG/pp6/onlinelog/group_24.263.824501371      536871424   24           -5  INUSE     NOLINK  ASM
+PP6_OLOG/pp6/onlinelog/group_24.263.824501369      536871424   24           -6  INUSE     NOLINK  ASM

BR0120I Control files

File                                                     Size   Id.      Device  Link    Type

+PP6_DATA/PP6/cntrlPP6.dbf                           20267008    0           -4  +PP6_DATA/PP6/CONTROLFILE/current.256.824485041  ASM
+PP6_ARCH/PP6/cntrlPP6.dbf                           20267008    0           -3  +PP6_ARCH/PP6/CONTROLFILE/current.256.824497927  ASM
+PP6_RECO/PP6/cntrlPP6.dbf                           20267008    0           -7  +PP6_RECO/PP6/CONTROLFILE/current.256.824497929  ASM

BR0280I BRBACKUP time stamp: 2013-09-12 22.58.12
BR0057I Backup of database: PP62
BR0058I BRBACKUP action ID: bembsjqx
BR0059I BRBACKUP function ID: fnr
BR0110I Backup mode: FULL
BR0077I Database file for backup: c:\oracle\PP6\sapbackup\CNTRLPP62.DBF
BR0061I 8 files found for backup, total size 25589.383 MB
BR0143I Backup type: online
BR0112I Files will not be compressed
BR0130I Backup device type: rman_util
BR0126I Unattended mode active - no operator confirmation required

BR0280I BRBACKUP time stamp: 2013-09-12 22.58.13
BR0504I Starting full database backup (level 0) using RMAN...

BR0280I BRBACKUP time stamp: 2013-09-12 22.58.20
BR0202I Saving +PP6_DATA/pp6/datafile/psapsr3db.258.824498071 ...

BR0280I BRBACKUP time stamp: 2013-09-12 22.58.20
BR0202I Saving +PP6_DATA/pp6/datafile/system.260.824498071 ...

BR0280I BRBACKUP time stamp: 2013-09-12 22.58.20
BR0202I Saving +PP6_DATA/pp6/datafile/psapsr3db.257.824498069 ...

BR0280I BRBACKUP time stamp: 2013-09-12 22.58.21
BR0202I Saving +PP6_DATA/pp6/datafile/psapundo.259.824498071 ...

BR0280I BRBACKUP time stamp: 2013-09-12 22.58.21
BR0202I Saving +PP6_DATA/pp6/datafile/psapundo2.265.824501573 ...

BR0280I BRBACKUP time stamp: 2013-09-12 22.58.21
BR0202I Saving +PP6_DATA/pp6/datafile/psapundo1.264.824501569 ...

BR0280I BRBACKUP time stamp: 2013-09-12 22.58.21
BR0202I Saving +PP6_DATA/pp6/datafile/sysaux.261.824498073 ...

BR0280I BRBACKUP time stamp: 2013-09-12 23.00.57
BR0521I Backup of database file save set piece - piece handle=PP62_bembsjqx.97_1 tag=BEMBSJQX comment=API Version 2.0,MMS Version 5.0.0.0

BR0280I BRBACKUP time stamp: 2013-09-12 23.01.17
BR0521I Backup of database file save set piece - piece handle=PP62_bembsjqx.96_1 tag=BEMBSJQX comment=API Version 2.0,MMS Version 5.0.0.0

BR0280I BRBACKUP time stamp: 2013-09-12 23.01.27
BR0521I Backup of database file save set piece - piece handle=PP62_bembsjqx.95_1 tag=BEMBSJQX comment=API Version 2.0,MMS Version 5.0.0.0

BR0280I BRBACKUP time stamp: 2013-09-12 23.05.37
BR0521I Backup of database file save set piece - piece handle=PP62_bembsjqx.94_1 tag=BEMBSJQX comment=API Version 2.0,MMS Version 5.0.0.0

BR0280I BRBACKUP time stamp: 2013-09-12 23.05.57
BR0521I Backup of database file save set piece - piece handle=PP62_bembsjqx.93_1 tag=BEMBSJQX comment=API Version 2.0,MMS Version 5.0.0.0

#FILE..... +PP6_DATA/pp6/datafile/psapsr3db.258.824498071
#SAVED.... bembsjqx  85/93

#FILE..... +PP6_DATA/pp6/datafile/psapsr3db.257.824498069
#SAVED.... bembsjqx  84/94

#FILE..... +PP6_DATA/pp6/datafile/psapundo.259.824498071
#SAVED.... bembsjqx  83/95

#FILE..... +PP6_DATA/pp6/datafile/psapundo1.264.824501569
#SAVED.... bembsjqx  82/96

#FILE..... +PP6_DATA/pp6/datafile/psapundo2.265.824501573
#SAVED.... bembsjqx  83/95

#FILE..... +PP6_DATA/pp6/datafile/sysaux.261.824498073
#SAVED.... bembsjqx  82/96

#FILE..... +PP6_DATA/pp6/datafile/system.260.824498071
#SAVED.... bembsjqx  85/93

BR0522I 7 of 7 files / save sets processed by RMAN

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.01
BR0505I Full database backup (level 0) using RMAN successful

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.04
BR0340I Switching to next online redolog file for database instance PP62 ...
BR0321I Switch to next online redolog file for database instance PP62 successful
BR0340I Switching to next online redolog file for database instance PP61 ...
BR0321I Switch to next online redolog file for database instance PP61 successful

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.06
BR0319I Control file copy created: c:\oracle\PP6\sapbackup\CNTRLPP62.DBF 20267008

BR0117I ARCHIVE LOG LIST after backup for database instance PP62

Parameter                      Value

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +PP6_ARCH/pp6/oraarch
Archive format                 %t_%s_%r.dbf
Oldest online log sequence     27
Next log sequence to archive   30
Current log sequence           30               SCN: 3944546
Database block size            8192             Thread: 2
Current system change number   3944556          ResetId: 824381037

BR0117I ARCHIVE LOG LIST after backup for database instance PP61

Parameter                      Value

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +PP6_ARCH/pp6/oraarch
Archive format                 %t_%s_%r.dbf
Oldest online log sequence     72
Next log sequence to archive   75
Current log sequence           75               SCN: 3944549
Database block size            8192             Thread: 1
Current system change number   3944555          ResetId: 824381037

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.07
BR0229I Calling backup utility with function 'backup'...
BR0278I Command output of '\\server2\sapmnt\PP6\SYS\exe\uc\NTAMD64\backint.exe -u &&&& -f backup -i c:\oracle\PP6\sapbackup\.bembsjqx.lst -t file -p C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl -c':
WARNING: sort_backup_type not specified in .utl file
WARNING: default sort_backup_type to <size> for backup
********************************************************************************
Program:  \\server2\sapmnt\PP6\SYS\exe\uc\NTAMD64\backint.exe 7.5
Input File:  c:\oracle\PP6\sapbackup\.bembsjqx.lst
Profile:  C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl
Function:  BACKUP
Backup Type:  BACKUP_FILE
********************************************************************************
[4294975184.01] 23:06:14 INF - Data buffer size = 65536
[4294975184.01] 23:06:18 INF - Using Media ID @@@081 for Backup ID sapdbsrv2_1379019967
[7888.8440] 23:06:19 INF - Backup of <c:\oracle\PP6\sapbackup\CNTRLPP62.DBF> is in progress.
[7888.8440] 23:06:24 INF - Backup of <c:\oracle\PP6\sapbackup\CNTRLPP62.DBF> is done.

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.24
#FILE..... c:\oracle\PP6\sapbackup\CNTRLPP62.DBF
#SAVED.... VXF1379019967
********************************************************************************

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.24
BR0232I 1 of 1 file saved by backup utility
BR0230I Backup utility called successfully

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.24
BR0229I Calling backup utility with function 'backup'...
BR0278I Command output of '\\server2\sapmnt\PP6\SYS\exe\uc\NTAMD64\backint.exe -u &&&& -f backup -i c:\oracle\PP6\sapbackup\.bembsjqx.lst -t file -p C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl -c':
WARNING: sort_backup_type not specified in .utl file
WARNING: default sort_backup_type to <size> for backup
********************************************************************************
Program:  \\server2\sapmnt\PP6\SYS\exe\uc\NTAMD64\backint.exe 7.5
Input File:  c:\oracle\PP6\sapbackup\.bembsjqx.lst
Profile:  C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl
Function:  BACKUP
Backup Type:  BACKUP_FILE
********************************************************************************
[4294976476.01] 23:06:30 INF - Data buffer size = 65536
[9180.7820] 23:06:35 INF - Backup of <C:\ORACLE\PP6\11203\database\initPP62.ora> is in progress.
[9180.7820] 23:06:36 INF - Backup of <C:\ORACLE\PP6\11203\database\initPP61.ora> is in progress.
[9180.7820] 23:06:37 INF - Backup of <C:\ORACLE\PP6\11203\database\initPP6.ora> is in progress.
[9180.7820] 23:06:38 INF - Backup of <C:\ORACLE\PP6\11203\database\initPP6.rman_weekly.SAP> is in progress.
[9180.7820] 23:06:39 INF - Backup of <C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl> is in progress.
[9180.7820] 23:06:40 INF - Backup of <C:\oracle\PP6\sapreorg\spacePP62.log> is in progress.
[9180.7820] 23:06:41 INF - Backup of <c:\oracle\PP6\sapbackup\bembsjqx.fnr> is in progress.
[4294976476.01] 23:06:42 INF - Using Media ID @@@081 for Backup ID sapdbsrv2_1379019983
[9180.7820] 23:06:42 INF - Backup of <c:\oracle\PP6\sapbackup\backPP62.log> is in progress.
[9180.7820] 23:06:48 INF - Backup of <C:\ORACLE\PP6\11203\database\initPP62.ora> is done.
[9180.7820] 23:06:48 INF - Backup of <C:\ORACLE\PP6\11203\database\initPP61.ora> is done.
[9180.7820] 23:06:48 INF - Backup of <C:\ORACLE\PP6\11203\database\initPP6.ora> is done.
[9180.7820] 23:06:48 INF - Backup of <C:\ORACLE\PP6\11203\database\initPP6.rman_weekly.SAP> is done.
[9180.7820] 23:06:48 INF - Backup of <C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl> is done.
[9180.7820] 23:06:48 INF - Backup of <C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl> is done.
[9180.7820] 23:06:48 INF - Backup of <C:\oracle\PP6\sapreorg\spacePP62.log> is done.
[9180.7820] 23:06:48 INF - Backup of <c:\oracle\PP6\sapbackup\bembsjqx.fnr> is done.
[9180.7820] 23:06:48 INF - Backup of <c:\oracle\PP6\sapbackup\backPP62.log> is done.

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.48
#PFLOG.... C:\ORACLE\PP6\11203\database\initPP62.ora
#SAVED.... VXF1379019983

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.48
#PFLOG.... C:\ORACLE\PP6\11203\database\initPP61.ora
#SAVED.... VXF1379019983

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.48
#PFLOG.... C:\ORACLE\PP6\11203\database\initPP6.ora
#SAVED.... VXF1379019983

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.48
#PFLOG.... C:\ORACLE\PP6\11203\database\initPP6.rman_weekly.SAP
#SAVED.... VXF1379019983

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.48
#PFLOG.... C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl
#SAVED.... VXF1379019983
BR0233E Backup utility has reported an error while saving file C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.48
#PFLOG.... C:\oracle\PP6\sapreorg\spacePP62.log
#SAVED.... VXF1379019983

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.48
#PFLOG.... c:\oracle\PP6\sapbackup\bembsjqx.fnr
#SAVED.... VXF1379019983

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.48
#PFLOG.... c:\oracle\PP6\sapbackup\backPP62.log
#SAVED.... VXF1379019983
BR0278E Command output of '\\server2\sapmnt\PP6\SYS\exe\uc\NTAMD64\backint.exe -u &&&& -f backup -i c:\oracle\PP6\sapbackup\.bembsjqx.lst -t file -p C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl -c':
[9180] Error detected while reporting backup ids.
********************************************************************************

BR0280I BRBACKUP time stamp: 2013-09-12 23.06.48
BR0279E Return code from '\\server2\sapmnt\PP6\SYS\exe\uc\NTAMD64\backint.exe -u &&&& -f backup -i c:\oracle\PP6\sapbackup\.bembsjqx.lst -t file -p C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl -c': 2

BR0232E 8 of 9 files saved by backup utility
BR0280I BRBACKUP time stamp: 2013-09-12 23.06.48
BR0231E Backup utility call failed

BR0056I End of database backup: bembsjqx.fnr 2013-09-12 23.06.48
BR0280I BRBACKUP time stamp: 2013-09-12 23.06.48
BR0054I BRBACKUP terminated with errors

1 Reply
Highlighted

BR0233E Backup utility has

BR0233E Backup utility has reported an error while saving file C:\ORACLE\PP6\11203\database\initPP6.rman.wee.utl

Typo?  Please confirm the utl name matches.  Maybe it is supposed to be initPP6.rman.weekly.utl ?