oracle手工建库10g，11g，12c

最新推荐文章于 2024-11-07 10:33:16 发布

s小竹

最新推荐文章于 2024-11-07 10:33:16 发布

阅读量1.1k

点赞数

分类专栏：数据库软件文章标签： oracle 建库 10g 11g 12c

本文链接：https://blog.csdn.net/j2spark/article/details/13006005

版权

数据库同时被 2 个专栏收录

10 篇文章 0 订阅

订阅专栏

软件

7 篇文章 0 订阅

订阅专栏

10g版本
CREATE DATABASE PROD
   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD/disk1/redo01.log',
                    '/u01/app/oracle/oradata/PROD/disk2/redo01.log') SIZE 100M,
           GROUP 2 ('/u01/app/oracle/oradata/PROD/disk1/redo02.log',
                    '/u01/app/oracle/oradata/PROD/disk2/redo02.log') SIZE 100M,
           GROUP 3 ('/u01/app/oracle/oradata/PROD/disk1/redo03.log',
                    '/u01/app/oracle/oradata/PROD/disk2/redo03.log') SIZE 100M
   CHARACTER SET zhs16gbk
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE '/u01/app/oracle/oradata/PROD/disk3/system01.dbf' SIZE 325M REUSE
   EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE '/u01/app/oracle/oradata/PROD/disk4/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TEMPORARY TABLESPACE temptbs
      TEMPFILE '/u01/app/oracle/oradata/PROD/disk5/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs
      DATAFILE '/u01/app/oracle/oradata/PROD/disk4/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

11g版本
CREATE DATABASE PROD
   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD/disk1/redo01.log',
                    '/u01/app/oracle/oradata/PROD/disk2/redo01.log') SIZE 100M BLOCKSIZE 512,
           GROUP 2 ('/u01/app/oracle/oradata/PROD/disk1/redo02.log',
                    '/u01/app/oracle/oradata/PROD/disk2/redo02.log') SIZE 100M BLOCKSIZE 512,
           GROUP 3 ('/u01/app/oracle/oradata/PROD/disk1/redo03.log',
                    '/u01/app/oracle/oradata/PROD/disk2/redo03.log') SIZE 100M BLOCKSIZE 512
   CHARACTER SET zhs16gbk
   NATIONAL CHARACTER SET AL16UTF16
   EXTENT MANAGEMENT LOCAL
   DATAFILE '/u01/app/oracle/oradata/PROD/disk3/system01.dbf' SIZE 325M REUSE
   SYSAUX DATAFILE '/u01/app/oracle/oradata/PROD/disk4/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TABLESPACE users
      DATAFILE '/u01/app/oracle/oradata/PROD/disk3/users01.dbf'
      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE tempts
      TEMPFILE '/u01/app/oracle/oradata/PROD/disk4/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs
      DATAFILE '/u01/app/oracle/oradata/PROD/disk5/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

12c版本
CREATE DATABASE PROD
   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD/disk1/redo01.log',
                    '/u01/app/oracle/oradata/PROD/disk2/redo01.log') SIZE 100M BLOCKSIZE 512,
           GROUP 2 ('/u01/app/oracle/oradata/PROD/disk1/redo02.log',
                    '/u01/app/oracle/oradata/PROD/disk2/redo02.log') SIZE 100M BLOCKSIZE 512,
           GROUP 3 ('/u01/app/oracle/oradata/PROD/disk1/redo03.log',
                    '/u01/app/oracle/oradata/PROD/disk2/redo03.log') SIZE 100M BLOCKSIZE 512
   CHARACTER SET zhs16gbk
   NATIONAL CHARACTER SET AL16UTF16
   EXTENT MANAGEMENT LOCAL
   DATAFILE '/u01/app/oracle/oradata/PROD/disk3/system01.dbf'
     SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
   SYSAUX DATAFILE '/u01/app/oracle/oradata/PROD/disk4/sysaux01.dbf'
     SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
   DEFAULT TABLESPACE users
      DATAFILE '/u01/app/oracle/oradata/PROD/disk4/diskusers01.dbf'
      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE tempts
      TEMPFILE '/u01/app/oracle/oradata/PROD/disk5/temp01.dbf'
      SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
   UNDO TABLESPACE undotbs
      DATAFILE '/u01/app/oracle/oradata/PROD/disk5/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
   USER_DATA TABLESPACE usertbs
      DATAFILE '/u01/app/oracle/oradata/PROD/disk4/usertbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;