【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,创建控制文件.sql,希望对大家有所帮助!
CREATE CONTROLFILE
SET DATABASE db_name
LOGFILE GROUP 1 ('c:\oracle\product\10.2.0\oradata\ db_name \redo01_01.log',
' c:\oracle\product\10.2.0\oradata\ db_name\redo01_02.log'),
GROUP 2 (' c:\oracle\product\10.2.0\oradata\ db_name\redo02_01.log',
' c:\oracle\product\10.2.0\oradata\ db_name\redo02_02.log'),
GROUP 3 (' c:\oracle\product\10.2.0\oradata\ db_name\redo03_01.log',
' c:\oracle\product\10.2.0\oradata\ db_name\redo03_02.log')
RESETLOGS
DATAFILE ' c:\oracle\product\10.2.0\oradata\ db_name\system01.dbf' SIZE 3M,
' c:\oracle\product\10.2.0\oradata\ db_name\rbs01.dbs' SIZE 5M,
' c:\oracle\product\10.2.0\oradata\ db_name\users01.dbs' SIZE 5M,
' c:\oracle\product\10.2.0\oradata\ db_name\temp01.dbs' SIZE 5M
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXLOGHISTORY 400
MAXDATAFILES 200
MAXINSTANCES 6
ARCHIVELOG;