Details:
Oracle can use RAW files for data files, control files and redo logs. Normally, the SQL 'REUSE" clause is ignored if the associated file is a RAW file. From Oracle 10g onwards, when Oracle Disk Manager (ODM) is enabled, the "REUSE" clause of SQL is mandatory. If ODM is not enabled, the "REUSE" clause is ignored for both Oracle9i and Oracle 10g. Here are some examples of failures and how to fix them. In the following examples, ODM is enabled for Oracle and the version of the database is 10g and above.

Using RAW Veritas Volume Manager (tm) volumes as control files
Assume that init.ora specifies the control file name

Database creation:
SQL> CREATE DATABASE "racg"
MAXINSTANCES 32
MAXLOGHISTORY 0
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
DATAFILE '/dev/vx/rdsk/oradg/system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/dev/vx/rdsk/oradg/temp01.dbf' SIZE 40M REUSE
AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/dev/vx/rdsk/oradg/undotbs1.dbf' SIZE 200M REUSE AUTO
EXTEND ON NEXT  5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/dev/vx/rdsk/oradg/redo01_1.log') SIZE 102400K REUSE,
GROUP 2 ('/dev/vx/rdsk/oradg/redo01_2.log') SIZE 102400K REUSE;

CREATE DATABASE "racg"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/dev/vx/rdsk/oradg/control01.ctl'
ORA-17502: ksfdcre:/dev/vx/rdsk/oradg/control01.ctl Failed to create file

To fix this error, use the following SQL:

SQL> CREATE DATABASE "racg"
CONTROLFILE REUSE
MAXINSTANCES 32
MAXLOGHISTORY 0
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
DATAFILE '/dev/vx/rdsk/oradg/system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL<><>
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/dev/vx/rdsk/oradg/temp01.dbf' SIZE 40M REUSE
AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/dev/vx/rdsk/oradg/undotbs1.dbf' SIZE 200M REUSE AUTO
EXTEND ON NEXT  5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/dev/vx/rdsk/oradg/redo01_1.log') SIZE 102400K REUSE,
GROUP 2 ('/dev/vx/rdsk/oradg/redo01_2.log') SIZE 102400K REUSE;

Database created

Control file creation:
SQL> CREATE CONTROLFILE SET DATABASE "MYDB"  RESETLOGS ARCHIVELOG;
                       *
ERROR at line 1:ORA-01503: CREATE CONTROLFILE failed
ORA-00200: controlfile could not be created
ORA-17505: ksfdrsz:1 Failed to resize file to size 150 blocks

To fix this error, use the following SQL:

SQL> CREATE CONTROLFILE REUSE SET DATABASE "MYDB"  RESETLOGS ARCHIVELOG;

Control file created

Using RAW volumes as datafiles
Assume that RAW volume /dev/vx/rdsk/oradg/emp_vol1 will be used to create table space tbs_emp

SQL> CREATE TABLESPACE tbs_emp DATAFILE '/dev/vx/rdsk/oradg/emp_vol1' size 512M;
           *
ERROR at line 1:
ORA-01119: error in creating database file '/dev/vx/rdsk/oradg/emp_vol1'
ORA-17505: ksfdrsz:1 Failed to resize file to size 65536 blocks

To fix this error, use the following SQL:

SQL> CREATE TABLESPACE tbs_emp DATAFILE '/dev/vx/rdsk/oradg/emp_vol1' size 512M REUSE;

Using RAW volumes as redo log files
Assume that RAW volume /dev/vx/rdsk/oradg/redo02_1.log will be used to create redo log

SQL> ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 3 '/dev/vx/rdsk/oradg/redo02_1.log' SIZE 102400K

           *
ERROR at line 1:
ORA-00301: error in adding log file '/dev/vx/rdsk/oradg/redo02_1.log' - file cannot be created
ORA-17502: ksfdcre:/dev/vx/rdsk/oradg/redo02_1.log Failed to create file

To fix this error, use the following SQL:

SQL> ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 3 '/dev/vx/rdsk/oradg/redo02_1.log' SIZE 102400K REUSE;

Database altered

Related Documents:

275787: Latest additions to the Release Notes for the Veritas Storage Foundation 4.1 to 4.1 MP2 for HP-UX 11i v2 product line and cross references to product documentation
 http://support.veritas.com/docs/275787

---