2, try removing the file urself (only if you are ging to restore) and restore the file from backup
3, recover the DB
04-30-2001, 05:44 PM
Yes, The file exists and i tried to restore it after removing it but it still does not work.
04-30-2001, 05:49 PM
Did you check whether there is enough space?
Also, try adding a file thru sql*plus and see what error it is giving (if another test DB on the machine is available)
(ex. Alter tablespace ts1 add datafile C:\ORA805\DATABASE\REC_DATAORCLn.ORA size size1 ;
04-30-2001, 06:05 PM
It gives me the following error when I try to create the file through sql plus
Alter tablespace usr add datafile 'C:\ORA805DATABASE\REC_DATAORCL100.ORA'
ERROR at line 1:
ORA-01119: error in creating database file 'C:\ORA805\DATABASE\REC_DATAORCL100.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
But I am able to create the datafiles using server manager and enterprise manager.
Please suggest how do i fix this.
04-30-2001, 06:12 PM
check the path,
I guess 'C:\ORA805DATABASE' has to be
Note the "SLASH" betwn ORA805 and DATABASE
BTW, is it a parallel DB?
04-30-2001, 06:16 PM
That would be correct, but how are you connecting to the target database as SYS/SYSTEM/SOME_USER. If you are a sys/system, then make sure of the file permissions like. As prince suggested it has to do some thing with your file permissions I beleive, if you were able to restore the other file except this one.
04-30-2001, 06:19 PM
The path is correct. It has a / in it.
It is 'C:\ORA805\DATABASE'
Alter tablespace usr
I connect to the target database using internal.
It is not a Parallel Database.
04-30-2001, 06:26 PM
How do i view/manage file permissions for the user internal and assign it the required permissions to perform the recovery on a windows 2000 machine.
I have a Oracle 8.0.5 database installed.
And why is that I am able to create a datafile using server manager and enterprise manager using the same user and not sql plus?????
04-30-2001, 07:01 PM
I am not sure, whether this is of any help. Anyway try this.
Righ click the mouse on another file which got restored and compare its properties, securities with the one which is giving the problem. May be you will find some information.
Also make sure ur path, SID all set properly to avoid mess-ups