|
-
 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
|