IBM AIX RISC System/6000 Error: 22: Invalid argument

[user]

Hi Folks..

I'm getting the following message when trying to open my Oracle database
after copying from cooked to raw filesystems..

SQL> @create_raw_IBM_db.sql
ORACLE instance started.

Total System Global Area 202868072 bytes
Fixed Size 742760 bytes
Variable Size 167772160 bytes
Database Buffers 33554432 bytes
Redo Buffers 798720 bytes
CREATE CONTROLFILE REUSE DATABASE "IBM" NORESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/dev/rIBM_system01'
ORA-27047: unable to read the header block of file
IBM AIX RISC System/6000 Error: 22: Invalid argument
Additional information: 2

I can do an ls -al in my /dev directory, and see all the necessary files
there with the right permissions and ownerships..

root@host:32bit /apps/11i/pocdb/oradata/IBM> ls -la /dev/rIBM*
crw-rw---- 1 oracle dba 70, 8 Nov 01 00:14 /dev/rIBM_cntrl01
crw-rw---- 1 oracle dba 70, 9 Nov 01 00:14 /dev/rIBM_cntrl02
crw-rw---- 1 oracle dba 70, 10 Nov 01 00:14 /dev/rIBM_cntrl03
crw-rw---- 1 oracle dba 70, 2 Nov 01 00:14 /dev/rIBM_indx01
crw-rw---- 1 oracle dba 70, 5 Nov 01 00:32 /dev/rIBM_redo01
crw-rw---- 1 oracle dba 70, 6 Nov 01 00:35 /dev/rIBM_redo02
crw-rw---- 1 oracle dba 70, 7 Nov 01 00:43 /dev/rIBM_redo03
crw-rw---- 1 oracle dba 70, 1 Nov 01 00:52 /dev/rIBM_system01
crw-rw---- 1 oracle dba 70, 3 Nov 01 00:15 /dev/rIBM_temp01
crw-rw---- 1 oracle dba 70, 11 Nov 01 00:16 /dev/rIBM_tools01
crw-rw---- 1 oracle dba 70, 4 Nov 01 00:21 /dev/rIBM_undo01

Is there something that could have possibly gone wrong in the dd ?

I used the following command to dd the files from cooked to raw..

dd if=/apps/11i/pocdb/oradata/IBM/system01.dbf of=/dev/rIBM_system01
skip=1 bs=4k

and so on for the other files..

Thanks for all your suggestions..

[Nathan]

> ORA-01565: error in identifying file '/dev/rIBM_system01'
> ORA-27047: unable to read the header block of file
> IBM AIX RISC System/6000 Error: 22: Invalid argument

Looks like to me you verified that using dd to import database volumes
into a 'raw filesystem' doesn't work. Oracle is telling you the file
header is corrupted or otherwise unrecognizeable to it.

I think you really need to ask some Oracle folks about this, what you
are doing doesn't sound very kosher. Oracle manages it's own raw
filesystems differently, I'd guess there's some bytes at the top of the
device that it uses to do it's house keeping. In my mind, just copying
raw data to the device is no garantee Oracle will recognize it as a raw
filesystem. I would imagine that you will have to fire up Oracle and
import the data from within it to properly initialize the raw devices.

But who knows, that's why I work with AIX instead of being a DBA. Good luck.

[Alain Deschamps]

On Tue, 01 Nov 2005 01:13:32 -0500, user <us...@gm.com> wrote:

>Is there something that could have possibly gone wrong in the dd ?
>
>I used the following command to dd the files from cooked to raw..
>
>dd if=/apps/11i/pocdb/oradata/IBM/system01.dbf of=/dev/rIBM_system01
>skip=1 bs=4k
>

I am not familiar using raw files with Oracle, but a quick search
seems to indicate that you wrongly used skip instead of seek :

http://www.cs.umb.edu/cs634/ora9idocs/server.920/a96572/osbackups.htm#12458

According to this doc - which is for Oracle 9 but it should not make
any differences - you must skip on the input when copying from a raw
device to a file, or seek on the output when copying from a file to a
raw device.
--
echo papxc.s...@ugtt.ug | tr "p-za-o" "a-z"