ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 手工建库

手工建库

原创 Linux操作系统 作者:whuisszjy 时间:2013-07-29 22:37:17 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2013-01-26

  • 博文量
    9
  • 访问量
    7800