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
*
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.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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
You appear to have a space at the beginning of the filename. I have highlighted the first few but all appear to have these spaces.
Take out the spaces. Oracle cannot find the files because their names don't begin with a blank space.
Bookmarks