Forum Discussion

Prithvi's avatar
Prithvi
Level 3
16 years ago
Solved

SAP online backup failing with error 6

Hi Experts

I'm trying  SAP online backup in netbackup 6.5.5 but it's failing , it;s running on AIX5.3 .....i'm pasting .anf logs below

early reply would be apprciated....
rgds
prithvi


#
# more becqwsua.anf
BR0051I BRBACKUP 7.00 (11)
BR0055I Start of database backup: becqwsua.anf 2010-02-25 16.27.12
BR0477I Oracle pfile /oracle/ID0/102_64/dbs/initID0.ora created from spfile /oracle/ID0/102_64/dbs/spfileID0.ora

BR0280I BRBACKUP time stamp: 2010-02-25 16.27.15
BR0319I Control file copy created: /oracle/ID0/sapbackup/cntrlID0.dbf 11255808

BR0101I Parameters

Name                           Value

oracle_sid                     ID0
oracle_home                    /oracle/ID0/102_64
oracle_profile                 /oracle/ID0/102_64/dbs/initID0.ora
sapdata_home                   /oracle/ID0
sap_profile                    /oracle/ID0/102_64/dbs/initID0.sap
backup_mode                    ALL
backup_type                    online
backup_dev_type                util_file_online
util_par_file                  /oracle/ID0/102_64/dbs/initID0.utl
system_info                    oraid0/oraid0 IDES AIX 3 5 00C2CB6E4C00
oracle_info                    ID0 10.2.0.4.0 8192 8973 104717514
sap_info                       700 SAPSR3 ID0 TEMPLICENSE R3_ORA INITIAL
make_info                      rs6000_64 OCI_101 Feb 28 2006
command_line                   brbackup -c -u / -d util_file_online -t online -m all

BR0116I ARCHIVE LOG LIST before backup for database instance ID0

Parameter                      Value

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /oracle/ID0/oraarch/ID0arch
Archive format                 %t_%s_%r.dbf
Oldest online log sequence     8970
Next log sequence to archive   8973
Current log sequence           8973       SCN: 104717514
Database block size            8192       Thread: 1

BR0118I Tablespaces and data files

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

PSAPSR3        ONLINE*    ONLINE+   /oracle/ID0/sapdata1/sr3_1/sr3.data1                 2097160192    4      655373  NOLINK  FILE 
 10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   /oracle/ID0/sapdata1/sr3_48/sr3.data48               2097160192   51      655373  NOLINK  FILE 
 10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   /oracle/ID0/sapdata1/sr3_3/sr3.data3                 2097160192    6      655373  NOLINK  FILE 
 10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   /oracle/ID0/sapdata1/sr3_4/sr3.data4                 2097160192    7      655373  NOLINK  FILE  
.
.
.

PSAPSR3USR     ONLINE*    ONLINE+   /oracle/ID0/sapdata1/sr3usr_1/sr3usr.data1             52436992   92      655373  NOLINK  FILE 
 10485760000     20971520     8192
PSAPTEMP       ONLINE#    ONLINE+   /oracle/ID0/sapdata1/temp_1/temp.data1               2715820032   -1      655373  NOLINK  FILE 
 10485760000     20971520     8192
PSAPUNDO       ONLINE-    ONLINE+   /oracle/ID0/sapdata1/undo_1/undo.data1               7675584512    2      655373  NOLINK  FILE 
 10485760000     20971520     8192
SYSAUX         ONLINE*    ONLINE+   /oracle/ID0/sapdata1/sysaux_1/sysaux.data1            293609472    3      655373  NOLINK  FILE 
 10485760000     20971520     8192
SYSTEM         ONLINE*    SYSTEM+   /oracle/ID0/sapdata1/system_1/system.data1            943726592    1      655373  NOLINK  FILE 
 10485760000     20971520     8192

BR0119I Redo log files

File                                                Size  Group     Device  Status    Link    Type

/oracle/ID0/origlogA/log_g11m1.dbf              52429312    1       655373  INUSE     NOLINK  FILE
/oracle/ID0/mirrlogA/log_g11m2.dbf              52429312    1       655373  INUSE     NOLINK  FILE
/oracle/ID0/origlogB/log_g12m1.dbf              52429312    2       655373  INUSE     NOLINK  FILE
/oracle/ID0/mirrlogB/log_g12m2.dbf              52429312    2       655373  INUSE     NOLINK  FILE
/oracle/ID0/origlogA/log_g13m1.dbf              52429312    3       655373  INUSE     NOLINK  FILE
/oracle/ID0/mirrlogA/log_g13m2.dbf              52429312    3       655373  INUSE     NOLINK  FILE
/oracle/ID0/origlogB/log_g14m1.dbf              52429312    4       655373  INUSE     NOLINK  FILE
/oracle/ID0/mirrlogB/log_g14m2.dbf              52429312    4       655373  INUSE     NOLINK  FILE

BR0120I Control files

File                                                Size   Id.      Device  Link    Type

/oracle/ID0/origlogA/cntrl/cntrlID0.dbf         11255808    0       655373  NOLINK  FILE
/oracle/ID0/origlogB/cntrl/cntrlID0.dbf         11255808    0       655373  NOLINK  FILE
/oracle/ID0/sapdata1/cntrl/cntrlID0.dbf         11255808    0       655373  NOLINK  FILE
BR0989W Unknown tablespace PSAPEL30BD defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPEL30BI defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPEL30CD defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPEL30CI defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPEL40AD defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPEL40AI defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPEL40BD defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPEL40BI defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPES30BD defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPES30BI defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPES30CD defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPES30CI defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPES40AD defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPES40AI defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPES40BD defined in table SAPSR3.TAORA/IAORA
BR0989W Unknown tablespace PSAPES40BI defined in table SAPSR3.TAORA/IAORA

BR0616I Tablespaces in tables TAORA and IAORA for owner SAPSR3:
PSAPSR3, PSAPSR3700, PSAPSR3FACT, PSAPSR3ODS, PSAPSR3USR

BR0280I BRBACKUP time stamp: 2010-02-25 16.27.16
BR0057I Backup of database: ID0
BR0058I BRBACKUP action ID: becqwsua
BR0059I BRBACKUP function ID: anf
BR0110I Backup mode: ALL
BR0077I Database file for backup: /oracle/ID0/sapbackup/cntrlID0.dbf
BR0061I 94 files found for backup, total size 184101.461 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: 2010-02-25 16.27.16
BR0229I Calling backup utility with function 'backup'...
BR0278I Command output of '/usr/sap/ID0/SYS/exe/run/backint -u ID0 -f backup -i /oracle/ID0/sapbackup/.becqwsua.lst -t file_online -
p /oracle/ID0/102_64/dbs/initID0.utl -c':
WARNING: drives value missing from parameter file /oracle/ID0/102_64/dbs/initID0.utl
default drives value = 1
WARNING: sort_backup_type not specified in .utl file
WARNING: default sort_backup_type to <size> for backup
********************************************************************************
Program:                /usr/sap/ID0/SYS/exe/run/backint 6.5
Input File:             /oracle/ID0/sapbackup/.becqwsua.lst
Profile:                /oracle/ID0/102_64/dbs/initID0.utl
Function:               BACKUP
Backup Type:            BACKUP_FILE_ONLINE
********************************************************************************
[864448.01] 16:27:43 INF - Processing /oracle/ID0/sapdata1/sr3_1/sr3.data1
16:27:43.856 [864448] <1> :  Requested to keep </oracle/ID0/sapdata1/sr3_1/sr3.data1> in backup mode/offline.
16:27:43.876 [864448] <1> :  Backup of </oracle/ID0/sapdata1/sr3_1/sr3.data1> is failed due to <Error 0 : Server Status:  the reques
ted operation was successfully completed>.
16:27:50.878 [864448] <1> :  Backup of </oracle/ID0/sapdata1/sr3_1/sr3.data1> is failed due to <Error 6 : Server Status:  the backup
 failed to back up the requested files>.
16:27:50.878 [864448] <1> :  Backup of </oracle/ID0/sapdata1/sr3_48/sr3.data48> is failed due to <Error 6 : Server Status:  the back
up failed to back up the requested files>.
.
.
.
.
16:27:50.882 [864448] <1> :  Backup of </oracle/ID0/sapdata4/sr3db_1/sr3db.data1> is failed due to <Error 6 : Server Status:  the ba
ckup failed to back up the requested files>.
16:27:50.882 [864448] <1> :  Backup of </oracle/ID0/sapdata1/sr3fact_1/sr3fact.data1> is failed due to <Error 6 : Server Status:  th
e backup failed to back up the requested files>.
16:27:50.882 [864448] <1> :  Backup of </oracle/ID0/sapdata1/sr3ods_1/sr3ods.data1> is failed due to <Error 6 : Server Status:  the
backup failed to back up the requested files>.
16:27:50.882 [864448] <1> :  Backup of </oracle/ID0/sapdata1/sr3usr_1/sr3usr.data1> is failed due to <Error 6 : Server Status:  the
backup failed to back up the requested files>.
16:27:50.882 [864448] <1> :  Backup of </oracle/ID0/sapdata1/undo_1/undo.data1> is failed due to <Error 6 : Server Status:  the back
up failed to back up the requested files>.
16:27:50.882 [864448] <1> :  Backup of </oracle/ID0/sapdata1/sysaux_1/sysaux.data1> is failed due to <Error 6 : Server Status:  the
backup failed to back up the requested files>.
16:27:50.883 [864448] <1> :  Backup of </oracle/ID0/sapdata1/system_1/system.data1> is failed due to <Error 6 : Server Status:  the
backup failed to back up the requested files>.
16:27:50.883 [864448] <1> :  Backup of </oracle/ID0/sapbackup/cntrlID0.dbf> is failed due to <Error 6 : Server Status:  the backup f
ailed to back up the requested files>.
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3_1/sr3.data1
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3_48/sr3.data48
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3_3/sr3.data3
.
.
.
.
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3700_7/sr3700.data7
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3700_8/sr3700.data8
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3700_9/sr3700.data9
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3700_10/sr3700.data10
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3700_11/sr3700.data11
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3700_12/sr3700.data12
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3700_13/sr3700.data13
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3700_14/sr3700.data14
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3700_15/sr3700.data15
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3700_16/sr3700.data16
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata4/sr3db_1/sr3db.data1
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3fact_1/sr3fact.data1
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3ods_1/sr3ods.data1
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sr3usr_1/sr3usr.data1
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/undo_1/undo.data1
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/sysaux_1/sysaux.data1
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapdata1/system_1/system.data1
BR0233E Backup utility has reported an error while saving file /oracle/ID0/sapbackup/cntrlID0.dbf
[864448] Error detected while reporting backup ids.
********************************************************************************
BR0280I BRBACKUP time stamp: 2010-02-25 16.27.52
BR0279E Return code from '/usr/sap/ID0/SYS/exe/run/backint -u ID0 -f backup -i /oracle/ID0/sapbackup/.becqwsua.lst -t file_online -p
 /oracle/ID0/102_64/dbs/initID0.utl -c': 2

BR0232E 0 of 94 files saved by backup utility
BR0280I BRBACKUP time stamp: 2010-02-25 16.27.52
BR0231E Backup utility call failed

BR0056I End of database backup: becqwsua.anf 2010-02-25 16.27.52
BR0280I BRBACKUP time stamp: 2010-02-25 16.27.54
BR0054I BRBACKUP terminated with errors
#         
#
 

  • Issue resolve by adding -u / parameter in brbackup command