| Oracle 7.3 missing data file [message #163543] |
Fri, 17 March 2006 03:22  |
G oracle7
Messages: 5
Registered: March 2006
Location: cabuyao, Philippines
|
Junior Member |
|
|
SVRMGR> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
ORA-00283: Recovery session canceled due to errors
ORA-01157: cannot identify data file 5 - file not found
ORA-01110: data file 5: '/data2/datp_datp1.dbf'
SVRMGR>
Where can i find this ?
if not recoverable what should i do ?
|
|
|
|
|
|
| Re: Oracle 7.3 missing data file [message #163562 is a reply to message #163557] |
Fri, 17 March 2006 04:23  |
G oracle7
Messages: 5
Registered: March 2006
Location: cabuyao, Philippines
|
Junior Member |
|
|
SVRMGR> alter database datafile '/data2/datp_datp1.dbf' offline;
alter database datafile '/data2/datp_datp1.dbf' offline
*
ORA-01145: offline immediate disallowed unless media recovery enabled
SVRMGR>
I cannot find this datafile on our backup ... only dmp files..
and i cant use it since the database not open yet..
Where should i do next?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
. You can put offline them and open database, but some of information, of course, are loose. Some tables, which have extents in this datafile must be rebuilded, recreated etc. Datafile puts offline by command: