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