create database PARESH
CONTROLFILE REUSE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 1000
MAXINSTANCES 1
MAXLOGHISTORY 1357
LOGFILE
GROUP 1 (
‘/db1/oradata/800PARESH/redo01a.log’,
‘/db2/oradata/800PARESH/redo01b.log’
) SIZE 25M REUSE,
GROUP 2 (
‘/db1/oradata/800PARESH/redo02a.log’,
‘/db2/oradata/800PARESH/redo02b.log’
) SIZE 25M REUSE,
GROUP 3 (
‘/db1/oradata/800PARESH/redo03a.log’,
‘/db2/oradata/800PARESH/redo03b.log’
) SIZE 25M REUSE
DATAFILE
‘/db3/oradata/800PARESH/system01.dbf’ size 200M reuse;