ORACLE controlfile format:
startup nomount下执行
CREATE CONTROLFILE REUSE DATABASE "DB_NAME" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 500
MAXINSTANCES 8
MAXLOGHISTORY 4674
LOGFILE
GROUP 1 (
'/cwncredolog1/redo01_01.log',
'/cwncredolog2/redo01_02.log'
) SIZE 200M,
GROUP 2 (
'/cwncredolog1/redo02_01.log',
'/cwncredolog2/redo02_02.log'
) SIZE 200M,
GROUP 3 (
'/cwncredolog1/redo03_01.log',
'/cwncredolog2/redo03_02.log'
) SIZE 200M
-- STANDBY LOGFILE
DATAFILE
'/cwncoradata/system01.dbf',
'/cwncoradata/undotbs01.dbf',
'/cwncoradata/sysaux01.dbf',
'/cwncoradata/users01.dbf',
'/cwncdata/IUFO.dbf',
'/cwncdata/NNC_DATA01.dbf',
'/cwncdata/NNC_DATA02.dbf',
'/cwncdata/NNC_DATA03.dbf',
'/cwncdata/NNC_INDEX01.dbf',
'/cwncdata/NNC_INDEX02.dbf',
'/cwncdata/NNC_INDEX03.dbf',
'/cwncdata/SWCWTS.dbf'
CHARACTER SET ZHS16GBK
阅读(1283) | 评论(0) | 转发(0) |
