4ManageADatabase.org
Table of Contents
学习目标
- list the prerequisites necessary for database creation.
- create a database using Oracle Database Configuration Assistant (DBCA)
- create a daatabase manually
- create a database using Oracle Managered Files (OMF)
Planing for your database is the first step of managing a database
Define the purpose of your database (规划)
- oltp 联机事务处理 (大量并发，短小事务)
- olap 数据仓库 (少量并发，大事务)
defind the type of your database ,同上一条
outline a database architectural design (如何存储，几块硬盘等)
Create your database
图使用开界面的工具创建数据库，DBCA ,运行dbca 命令即可。
User Oracle Data Migration Assistant to migrate from an earlier version database
(数据迁移)
oracle 推荐的arch (OFA : Optimal Flexible Arch)
- Establish a directory structure where any database file can be stored
on any disk resource - separate objects with different behavior into different tablespace
- Maximuse database reliablity and performance by separating database
components across disk resource .(比如将online redo log与 data file放到
不同磁盘上)