裸设备建库疑问

jasure

p570 AIX 5.3-04 Oracle 9.2.0.6

rootvg PP 大小为256M

创建LV大小为1024M
mklv -y'lv10' -t'raw' rootvg 1
mklv -y'lv11' -t'raw' rootvg 1
mklv -y'lv12' -t'raw' rootvg 4
mklv -y'lv13' -t'raw' rootvg 2
mklv -y'lv14' -t'raw' rootvg 4
mklv -y'lv16' -t'raw' rootvg 2
mklv -y'lv17' -t'raw' rootvg 4
mklv -y'lv18' -t'raw' rootvg 2
mklv -y'lv19' -t'raw' rootvg 2
mklv -y'lv20' -t'raw' rootvg 2
mklv -y'lv21' -t'raw' rootvg 2


建立link
cd /home/db/oracle/oradata/ora9i/
ln -s /dev/rlv10 ./control01.ctl
ln -s /dev/rlv11 ./control02.ctl
ln -s /dev/rlv12 ./users01.dbf
ln -s /dev/rlv13 ./indx01.dbf
ln -s /dev/rlv14 ./undotbs01.dbf
ln -s /dev/rlv16 ./system01.dbf
ln -s /dev/rlv17 ./temp01.dbf
ln -s /dev/rlv18 ./tools01.dbf
ln -s /dev/rlv19 ./redo_1_1.log
ln -s /dev/rlv20 ./redo_2_1.log
ln -s /dev/rlv21 ./redo_3_1.log

创建实例部分脚本如下：
CREATE DATABASE ora9i
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 10
MAXLOGMEMBERS 3
MAXDATAFILES 200
DATAFILE '/home/db/oracle/oradata/ora9i/system01.dbf' SIZE 512M REUSE AUTOEXTEND ON NEXT  1024K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/home/db/oracle/oradata/ora9i/temp01.dbf' SIZE 1024M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS" DATAFILE '/home/db/oracle/oradata/ora9i/undotbs01.dbf' SIZE 1024M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/home/db/oracle/oradata/ora9i/redo_1_1.log') SIZE 512M,
GROUP 2 ('/home/db/oracle/oradata/ora9i/redo_2_1.log') SIZE 512M,
GROUP 3 ('/home/db/oracle/oradata/ora9i/redo_3_1.log') SIZE 512M;

但是报错LV空间不足，不知为何？具体ORA错误号没有记下来。

请诸位大虾指教！

补充：建立link的路径

[ 本帖最后由 jasure 于 2006-8-4 22:10 编辑 ]

imtj

DATAFILE '/home/db/oracle/oradata/ora9i/system01.dbf' SIZE 512M REUSE AUTOEXTEND ON NEXT  1024K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/home/db/oracle/oradata/ora9i/temp01.dbf' SIZE 1024M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS" DATAFILE '/home/db/oracle/oradata/ora9i/undotbs01.dbf' SIZE 1024M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED
你这是在裸设备上面建库吗？明显不是。。。。
你要选择你的裸设备

lijun1227

double check the size of raw devices, at least I found the size of some tablespaces is larger than the size of raw devices.

jasure

当我把建库脚本改为如下之后，建库就成了。郁闷ing

CREATE DATABASE ora9i
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 10
MAXLOGMEMBERS 3
MAXDATAFILES 200
DATAFILE '/home/db/oracle/oradata/ora9i/system01.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT  1024K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/home/db/oracle/oradata/ora9i/temp01.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS" DATAFILE '/home/db/oracle/oradata/ora9i/undotbs01.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/home/db/oracle/oradata/ora9i/redo_1_1.log') SIZE 500M,
GROUP 2 ('/home/db/oracle/oradata/ora9i/redo_2_1.log') SIZE 500M,
GROUP 3 ('/home/db/oracle/oradata/ora9i/redo_3_1.log') SIZE 500M;

[ 本帖最后由 jasure 于 2006-8-4 22:11 编辑 ]

numenhuang

这是因为oracle需要在raw device header写入额外的信息，所以一般要留下一点空间

原帖由 jasure 于 2006-8-4 22:09 发表
当我把建库脚本改为如下之后，建库就成了。郁闷ing

CREATE DATABASE ora9i
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 10
MAXLOGMEMBERS 3
MAXDATAFILES 200
DATAFILE '/home/db/oracle/oradata/ora9i ...

bitao

楼上的正解

jasure

多谢指点，我大概猜到了。
就是没有得到确认，可否详细说一下。

jinxueping

1个pp256M，在用裸设备的时候，不能将空间全部占满，应为裸设备是不用操作系统管理的，所以需要一定的空间写自己的信息，预留1-2m就可以了。

jinxueping

所以如果占满就会报空间不足了。

jasure

多谢jinxueping 指点。