-
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
-
Do you have a real backup?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
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.
-
 Originally Posted by WOLEMY
My Oracle server went down,
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
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|