1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
|
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "ICEFLD" RESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 113
LOGFILE
GROUP 1 'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\REDO\REDO01.LOG' SIZE 100M,
GROUP 2 'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\REDO\REDO02.LOG' SIZE 100M,
GROUP 3 'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\REDO\REDO03.LOG' SIZE 100M
-- STANDBY LOGFILE
DATAFILE
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\SYSTEM01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\UNDOTBS01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\DRSYS01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\EXAMPLE01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_09_PARAM01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\ODM01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\TOOLS01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_09_DATA01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\XDB01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_09_INDEX01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_04_BLOB01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_09_BLOB01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_06_PARAM01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_06_DATA01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_06_INDEX01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_06_BLOB01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_06_CDC01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_08_PARAM01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_08_DATA01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_08_INDEX01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_08_BLOB01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\HERMESPARAM01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\HERMESDATA01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\HERMESBLOB01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\HERMESINDEX01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_3_1_02_PARAM01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_3_1_02_DATA01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_3_1_02_INDEX01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_3_1_02_BLOB01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_08_CDC01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_5_0_09_CDC01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\EFLUID_GEDIADATA01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\EFLUID_GEDIAINDEX01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\EFLUID_GEDIAPARAM01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\EFLUID_GEDIABLOB01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\EFLUID_RSEIPCDATA01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\EFLUID_RSEIPCINDEX01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\EFLUID_RSEIPCPARAM01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\EFLUID_RSEIPCBLOB01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_4_0_31_PARAM01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_4_0_31_DATA01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_4_0_31_INDEX01.DBF',
'D:\PROGRAMS\ORACLE\ORADATA\ICEFLD\DBF\LIV_4_0_31_BLOB01.DBF'
CHARACTER SET WE8ISO8859P15
; |
Partager