BR0252E Function fopen() failed for '/oracle/SSM/sapdata2/sr3_1/sr3.data1'

[Former Member]

Hi ,

I've installed a new system on AIX 5.3 , SAP NW2004S ( SSM 4.0 ) with Oracle 10.2.0.2 and TDP Oracle / TSM 5.3. The tivoli backup / archive client, api and backint tool works fine. When I want to make an SAP backup using brbackup -t online -m full -c the following message appears:

orassm> brbackup -t online -m full -c

BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: bduytsgx.fnf 2007-04-04 14.09.23

BR0477I Oracle pfile /oracle/SSM/102_64/dbs/initSSM.ora created from spfile /oracle/SSM/102_64/dbs/spfileSSM.ora

BR0280I BRBACKUP time stamp: 2007-04-04 14.09.26

BR0057I Backup of database: SSM

BR0058I BRBACKUP action ID: bduytsgx

BR0059I BRBACKUP function ID: fnf

BR0110I Backup mode: FULL

BR0077I Database file for backup: /oracle/SSM/sapbackup/cntrlSSM.dbf

BR0061I 10 files found for backup, total size 32789.023 MB

BR0143I Backup type: online

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRBACKUP time stamp: 2007-04-04 14.09.28

BR0315I 'Alter database begin backup' successful

BR0252E Function fopen() failed for '/oracle/SSM/sapdata2/sr3_1/sr3.data1' at location BrSparseCreate-1

BR0253E errno 22: Invalid argument

BR0280I BRBACKUP time stamp: 2007-04-04 14.09.29

BR0317I 'Alter database end backup' successful

BR0056I End of database backup: bduytsgx.fnf 2007-04-04 14.09.28

BR0280I BRBACKUP time stamp: 2007-04-04 14.09.30

BR0054I BRBACKUP terminated with errors

What does the errno 22: mean ? And how can I fix this.

Thanks in advance for your help.

regards,

thomas kuehn

[andreas_herzog]

hi,

-> tsm works successfully? did you test?

-> utility file is edited accordingly?

GreetZ, AH

[Former Member]

Hi,

when I call backint -f backup -p ... following happens:

orassm> backint -f backup -p /oracle/SSM/102_64/dbs/initSSM.utl

Data Protection for mySAP.com(R) technology

Interface between SAPDBA Utilities and Tivoli Storage Manager

- Version 3, Release 3, Modification 11 for AIX LF 64-bit -

Build: 226 compiled on Mar 17 2004

(c) Copyright IBM Corporation, 1996, 2004, All Rights Reserved.

Please enter the file names for 'backup' :

]

(Press ENTER after each record / line. Press CTRL-D to finish the list.)

/oracle/SSM/sapdata2/sr3_1/sr3.data1

BKI2027I: Using TSM-API version 5.3.4.0 (compiled with 5.1.0.0).

BKI2000I: Successfully connected to ProLE on port tdpr3ora64.

BKI0005I: Start of program at: Wed Apr 4 14:46:01 CEST 2007 .

-- Parameters --

Input File : /tmp/aaah4ImUa

Profile : /oracle/SSM/102_64/dbs/initSSM.utl

Configfile : /oracle/SSM/102_64/dbs/initSSM.bki

Manual sorting file : disabled

Tracefile : disabled

Traceflags : disabled

Parallel sessions : 1

Multiplexed files : 1

RL compression : 0

Exit on error : disabled

BATCH : enabled

Buffer size : 131072

Redologcopies : disabled

Versioning : disabled

Backup Type : unknown

SNMPTRAP : disabled

TSM log server : disabled

TSM server : SSM with 2 sessions configured, using 1 session

TSM client node :

Days for backup : Sun Mon Tue Wed Thu Fri Sat

Backup mgmt class : M.BACK

Archiv mgmt class : M.ARCH.1 M.ARCH.2

BKI2017I: Blocksize is set to 131072 bytes

BKI0027I: Time: 04/04/07 14:46:04 Object: 1 of 1 in process: /oracle/SSM/sapdata2/sr3_1/sr3.data1 Size: 8.887 GB, MGMNT-CLASS: M.BACK, TSM-Server: SSM .

BKI4008E: File '/oracle/SSM/sapdata2/sr3_1/sr3.data1' cannot be opened. Reason: errno(22) A system call received a parameter that is not valid.

BKI1208W: The object '/oracle/SSM/sapdata2/sr3_1/sr3.data1' will be retried .

BKI0027I: Time: 04/04/07 14:46:10 Object: 1 of 1 in process: /oracle/SSM/sapdata2/sr3_1/sr3.data1 Size: 8.887 GB, MGMNT-CLASS: M.BACK, TSM-Server: SSM .

BKI4008E: File '/oracle/SSM/sapdata2/sr3_1/sr3.data1' cannot be opened. Reason: errno(22) A system call received a parameter that is not valid.

BKI1208W: The object '/oracle/SSM/sapdata2/sr3_1/sr3.data1' will be retried .

BKI0027I: Time: 04/04/07 14:46:10 Object: 1 of 1 in process: /oracle/SSM/sapdata2/sr3_1/sr3.data1 Size: 8.887 GB, MGMNT-CLASS: M.BACK, TSM-Server: SSM .

BKI4008E: File '/oracle/SSM/sapdata2/sr3_1/sr3.data1' cannot be opened. Reason: errno(22) A system call received a parameter that is not valid.

BKI1208W: The object '/oracle/SSM/sapdata2/sr3_1/sr3.data1' will be retried .

BKI0027I: Time: 04/04/07 14:46:11 Object: 1 of 1 in process: /oracle/SSM/sapdata2/sr3_1/sr3.data1 Size: 8.887 GB, MGMNT-CLASS: M.BACK, TSM-Server: SSM .

BKI4008E: File '/oracle/SSM/sapdata2/sr3_1/sr3.data1' cannot be opened. Reason: errno(22) A system call received a parameter that is not valid.

BKI1200E: Cannot read/write file: /oracle/SSM/sapdata2/sr3_1/sr3.data1.

#ERROR /oracle/SSM/sapdata2/sr3_1/sr3.data1

BKI1215I: Average transmission rate was 0.000 GB/h (0.000 MB/sec).

BKI1227I: Average compression factor was 1.00.

BKI0020I: End of program at: Wed Apr 4 14:46:12 CEST 2007 .

BKI0021I: Elapsed time: 11 sec .

BKI0024I: Return code is: 2.

-

-

---

DSMC inc ...

orassm> dsmc inc /oracle/SSM/sapdata2/sr3_1/sr3.data1

IBM Tivoli Storage Manager

Command Line Backup/Archive Client Interface

Client Version 5, Release 3, Level 4.0

Client date/time: 04/04/07 14:49:15

(c) Copyright by IBM Corporation and other(s) 1990, 2006. All Rights Reserved.

Node Name: SSM

Session established with server TSMSERVER: AIX-RS/6000

Server Version 5, Release 3, Level 4.1

Server date/time: 04/04/07 14:49:14 Last access: 04/04/07 14:49:05

Incremental backup of volume '/oracle/SSM/sapdata2/sr3_1/sr3.data1'

Normal File--> 9,542,049,792 /oracle/SSM/sapdata2/sr3_1/sr3.data1 ** Unsuccessful **

ANS1228E Sending of object '/oracle/SSM/sapdata2/sr3_1/sr3.data1' failed

ANS4007E Error processing '/oracle/SSM/sapdata2/sr3_1/sr3.data1': access to the object is denied

ANS1802E Incremental backup of '/oracle/SSM/sapdata2/sr3_1/sr3.data1' finished with 1 failure

-

-

---

File permissions are :

orassm> ls -la /oracle/SSM/sapdata2/sr3_1/sr3.data1

-rwxrwxr-x 1 orassm dba 9542049792 Apr 04 14:49 /oracle/SSM/sapdata2/sr3_1/sr3.data1

Why doesn't it working ?

P.S. : dsmc inc is still working for all files and filesystems except the /oracle/SID/sapdata's with subdirs.

regards,

thomas k.

Message was edited by:

Thomas Kühn

[Former Member]

Hello all,

I've found a SAP Note # 948294

( https://service.sap.com/sap/support/notes/948294 )

which describe this problem.

Online backup of oracle database not working with JFS2 and Oracle 10g

External tools fail with various errors when accessing a file:

cp: A system call received a parameter that is not valid.

0653-902 Cannot open the specified file for reading.

DBV-00100: Specified FILE not accessible

errno(22) A system call received a parameter that is not valid.

Mount the oracle filesystems on jfs2 with -o cio .

t.k.

[Former Member]

Thomas,

Where are you triggering this backup? I know the permissions are correct for orassm, but if you are running this from say DB13, the effective user is ssmadm, which may not have permissions to open the file. Same goes with the TSM - what is the effective user who triggers the job here? Is your TSM server configured to run this job as orassm?

Is ssmadm part of the dba group? If you logon as orassm and run the backup from the BRTOOL set, do you get the same error?

Just a few questions to help you resolve. Please let me know how you do with this - I have similar issues with an AIX/Oracle 9.2 environment.

Thanks!

Tim