error in creating table space

[Former Member]

BR0370I Directory /oracle/NW4/sapreorg/sdybsgtj created

BR0280I BRSPACE time stamp: 2008-06-05 10.12.05

BR0301E SQL error -1587 at location BrCtlCopy-1, SQL statement:

'/* BRSPACE */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/NW4/sapreorg/sdybsgtj/cntrlNW4.old''

ORA-01587: error during control file backup file copy

ORA-27091: unable to queue I/O

ORA-27072: File I/O error

Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 515

Additional information: -1

BR0320E Copying of control file to /oracle/NW4/sapreorg/sdybsgtj/cntrlNW4.old failed

BR0280I BRSPACE time stamp: 2008-06-05 10.12.05

BR0700E Fatal errors occurred - terminating processing...

BR1020I Number of tablespaces processed: 0

BR1004E BRSPACE function 'tscreate' failed

BR1008I End of BRSPACE processing: sdybsgtj.tsc 2008-06-05 10.12.05

BR0280I BRSPACE time stamp: 2008-06-05 10.12.05

BR1007I BRSPACE terminated with errors

[Former Member]

there was a problem with the hardware

[Former Member]

hi Markus

here is the output

ls -l /oracle/NW4/sapreorg

total 144

drwxrwxrwx 2 oranw4 dba 4096 Jun 6 15:03 sdybxvlw

-rwxrwxrwx 1 oranw4 dba 11040 Jun 6 13:16 sdybxvlw.tsc

-rw-rr 1 nw4adm sapsys 1159 Jun 6 13:19 sdybxvxg.tsc

-rw-rr 1 nw4adm sapsys 6087 Jun 6 13:22 sdybxvzs.dbr

-rw-rr 1 nw4adm sapsys 1124 Jun 6 13:22 sdybxwei.dba

-rw-rr 1 nw4adm sapsys 9104 Jun 6 13:24 sdybxwfo.dbs

-rw-rr 1 nw4adm sapsys 6954 Jun 6 14:17 sdybyayk.dbr

drwxr-xr-x 2 oranw4 dba 4096 Jun 6 14:21 sdybybec

-rw-rr 1 oranw4 dba 16325 Jun 6 14:21 sdybybec.tsc

drwxr-xr-x 2 oranw4 dba 4096 Jun 6 15:20 sdybyfyb

-rw-rr 1 oranw4 dba 13367 Jun 6 15:20 sdybyfyb.tsc

-rwxrwxrwx 1 oranw4 dba 728 Jun 6 15:20 spaceNW4.log

ls -l /usr/sap/NW4/SYS/exe/run/brbackup

-rwsrwxr-x 1 oranw4 dba 3655447 Aug 20 2006 /usr/sap/NW4/SYS/exe/run/brbackup

Thanks

boby rao

[markus_doehr2]

ok - looks good.

the only thing I can imagine what stays left is the filesystem. Do you use reiserfs or ext3?

Markus

[Former Member]

ext3

boby rao

[markus_doehr2]

And the parameter filesystemio_options is set to "setall"?

Markus

[Former Member]

ya it's "setall"

boby rao

[markus_doehr2]

I must admit I have no more idea.

Markus

[Former Member]

Hi again

I still have no doubt, the filesystem is full, under linux df is often misleading especially when there are a lot of small files.

BR0370I Directory /oracle/NW4/sapreorg/sdybsgtj created

Why is there no directory /oracle/NW4/sapreorg/sdybsgtj ?

Can you please try to create the control file in the sapreorg filesystem:

ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/NW4/sapreorg/cntrlNW4.old';

If this fails, try to copy a controlfile to sapreorg:

oranw4 % cp /oracle/NW4/sapdata1/cntrl/cntrlNW4.dbf /oracle/NW4/sapreorg/cntrlNW4.old

If all this does not help, please have a look at /var/log/messages for io errors or something like this.

Regards

Michael

[Former Member]

Hi Michal & Maheswaran,

thanks for your reply there is plenty space and i also tried removing all files from the sapreorg but I'm getting the same error.

i tried " alter database back controlfile to trace " at sql prompt it worked but when i tried with the target file name then it's throwing the same error.

[markus_doehr2]

> thanks for your reply there is plenty space and i also tried removing all files from the sapreorg but I'm getting the same error.

> i tried " alter database back controlfile to trace " at sql prompt it worked but when i tried with the target file name then it's throwing the same error.

ِAre the permissions correctly set for that directory? Has brbackup the s-uid-bit set? (means, did you execute ./saproot.sh <SID> in the kernel directory after updating the brtools)?

Markus

[Former Member]

Hi Markus,

thanks for the reply the permissions are correct and i haven't upgraded the brtools

thanks

regards

boby rao

[markus_doehr2]

please post the output of

ls -l /oracle/NW4/sapreorg

and

l s-l /usr/sap/NW4/SYS/exe/brbackup

Markus

[Former Member]

Hi,

Make sure that the location is available and the permission exists for that file system.

It is giving Io error while taking copy of the controlfile

regards,

Maheswaran J

[Former Member]

Hi Boby

In most cases this means the /oracle/NW4/sapreorg filesystem is full, either resize or delete old files there.

Regards

Michael