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
| CREATE CONTROLFILE
SET DATABASE orcl
LOGFILE ('D:\oracle\product\10.2.0\oradata\orcl\REDO01.log') SIZE 50M,
('D:\oracle\product\10.2.0\oradata\orcl\REDO02.log') SIZE 50M,
('D:\oracle\product\10.2.0\oradata\orcl\REDO02.log') SIZE 50M,
NORESETLOGS
DATAFILE 'D:\oracle\product\10.2.0\oradata\orcl\ORA_DATA001.DBF' SIZE 10M,
'D:\oracle\product\10.2.0\oradata\orcl\ORA_DATA01.DBF' SIZE 10M,
'D:\oracle\product\10.2.0\oradata\orcl\ORA_DATA002.DBF' SIZE 10M,
'D:\oracle\product\10.2.0\oradata\orcl\ORA_DATA02.DBF' SIZE 20M,
'D:\oracle\product\10.2.0\oradata\orcl\ORA_DATA03.DBF' SIZE 30M,
'D:\oracle\product\10.2.0\oradata\orcl\RDBS.DBF' SIZE 20M,
'D:\oracle\product\10.2.0\oradata\orcl\SYSAUX01.DBF' SIZE 350M,
'D:\oracle\product\10.2.0\oradata\orcl\SYSTEM01.DBF' SIZE 490M,
'D:\oracle\product\10.2.0\oradata\orcl\TBSPACE1.DBF' SIZE 50M,
'D:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF' SIZE 20545M,
'D:\oracle\product\10.2.0\oradata\orcl\USERS01.DBF' SIZE 5M,
'D:\oracle\product\10.2.0\oradata\orcl\USERS02.DBF' SIZE 2M,
'D:\oracle\product\10.2.0\oradata\orcl\USERS03.DBF' SIZE 5M
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXLOGHISTORY 400
MAXDATAFILES 200
MAXINSTANCES 6
ARCHIVELOG; |
Partager