oracle静默创建库弊端,oracle

1) 生成响应文件模板:

$ vi $DISTRIB/db_create.rsp

#--------------------------------------------------------------------

#以下参数不要更改

[GENERAL]

RESPONSEFILE_VERSION = "11.2.0"

OPERATION_TYPE = "createDatabase"

#以下参数必须设置

[CREATEDATABASE]

GDBNAME = "ORCL.LK"

TEMPLATENAME = "General_Purpose.dbc"

#以下参数不设置则使用默认值,建议设置

CHARACTERSET = "ZHS16GBK"

TOTALMEMORY = "1024"

#--------------------------------------------------------------------

2) dbca静默建库, 大概3-4分钟:

种子数据库和控制文件位于$ORACLE_HOME/assistants/dbca/templates/下, 即Seed_Database.dfb和Seed_Database.ctl文件, 实际上建库就是基于通过rman恢复种子数据库和控制文件来实现的.

$ $ORACLE_HOME/bin/dbca -silent

-responseFile $DISTRIB/db_create.rsp

Enter SYS user password:

Enter SYSTEM user password:

Copying database files

...

37% complete

Creating and starting Oracle instance

...

62% complete