??????????RHEL6.4 + Oracle 11.2.0.4
????????????????catdb
????1.1 ??????????????
CREATE DATABASE mynewdb
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
LOGFILE GROUP 1 ('/u01/logs/my/redo01a.log'??'/u02/logs/my/redo01b.log') SIZE 100M BLOCKSIZE 512??
GROUP 2 ('/u01/logs/my/redo02a.log'??'/u02/logs/my/redo02b.log') SIZE 100M BLOCKSIZE 512??
GROUP 3 ('/u01/logs/my/redo03a.log'??'/u02/logs/my/redo03b.log') SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/mynewdb/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/mynewdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/app/oracle/oradata/mynewdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
????1.2 ?????????????????????
????sys_password -> oracle
????system_password -> oracle
????US7ASCII -> ZHS16GBK
????mynewdb -> catdb
????/u01/logs/my -> /u01/redologs/a
????/u02/logs/my -> /u01/redologs/b
????/u01/app/oracle/oradata -> /u01/oradata03
????????vi?????滻??????:%s#/u01/logs/my#/u01/redologs/a#g?滻????/u01/logs/my?/u01/redologs/a??
?????????????:
vi /home/oracle/create_db.sql
CREATE DATABASE catdb
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/u01/redologs/a/redo01a.log'??'/u01/redologs/b/redo01b.log') SIZE 100M BLOCKSIZE 512??
GROUP 2 ('/u01/redologs/a/redo02a.log'??'/u01/redologs/b/redo02b.log') SIZE 100M BLOCKSIZE 512??
GROUP 3 ('/u01/redologs/a/redo03a.log'??'/u01/redologs/b/redo03b.log') SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/oradata03/catdb/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/oradata03/catdb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/oradata03/catdb/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/oradata03/catdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/oradata03/catdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;