手工建库

db_name=prod

control_files=(/u01/oradata/controlfiles/controlfile1.ctl,/u01/oradata/controlfiles/controlfile2.ctl)

sga_target=400M

undo_management=auto

undo_tablespace=undotbs

rm -rf controlfiles/* disk1/* disk2/* disk3/* disk4/* disk5/* dump/bdump/* dump/cdump/* dump/udump/* system01.dbf undotbs01.dbf

CREATE DATABASE prod

   USER SYS IDENTIFIED BY oracle

   USER SYSTEM IDENTIFIED BY oracle

   LOGFILE GROUP 1 ('/u01/oradata/disk1/redo01a.log','/u01/oradata/disk2/redo01b.log') SIZE 20M,

GROUP 2 ('/u01/oradata/disk2/redo02a.log','/u01/oradata/disk3/redo02b.log') SIZE 20M,

GROUP 3 ('/u01/oradata/disk3/redo03a.log','/u01/oradata/disk4/redo03b.log') SIZE 20M,

GROUP 4 ('/u01/oradata/disk4/redo04a.log','/u01/oradata/disk5/redo04b.log') SIZE 20M,

GROUP 5 ('/u01/oradata/disk5/redo05a.log','/u01/oradata/disk1/redo05b.log') SIZE 20M

   MAXLOGFILES 5

   MAXLOGMEMBERS 5

   MAXLOGHISTORY 1

   MAXDATAFILES 100

   MAXINSTANCES 1

   CHARACTER SET AL32UTF8

   NATIONAL CHARACTER SET AL16UTF16

   DATAFILE '/u01/oradata/system01.dbf' SIZE 200M REUSE

   EXTENT MANAGEMENT LOCAL

   SYSAUX DATAFILE '/u01/oradata/sysaux01.dbf' SIZE 200M REUSE

   DEFAULT TEMPORARY TABLESPACE tempts1

      TEMPFILE '/u01/oradata/temp01.dbf' 

      SIZE 20M REUSE

   UNDO TABLESPACE undotbs 

      DATAFILE '/u01/oradata/undotbs01.dbf'

      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

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

转载于:http://blog.itpub.net/15874751/viewspace-767410/