connect internal
/
startup nomount
/

CREATE DATABASE sid
       /* CONTROLFILE REUSE */
       LOGFILE GROUP 1 ( '/data/sid/redo/redo_01a.dbf', 
                         '/data2/sid/redo/redo_01b.dbf' ) size 10M,
               GROUP 2 ( '/data/sid/redo/redo_02a.dbf',
                         '/data2/sid/redo/redo_02b.dbf' ) size 10M,
               GROUP 3 ( '/data/sid/redo/redo_03a.dbf',
                         '/data2/sid/redo/redo_03b.dbf' ) size 10M,
               GROUP 4 ( '/data/sid/redo/redo_04a.dbf',
                         '/data2/sid/redo/redo_04b.dbf' ) size 10M,
               GROUP 5 ( '/data/sid/redo/redo_05a.dbf',
                         '/data2/sid/redo/redo_05b.dbf' ) size 10M,
               GROUP 6 ( '/data/sid/redo/redo_06a.dbf',
                         '/data2/sid/redo/redo_06b.dbf' ) size 10M
       DATAFILE '/data/sid/system_01.dbf' size 100M
       MAXDATAFILES 200
       MAXINSTANCES 1
       NOARCHIVELOG