oracle 创建control文件

vim /data/oracle/dbhome/dbs/initdb.ora

control_files=(/data/oracle/oradata/db/control01.ctl, /data/oracle/flash_recovery_area/db/control02.ctl)

sqlplus /nolog

conn / as sysdba

shutdown immediate

startup nomount

datafile如果没有，生成空白数据文件？（没找到），从其他地方拷过来

create controlfile reuse database \’db\’ noresetlogs noarchivelog

maxlogfiles 16
maxlogmembers 3
maxdatafiles 100
maxinstances 8
maxloghistory 292

logfile

group 1 \’/data/oracle/oradata/db/redo01.log\’ size 50M,
group 2 \’/data/oracle/oradata/db/redo02.log\’ size 50M,
group 3 \’/data/oracle/oradata/db/redo03.log\’ size 50M

datafile

\’/data/oracle/oradata/db/system01.dbf\’,
\’/data/oracle/oradata/db/undotbs01.dbf\’,
\’/data/oracle/oradata/db/sysaux01.dbf\’,
\’/data/oracle/oradata/db/users01.dbf\’

character set AL32UTF8;