sqlplus SYS/change_on_install as SYSDBA
spool /oracle/app/oracle/product/9.2/assistants/dbca/logs/CreateDB.log
startup nomount pfile="/oracle/inittestdb.ora";
CREATE DATABASE testdb
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 4
MAXDATAFILES 1000
DATAFILE '/dev/rtestdbvg_2G_001' SIZE 2047m REUSE AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/dev/rtestdbvg_2G_002'
SIZE 2047M REUSE AUTOEXTEND OFF
UNDO TABLESPACE UNDOTBS DATAFILE '/dev/rtestdbvg_2G_003'
SIZE 2047M REUSE AUTOEXTEND OFF
CHARACTER SET zhs16cgb231280
LOGFILE
group 1 ('/dev/rtestdbvg_1G_001',
'/dev/rtestdbvg_1G_002') SIZE 1023m,
group 2 ('/dev/rtestdbvg_1G_003',
'/dev/rtestdbvg_1G_004') SIZE 1023m,
group 3 ('/dev/rtestdbvg_1G_005',
'/dev/rtestdbvg_1G_006') SIZE 1023m,
group 4 ('/dev/rtestdbvg_1G_007',
'/dev/rtestdbvg_1G_008') SIZE 1023m
spool off
exit; |
