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
|
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "SAGE" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 1363
LOGFILE
GROUP 1 'D:\ORACLE\ORADATA\SAGE\REDO01.LOG' SIZE 50M,
GROUP 2 'D:\ORACLE\ORADATA\SAGE\REDO02.LOG' SIZE 50M,
GROUP 3 'D:\ORACLE\ORADATA\SAGE\REDO03.LOG' SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'D:\ORACLE\ORADATA\SAGE\SYSTEM01.DBF',
'D:\ORACLE\ORADATA\SAGE\UNDOTBS01.DBF',
'D:\ORACLE\ORADATA\SAGE\SYSAUX01.DBF',
'D:\ORACLE\ORADATA\SAGE\USERS01.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_IMMOOWN_2OVXD6GG_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBMASTER_2OVXZKF8_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBERPDEM_2OVYXLLX_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBTRESOD_2OW07VR2_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBTELMAM_2OW1V8WD_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBTRESOT_2PBM0YN1_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_FA7_TBS__2PBQHJDF_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBTELMAM_2PCF6BXV_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBMASTER_2PCHXQOB_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBTELMAM_2PCKMFO9_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBMASTER_2PF3OZG7_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBMASTER_2PJN96OK_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBTELMAT_2PTB7W34_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBERPTEL_2Q85JM2Z_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBERPTM_2Q88ZGKC_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBERPMOB_2Q89OV5S_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBTMOBIL_2Q8BD38D_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBERPTMO_2Q8FLHS8_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBERPTEL_2Q8H7WK9_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBMASTER_2S5OOM7T_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBMASTER_2S725D5S_.DBF',
'D:\ORACLE\ORADATA\SAGE\DATAFILE\O1_MF_DBDEMOER_2S734N1S_.DBF'
CHARACTER SET WE8MSWIN1252
; |
Partager