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
| STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "orafrance" RESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 908
LOGFILE
GROUP 1 'G:\ORACLE\ORADATA\orafrance\REDO01.LOG' SIZE 100M,
GROUP 2 'G:\ORACLE\ORADATA\orafrance\REDO02.LOG' SIZE 100M,
GROUP 3 'G:\ORACLE\ORADATA\orafrance\REDO03.LOG' SIZE 100M
-- STANDBY LOGFILE
DATAFILE
'F:\ORACLE\ORADATA\orafrance\SYSTEM01.DBF',
'F:\ORACLE\ORADATA\orafrance\CWMLITE01.DBF',
'F:\ORACLE\ORADATA\orafrance\DRSYS01.DBF',
'F:\ORACLE\ORADATA\orafrance\EXAMPLE01.DBF',
'F:\ORACLE\ORADATA\orafrance\INDX01.DBF',
'F:\ORACLE\ORADATA\orafrance\ODM01.DBF',
'F:\ORACLE\ORADATA\orafrance\TOOLS01.DBF',
'F:\ORACLE\ORADATA\orafrance\USERS01.DBF',
'F:\ORACLE\ORADATA\orafrance\XDB01.DBF',
'F:\ORACLE\ORADATA\orafrance\INDEX\INDPRD.DBF',
'F:\ORACLE\ORADATA\orafrance\DATA\DATPRD.DBF',
'F:\ORACLE\ORADATA\orafrance\DATA\DATDEM.DBF',
'F:\ORACLE\ORADATA\orafrance\DATA\DATDIS.DBF',
'F:\ORACLE\ORADATA\orafrance\DATA\DATHIS.DBF',
'F:\ORACLE\ORADATA\orafrance\DATA\DATREF.DBF',
'F:\ORACLE\ORADATA\orafrance\INDEX\INDDEM.DBF',
'F:\ORACLE\ORADATA\orafrance\INDEX\INDDIS.DBF',
'F:\ORACLE\ORADATA\orafrance\INDEX\INDHIS.DBF',
'F:\ORACLE\ORADATA\orafrance\INDEX\INDREF.DBF',
'F:\ORACLE\ORADATA\orafrance\INDEX\INDDIS2.DBF',
'F:\ORACLE\ORADATA\orafrance\INDEX\INDDIS3.DBF',
'F:\ORACLE\ORADATA\orafrance\INDEX\INDDIS4.DBF',
'F:\ORACLE\ORADATA\orafrance\INDEX\INDDIS5.DBF'
CHARACTER SET WE8MSWIN1252
;
RECOVER DATABASE USING BACKUP CONTROLFILE;
ALTER DATABASE OPEN RESETLOGS; |
Partager