Recreate Control File
I need to recreate my control file. What I'm planning on running is the following. Can you advice its correctness and on what commands that need to be added at the end to get my database up and running.
(there are no cold backups )
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "Ora11gDB"
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 10
LOGFILE
GROUP 1 'D:\ORACLE\ORADATA\ORCL\REDO01.LOG' SIZE 10M,
GROUP 2 'D:\ORACLE\ORADATA\ORCL\REDO02.LOG' SIZE 10M,
GROUP 3 'D:\ORACLE\ORADATA\ORCL\REDO03.LOG' SIZE 10M
DATAFILE
'E:\OracleSoftware\oradata\Ora11gDB\TEMP01.DBF',
'E:\OracleSoftware\oradata\Ora11gDB\SYSAUX01.DBF',
'E:\OracleSoftware\oradata\Ora11gDB\USERS01.DBF',
'E:\OracleSoftware\oradata\Ora11gDB\UNDOTBS01.DBF',
...
'E:\OracleSoftware\oradata\Ora11gDB\DATAMINING.DBF'
CHARACTER SET US7ASCII;