recreation of control files
My Oracle server went down,
I tried to copy all the database folder but some files can not copied (media error),
I repaired the disk then finally copied all folder files successfully,
installed new oracle database server,
created database with the same name,
copied the folder instead of the new one,
tried to start it up but there is an error Ora-00209,
it runs on nemounts only
that error indicates contril files mismatch with the data files headers I think,
I tried to create new control files using the following syntax;
CREATE CONTROLFILE REUSE DATABASE "MONTJ" NORESETLOGS
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 14
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'F:\ORACLE\ORADATA\MONTJ\REDO01.LOG' SIZE 100M,
GROUP 2 'F:\ORACLE\ORADATA\MONTJ\\REDO02.LOG' SIZE 100M,
GROUP 3 'F:\ORACLE\ORADATA\MONTJ\\REDO03.LOG' SIZE 100M
DATAFILE
'F:\ORACLE\ORADATA\MONTJ\ INDX01.DBF',
'F:\ORACLE\ORADATA\MONTJ\ TOOLS01.DBF',
'F:\ORACLE\ORADATA\MONTJ\ SYSTEM01.DBF',
'F:\ORACLE\ORADATA\MONTJ\ UNDOTBS01.DBF',
'F:\ORACLE\ORADATA\MONTJ\ EXAMPLE01.DBF',
'F:\ORACLE\ORADATA\MONTJ\ USERS01.DBF',
'F:\ORACLE\ORADATA\MONTJ\ OEM_REPOSITORY.DBF',
'F:\ORACLE\ORADATA\MONTJ\ CWMLITE01.DBF',
'F:\ORACLE\ORADATA\MONTJ\ DRSYS01.DBF',
'F:\ORACLE\ORADATA\MONTJ\ ODM01.DBF',
'F:\ORACLE\ORADATA\MONTJ\ XDB01.DBF',
'F:\ORACLE\ORADATA\MONTJ\ \TEM01.DBF'
CHARACTER SET AR8MSWIN1256
;
But it's giving this error;
CREATE CONTROLFILE REUSE DATABASE "MONTJ" NORESETLOGS
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file 'F:\ORACLE\ORADATA\MONTJ\ INDX01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
any one can help please
