oracle 10g 手动建库 笔记

ts7758258

　　从磁盘上可以看到是oracle 自动创建的控制文件，再alter 到mount状态，之后创建redo文件，system，在system表空间上创建rollback segment，undo，最后是sysaux，temp
　　创建好了，只有很少的视图或者表比如v$database v$instance v$log v$logfile v$session
　　像dba_   all_   基本表，v$tablespace 等都没有的，需要运行脚本创建
　　另外使用以下语句创建成功，但是运行catproc.sql的时候会报错，因为system表空间给200M 太小了，似乎它默认不自动扩展的~~~,重新创建了一个system 400M sysaux 325M的就可以
　　create database PROD
　　user sys identified by *user system identified by *logfile group 1 ('/opt/app/oradata/redolog01.rdo','/opt/app/oradata/redolog04.rdo') size 100m,
　　group 2 ('/opt/app/oradata/redolog02.rdo','/opt/app/oradata/redolog05.rdo') size 100m,
　　group 3 ('/opt/app/oradata/redolog03.rdo','/opt/app/oradata/redolog06.rdo') size 100m
　　maxlogfiles 30
　　maxlogmembers 3
　　maxloghistory 4
　　maxdatafiles 100
　　maxinstances 1
　　character set zhs16gbk
　　national character set al16utf16
　　datafile '/opt/app/oradata/system01.dbf' size 200M extent management local
　　sysaux datafile '/opt/app/oradata/sysaux01.dbf' size 200M
　　default temporary tablespace temp
　　tempfile '/opt/app/oradata/temp01.dbf' size 100M
　　undo tablespace undotbs
　　datafile '/opt/app/oradata/undutbs01.dbf' size 100M autoextend on maxsize unlimited
　　Wed Dec 25 19:19:36 2013
　　Database mounted in Exclusive Mode
　　Wed Dec 25 19:20:24 2013
　　Successful mount of redo thread 1, with mount id 247011272
　　Assigning activation ID 247011272 (0xeb917c8)
　　Thread 1 opened at log sequence 1
　　Current log# 1 seq# 1 mem# 0: /opt/app/oradata/redolog01.rdo
　　Current log# 1 seq# 1 mem# 1: /opt/app/oradata/redolog04.rdo
　　Successful open of redo thread 1
　　Wed Dec 25 19:20:25 2013
　　MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
　　Wed Dec 25 19:20:25 2013
　　SMON: enabling cache recovery
　　Wed Dec 25 19:20:25 2013
　　create tablespace SYSTEM datafile  '/opt/app/oradata/system01.dbf' size 200M
　　EXTENT MANAGEMENT LOCAL online
　　Wed Dec 25 19:20:39 2013
　　Completed: create tablespace SYSTEM datafile  '/opt/app/oradata/system01.dbf' size 200M
　　EXTENT MANAGEMENT LOCAL online
　　Wed Dec 25 19:20:39 2013
　　create rollback segment SYSTEM tablespace SYSTEM
　　storage (initial 50K next 50K)
　　Completed: create rollback segment SYSTEM tablespace SYSTEM
　　storage (initial 50K next 50K)
　　Wed Dec 25 19:20:44 2013
　　CREATE UNDO TABLESPACE UNDOTBS DATAFILE  '/opt/app/oradata/undutbs01.dbf' size 100M autoextend on maxsize unlimited
　　Wed Dec 25 19:20:49 2013
　　Successfully onlined Undo Tablespace 1.
　　Completed: CREATE UNDO TABLESPACE UNDOTBS DATAFILE  '/opt/app/oradata/undutbs01.dbf' size 100M autoextend on maxsize unlimited
　　Wed Dec 25 19:20:49 2013
　　create tablespace SYSAUX datafile  '/opt/app/oradata/sysaux01.dbf' size 200M
　　EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
　　Wed Dec 25 19:21:00 2013
　　Completed: create tablespace SYSAUX datafile  '/opt/app/oradata/sysaux01.dbf' size 200M
　　EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
　　Wed Dec 25 19:21:01 2013
　　CREATE TEMPORARY TABLESPACE TEMP TEMPFILE  '/opt/app/oradata/temp01.dbf' size 100M
　　Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE  '/opt/app/oradata/temp01.dbf' size 100M
　　Wed Dec 25 19:21:01 2013
　　ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
　　Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
　　Wed Dec 25 19:21:01 2013
　　ALTER DATABASE DEFAULT TABLESPACE SYSTEM
　　Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM
　　Wed Dec 25 19:21:04 2013
　　SMON: enabling tx recovery
　　Wed Dec 25 19:21:04 2013
　　Threshold validation cannot be done before catproc is loaded.
　　replication_dependency_tracking turned off (no async multimaster replication found)
　　Starting background process QMNC
　　QMNC started with pid=13, OS id=3811
　　Wed Dec 25 19:21:06 2013
　　Completed: create database PROD
　　user sys identified by *user system identified by *logfile group 1 ('/opt/app/oradata/redolog01.rdo','/opt/app/oradata/redolog04.rdo') size 100m,
　　group 2 ('/opt/app/oradata/redolog02.rdo','/opt/app/oradata/redolog05.rdo') size 100m,
　　group 3 ('/opt/app/oradata/redolog03.rdo','/opt/app/oradata/redolog06.rdo') size 100m
　　maxlogfiles 30
　　maxlogmembers 3
　　maxloghistory 4
　　maxdatafiles 100
　　maxinstances 1
　　character set zhs16gbk
　　national character set al16utf16
　　datafile '/opt/app/oradata/system01.dbf' size 200M extent management local
　　sysaux datafile '/opt/app/oradata/sysaux01.dbf' size 200M
　　default temporary tablespace temp
　　tempfile '/opt/app/oradata/temp01.dbf' size 100M
　　undo tablespace undotbs
　　datafile '/opt/app/oradata/undutbs01.dbf' size 100M autoextend on maxsize unlimited