手动创建数据库（使用CREATE DATABASE语句）

Normal 0 7.8 pt 0 2 false false false EN-US ZH-CN X-NONE 实验目的：学会用 CREATE DATABASE 语句手动创建数据库

实验结果：创建一个数据库，该数据库至少包含2个Control files，3个Log groups，5个Tablespaces (SYSTEM, SYSAUX, Default, Default temporary, Undo)

实验参考：Chapter 2 of “Administrator's Guide”

范例：

1, 确定实例名和数据库名，并编辑init$ORACLE_SID.ora

1) 确定ORACLE_SID, 创建一目录用于存放数据库文件。

         $ export ORACLE_SID=mydb

         $ cd /oracle/db11g/oradata/

         $ mkdir mydb

         2) 创建并编辑initmydb.ora文件（文件目录为$ORACLE_HOME/dbs）

                   $ cd $ORACLE_HOME/dbs

                   $ vi initmydb.ora

                            db_name=mydb

                            instance_name=mydb

                            control_files='/oracle/db11g/oradata/mydb/control01.ctl',

'/oracle/db11g/oradata/mydb/control02.ctl'

2, 创建并启动实例

         $ sqlplus / as sysdba

         SQL> startup nomount

3. 创建数据库

1) 手动创建数据库（注：SYSAUS至少为240M）

SQL> create database mydb

        logfile group 1 ('/oracle/db11g/oradata/mydb/redo01.log') size 100m,

                group 2 ('/oracle/db11g/oradata/mydb/redo02.log') size 100m,

                group 3 ('/oracle/db11g/oradata/mydb/redo03.log') size 100m

        maxlogfiles 6

        maxlogmembers 5

        maxdatafiles 100

        maxloghistory 1

        maxinstances 3

        character set us7ascii

        national character set al16utf16

    datafile '/oracle/db11g/oradata/mydb/system01.dbf' size 150m reuse autoextend on maxsize unlimited

        extent management local

    sysaux datafile '/oracle/db11g/oradata/mydb/sysaux01.dbf' size 250m reuse autoextend on maxsize unlimited

        default tablespace tbs_1

    datafile '/oracle/db11g/oradata/mydb/perm01.dbf' size 20m reuse autoextend on maxsize unlimited

        default temporary tablespace tempts1

    tempfile '/oracle/db11g/oradata/mydb/temp01.dbf' size 20m reuse autoextend on maxsize unlimited

        undo tablespace undotbs

                datafile '/oracle/db11g/oradata/mydb/undotbs01.dbf'

                        size 100m reuse autoextend on maxsize unlimited;

         2) 添加两个表空间

SQL> CREATE TABLESPACE users LOGGING

DATAFILE '/oracle/db11g/oradata/mydb/users01.dbf'

SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED

EXTENT MANAGEMENT LOCAL;

SQL> CREATE TABLESPACE indx LOGGING

DATAFILE '/oracle/db11g/oradata/mydb/indx01.dbf'

SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED

EXTENT MANAGEMENT LOCAL;

4. 运行脚本

         SQL> conn as sysdba

         SQL> @/oracle/db11g/11.2/rdbms/admin/catalog.sql

         SQL> @/oracle/db11g/11.2/rdbms/admin/catproc.sql

Normal 0 7.8 pt 0 2 false false false EN-US ZH-CN X-NONE

5. 验证

         SQL> show parameter db_name;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_name                              string      mydb

参考资料：Chapter 3 of "Administrator's Guide"

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24068527/viewspace-666466/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24068527/viewspace-666466/