使用OMF创建数据库

从Oracle9i起，Oracle提出了OMF的概念，主要是简化了日常的管理操作，下面的实验演示了使用OMF时创建数据库的过程：
1.先删除刚刚建立的abc数据库
1.1启动数据库到mount
SQL>startup mount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1247924 bytes
Variable Size 134219084 bytes
Database Buffers 25165824 bytes
Redo Buffers 7139328 bytes
Database mounted.
1.2将数据库设置为restricted session模式
SQL>alter system enable restricted session;
System altered.
1.3使用drop database命令删除数据库，这个操作将删除所有的数据文件（不包括参数和密码文件）
SQL>drop database;
Database dropped.
2.修改pfile文件F:/oracle/product/10.2.0/database/initabc.ora，添加下列内容：
db_create_file_dest='F:/oracle/product/oradata/'
db_create_online_log_dest_1='F:/oracle/product/oradata/'
3.连入数据库，并启动数据库到nomount
SQL>startup nomount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1247924 bytes
Variable Size 104858956 bytes
Database Buffers 54525952 bytes
Redo Buffers 7139328 bytes
4.根据刚刚修改的pfile文件创建spfile文件
SQL>create spfile from pfile;
File created.
5.执行creata database脚本
SQL>@F:/oracle/product/admin/abc/create/createdb.sql
Database created.
#createdb.sql脚本的具体内容如下（可以看出内容很简洁，所有的数据文件的具体信息都不用指定）：
create database abc
user sys identified by oracle
user system identified by oracle
def***t temporary tablespace temp
undo tablespace undotbs1
character set utf8
national character set al16utf16;
6.查看数据库的各个文件的位置和名称
6.1在线日志文件
SQL>select group#,member from v$logfile;
GROUP# MEMBER
---------- ----------------------------------------------------------------------
1 F:/ORACLE/PRODUCT/ORADATA/ABC/ONLINELOG/O1_MF_1_40PN2T5C_.LOG
2 F:/ORACLE/PRODUCT/ORADATA/ABC/ONLINELOG/O1_MF_2_40PN312X_.LOG
6.2数据文件
SQL>select tablespace_name,file_name from dba_data_files;
TABLESPACE FILE_NAME
---------- -------------------------------------------------------------------------------
SYSTEM F:/ORACLE/PRODUCT/ORADATA/ABC/DATAFILE/O1_MF_SYSTEM_40PN388S_.DBF
UNDOTBS1 F:/ORACLE/PRODUCT/ORADATA/ABC/DATAFILE/O1_MF_UNDOTBS1_40PN3OLK_.DBF
SYSAUX F:/ORACLE/PRODUCT/ORADATA/ABC/DATAFILE/O1_MF_SYSAUX_40PN3Q00_.DBF
6.3临时文件
SQL>select tablespace_name,file_name from dba_temp_files;
TABLESPACE FILE_NAME
---------- ---------------------------------------------------------------------
TEMP F:/ORACLE/PRODUCT/ORADATA/ABC/DATAFILE/O1_MF_TEMP_40PN3YJ3_.TMP
到此数据库abc创建完毕，可以正常使用了

三、附录：
create database的全部语法:
CREATE DATABASE database
USER SYS IDENTIFIED BY password
USER SYSTEM IDENTIFIED BY password
CONTROLFILE REUSE
MAXDATAFILES integer
MAXINSTANCES integer
MAXLOGFILES integer
MAXLOGMEMBERS integer
MAXLOGHISTORY integer
CHARACTER SET charset
NATIONAL CHARACTER SET charset
SET DEF***T BIGFILE(SMALLFILE) TABLESPACE
LOGFILE GROUP integer file_specification
ARCHIVELOG(NOARCHIVELOG)
FORCE LOGGING
DATAFILE file_specification
SYSAUX DATAFILE file_specification
DEF***T TABLESPACE tablespace DATAFILE datafile_tempfile_spec extent_management_clause
BIGFILE(SMALLFILE) DEF***T TEMPORARY TABLESPACE tablespace TEMPFILE file_specification extent_management_clause
BIGFILE(SMALLFILE) UNDO TABLESPACE tablespace DATAFILE file_specification
SET TIME_ZONE = '+/–hh : mi'(time_zone_region)