oracle创建控制文件
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'G:\app\Administrator\oradata\orcl\REDO01.LOG' SIZE 50M BLOCKSIZE 512,
GROUP 2 'G:\app\Administrator\oradata\orcl\REDO02.LOG' SIZE 50M BLOCKSIZE 512,
GROUP 3 'G:\app\Administrator\oradata\orcl\REDO03.LOG' SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'G:\app\Administrator\oradata\orcl\SYSTEM01.DBF',
'G:\app\Administrator\oradata\orcl\SYSAUX01.DBF',
'G:\app\Administrator\oradata\orcl\UNDOTBS01.DBF',
'G:\app\Administrator\oradata\orcl\USERS01.DBF',
'G:\app\Administrator\oradata\orcl\BHDATA.DBF',
'G:\app\Administrator\oradata\orcl\BHMAIL.DBF',
'G:\app\Administrator\oradata\orcl\BHINDEX.DBF',
'G:\app\Administrator\oradata\orcl\ZHBASIS.DBF',
'G:\app\Administrator\oradata\orcl\ZHARCHIVES.DBF',
'G:\app\Administrator\oradata\orcl\ZHSERVICES.DBF',
'G:\app\Administrator\oradata\orcl\ZHADVICES.DBF',
'G:\app\Administrator\oradata\orcl\ZHEXPENSES.DBF',
'G:\app\Administrator\oradata\orcl\ZHMEDICINE.DBF',
'G:\app\Administrator\oradata\orcl\ZHLAB.DBF',
'G:\app\Administrator\oradata\orcl\ZHCHECK.DBF',
'G:\app\Administrator\oradata\orcl\ZHLOB.DBF',
'G:\app\Administrator\oradata\orcl\ZHINDEX.DBF',
'G:\app\Administrator\oradata\orcl\SLREPORT.DBF',
'G:\app\Administrator\oradata\orcl\ZHMEDREC.DBF',
'G:\app\Administrator\oradata\orcl\ZHINSURE.DBF'
CHARACTER SET ZHS16GBK
;