OCM考试大纲针对创建数据库的要求:
1、检查环境
2、设定SID
3、创建相关的目录
4、创建参数文件
5、创建password file
6、创建spfile
7、修改部分参数
8、创建database
CREATE DATABASE orcl
USER SYS IDENTIFIED BY change_on_install
USER SYSTEM IDENTIFIED BY manager
LOGFILE GROUP 1 ('/oracle/app/oracle/oradata/orcl/lfile/redo01.log’) SIZE 100M,
GROUP 2 ('/oracle/app/oracle/oradata/orcl/lfile/redo02.log') SIZE 100M,
GROUP 3 ('/oracle/app/oracle/oradata/orcl/lfile/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/oracle/app/oracle/oradata/orcl/datafile/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/oracle/app/oracle/oradata/orcl/datafile/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1 datafile '/oracle/app/oracle/oradata/orcl/datafile/tbs_1.dbf' size 50m
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/oracle/app/oracle/oradata/orcl/datafile/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/oracle/app/oracle/oradata/orcl/datafile/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
执行完成后,将datafile和 tempfile设置为自动扩展:
alter database datafile 1 autoextend on;
alter database datafile 2 autoextend on;
alter database datafile 3 autoextend on;
alter database datafile 4 autoextend on;
alter database tempfile 1 autoextend on;
9、执行catalog和catproc创建数据字典对象
sql>@?/rdbms/admin/catalog
sql>@?/rdbms/admin/catproc
10、开启归档功能
sql> shutdown immediate;
sql> startup mount
sql> alter database archivelog;
sql> alter database open;
11、备份数据库
每做一个重要操作,都要养成备份的习惯。通过rman做数据库全备:
rman> run {
}
至此,手工创建database完成。