backint failed "ERROR: unable to find file "

[Former Member]

Hello

I try to backup Oracle database 10.2 with netbackup tools on Redhat 2.6.18-53

I got errror:

BR0231E Backup utility call failed

ERROR: unable to find file /oracle/BWP/sapdata4

Can u help me

Regards

Fethi

[Former Member]

can you paste the complete log file?

[Former Member]

This is the backup logfile:

BR0477I Oracle pfile /oracle/BWP/102_64/dbs/initBWP.ora created from spfile /oracle/BWP/102_64/dbs/spfileBWP.ora

BR0101I Parameters

Name Value

oracle_sid BWP

oracle_home /oracle/BWP/102_64

oracle_profile /oracle/BWP/102_64/dbs/initBWP.ora

sapdata_home /oracle/BWP

sap_profile /oracle/BWP/102_64/dbs/initBWP_sapdata_offline.sap

backup_mode ALL

backup_type offline

backup_dev_type util_file

util_par_file /oracle/BWP/102_64/dbs/initBWP_sapdata_offline.utl

system_info orabwp/orabwp hpbwpdb2 Linux 2.6.18-53.1.19.el5 #1 SMP Tue Apr 22 03:01:10 EDT 2008 x86_64

oracle_info BWP 10.2.0.2.0 8192 30 88160883 hpbwpdb2 WE8DEC UTF8

sap_info 700 SAPSR3 BWP S1329078236 R3_ORA 0020159289

make_info linuxx86_64 OCI_102 Feb 8 2008

command_line brbackup -c force -p initBWP_sapdata_offline.sap

BR0116I ARCHIVE LOG LIST before backup for database instance BWP

Parameter Value

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination /oracle/BWP/oraarch/BWParch

Archive format %t_%s_%r.dbf

Oldest online log sequence 27

Next log sequence to archive 30

Current log sequence 30 SCN: 88160883

Database block size 8192 Thread: 1

Current system change number 88168768 ResetId: 655409152

BR0118I Tablespaces and data files

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

PSAPBWP ONLINE* ONLINE+ /oracle/BWP/sapdata4/BWM.data1 17498636288 4 64785 NOLINK FILE 34359721984 104857600 8192

PSAPBWP ONLINE* ONLINE+ /oracle/BWP/sapdata4/BWM.data2 16450060288 5 64785 NOLINK FILE 34359721984 104857600 8192

PSAPBWP ONLINE* ONLINE+ /oracle/BWP/sapdata4/BWM.data3 15820914688 6 64785 NOLINK FILE 34359721984 104857600 8192

PSAPBWP700 ONLINE* ONLINE+ /oracle/BWP/sapdata2/BWM700.data1 15128862720 11 64784 NOLINK FILE 34359721984 104857600 8192

PSAPBWP700 ONLINE* ONLINE+ /oracle/BWP/sapdata4/BWM700.data2 4132511744 12 64785 NOLINK FILE 34359721984 8192 8192

PSAPBWPDIM ONLINE* ONLINE+ /oracle/BWP/sapdata1/BWMdim.data1 4202700800 7 64770 NOLINK FILE 10485760000 20971520 8192

PSAPBWPFACT ONLINE* ONLINE+ /oracle/BWP/sapdata1/BWMfact.data1 6719283200 8 64770 NOLINK FILE 34359721984 20971520 8192

PSAPBWPODS ONLINE* ONLINE+ /oracle/BWP/sapdata2/BWMods.data1 19868426240 9 64784 NOLINK FILE 34359721984 20971520 8192

PSAPBWPUSR ONLINE* ONLINE+ /oracle/BWP/sapdata1/BWMusr.data1 239083520 10 64770 NOLINK FILE 10485760000 20971520 8192

PSAPSR3USR ONLINE+ ONLINE+ /oracle/BWP/sapdata4/sr3usr_1/sr3usr.data1 134225920 20 64785 NOLINK FILE 10485760000 20971520 8192

PSAPTEMP ONLINE# ONLINE+ /oracle/BWP/sapdata1/temp_1/temp.data1 10485768192 -1 64770 NOLINK FILE 34358689792 20971520 8192

PSAPUNDO ONLINE- ONLINE+ /oracle/BWP/sapdata1/undo_1/undo.data1 1073750016 2 64770 NOLINK FILE 34359721984 20971520 8192

SYSAUX ONLINE* ONLINE+ /oracle/BWP/sapdata1/sysaux_1/sysaux.data1 671096832 3 64770 NOLINK FILE 10485760000 20971520 8192

SYSTEM ONLINE* SYSTEM+ /oracle/BWP/sapdata1/system_1/system.data1 838868992 1 64770 NOLINK FILE 10485760000 20971520 8192

BR0119I Redo log files

File Size Group Device Status Link Type

/oracle/BWP/origlogA/log_g11m1.dbf 52429312 1 64774 INUSE NOLINK FILE

/oracle/BWP/mirrlogA/log_g11m2.dbf 52429312 1 64776 INUSE NOLINK FILE

/oracle/BWP/origlogB/log_g12m1.dbf 52429312 2 64775 INUSE NOLINK FILE

/oracle/BWP/mirrlogB/log_g12m2.dbf 52429312 2 64777 INUSE NOLINK FILE

/oracle/BWP/origlogA/log_g13m1.dbf 52429312 3 64774 INUSE NOLINK FILE

/oracle/BWP/mirrlogA/log_g13m2.dbf 52429312 3 64776 INUSE NOLINK FILE

/oracle/BWP/origlogB/log_g14m1.dbf 52429312 4 64775 INUSE NOLINK FILE

/oracle/BWP/mirrlogB/log_g14m2.dbf 52429312 4 64777 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

/oracle/BWP/origlogA/cntrl/cntlrBWP.dbf 34979840 0 64774 NOLINK FILE

/oracle/BWP/origlogB/cntrl/cntrlBWP.dbf 34979840 0 64775 NOLINK FILE

/oracle/BWP/sapdata1/cntrl/cntrlBWP.dbf 34979840 0 64770 NOLINK FILE

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:

PSAPBWP, PSAPBWP700, PSAPBWPDIM, PSAPBWPFACT, PSAPBWPODS,

PSAPBWPUSR

BR0280I BRBACKUP time stamp: 2008-05-23 15.59.26

BR0057I Backup of database: BWP

BR0058I BRBACKUP action ID: bdxzgdlt

BR0059I BRBACKUP function ID: aff

BR0110I Backup mode: ALL

BR0077I Database files for backup:

/oracle/BWP/origlogA/log_g11m1.dbf

/oracle/BWP/origlogB/log_g12m1.dbf

/oracle/BWP/origlogA/log_g13m1.dbf

/oracle/BWP/origlogB/log_g14m1.dbf

/oracle/BWP/origlogA/cntrl/cntlrBWP.dbf

BR0061I 19 files found for backup, total size 108250.510 MB

BR0143I Backup type: offline

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0280I BRBACKUP time stamp: 2008-05-23 15.59.26

BR0307I Shutting down database instance BWP ...

BR0280I BRBACKUP time stamp: 2008-05-23 15.59.33

BR0308I Shutdown of database instance BWP successful

BR0280I BRBACKUP time stamp: 2008-05-23 15.59.33

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

BR0278I Command output of '/usr/sap/BWP/SYS/exe/run/backint -u BWP -f backup -i /oracle/BWP/sapbackup/.bdxzgdlt.lst -t file -p /oracle/BWP/102_64/dbs/initBWP_sapdata_offline.utl -c':

WARNING: unknown parameter: print_log_flag 1

WARNING: sort_backup_type not specified in .utl file

WARNING: default sort_backup_type to <size> for restore

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

Program: /usr/sap/BWP/SYS/exe/run/backint 5.1

Input File: /oracle/BWP/sapbackup/.bdxzgdlt.lst

Profile: /oracle/BWP/102_64/dbs/initBWP_sapdata_offline.utl

Function: BACKUP

Backup Type: BACKUP_FILE

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

ERROR: unable to find file /oracle/BWP/sapdata4/BWM.data1

ERROR: unable to find file /oracle/BWP/sapdata4/BWM.data2

ERROR: unable to find file /oracle/BWP/sapdata4/BWM.data3

ERROR: unable to find file /oracle/BWP/sapdata2/BWM700.data1

ERROR: unable to find file /oracle/BWP/sapdata4/BWM700.data2

ERROR: unable to find file /oracle/BWP/sapdata1/BWMdim.data1

ERROR: unable to find file /oracle/BWP/sapdata1/BWMfact.data1

ERROR: unable to find file /oracle/BWP/sapdata2/BWMods.data1

ERROR: unable to find file /oracle/BWP/sapdata1/temp_1/temp.data1

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

BR0280I BRBACKUP time stamp: 2008-05-23 15.59.33

BR0279E Return code from '/usr/sap/BWP/SYS/exe/run/backint -u BWP -f backup -i /oracle/BWP/sapbackup/.bdxzgdlt.lst -t file -p /oracle/BWP/102_64/dbs/initBWP_sapdata_offline.utl -c': 2

BR0232E 0 of 19 files saved by backup utility

BR0280I BRBACKUP time stamp: 2008-05-23 15.59.33

BR0231E Backup utility call failed

BR0280I BRBACKUP time stamp: 2008-05-23 15.59.35

BR0304I Starting and opening database instance BWP ...

BR0280I BRBACKUP time stamp: 2008-05-23 15.59.42

BR0305I Start and open of database instance BWP successful

BR0056I End of database backup: bdxzgdlt.aff 2008-05-23 15.59.33

Thank you

Regards

[Former Member]

I have this same issue now that I have upgraded my backup client to Netbackup 7.5.

Is there a solution????

Scott

[Former Member]

HAIT,

Looks like you need some more information to get the real issue, if you goto the brtools at the command line, what is the whole list of errors that come out when you attempt to do a backup? Potentially you have setup the backup config file incorrectly but the message you got is a bit obscure and missing some pieces it would seem to be able to find the real problem.

[Former Member]

Hello David,

Backup works fine before Os migration from Solaris 2.8 to ReadHat 2.6.

DB version , SAP and Netbackup is the same as the the versions before upgrade.

We checked the Netbackup Version and the compatibility with Linux ReadHat 2.6 with Vendor. Nothing to do the patche is correct.

Regards

Fethi