create database "MYDB"
-- user SYS identified by change_on_install
-- user SYSTEM identified by manager
logfile
group 1 ( '/test/redolog/redo01a.redo','/test/redolog/reduo01b.redo','/test/redo01c.redo') size 50M blocksize 512,
group 2 ( '/test/redolog/redo02a.redo','/test/redolog/reduo02b.redo','/test/redo02c.redo') size 50M blocksize 512,
group 3 ( '/test/redolog/redo03a.redo','/test/redolog/reduo03b.redo','/test/redo03c.redo') size 50M blocksize 512,
-- MAXLOGFILES 5
-- MAXLOGMEMBERS 10
-- maxloghistory 100
-- maxdatafiles 100
-- character set UTF-8
-- national character set ZHS16GBK
extent management local
datafile '/test/oradata/MYDB/system01.dbf' size 625M reuse
SYSAUX datafile '/test/oradata/MYDB/sysaux01.dbf' size 625M reuse
default tablespace users
datafile '/test/oradata/MYDB/user01.dbf' size 100M reuse
default temporary tablespace temp
tempfile '/test/oradata/MYDB/temp01.dbf' size 50M reuse
undo tablespace undo
datafile '/test/oradata/MYDB/undo01.dbf' size 50M reuse
tablespace test
datafile '/test/oradata/MYDB/test.dbf' size 20M resue autoextend on
set time_zone='+8:00'
---------
-- character set UTF-8 注释掉
是因为:ORA-02236: invalid file name 数据库软件是 11.2.0版本
弱弱问一下 上面有哪些语法错误?
我的控制文件重建语句:
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\REDO01.LOG' SIZE 50M BLOCKSIZE 512,
GROUP 2 'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\REDO02.LOG' SIZE 50M BLOCKSIZE 512,
GROUP 3 'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\REDO03.LOG' SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILEDATAFILE
'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\SYSTEM01.DBF',
'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\SYSAUX01.DBF',
'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\UNDOTBS01.DBF',
'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\USERS01.DBF',
'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\EXAMPLE01.DBF'
CHARACTER SET AL32UTF8
;你建库 应该跟这个格式也差不多。。
在建库脚本中: 33* undo tablespace 'UNDOTBS1' datafile '/test/oradata/TEST/undotbs.dbf'
ERROR at line 33:
ORA-02216: tablespace name expected
group 3 ( '/test/redolog/redo03a.redo','/test/redolog/reduo03b.redo','/test/redo03c.redo') size 50M blocksize 512,
这个语句后面多个逗号。