| 9i windows rollback segment file cannot be read urgent problem [message #148783] |
Mon, 28 November 2005 02:17  |
davo
Messages: 2
Registered: November 2005
|
Junior Member |
|
|
hi all,
got in just now, database is mounted, it did a shutdown ora-600 during lgwr.
If I try to reatart the services in windows it just mounts the db.
Cannot get into sqlplus to do anything.
enterprise manager just gives me an exclamation mark if I try to start the db.
alert log full of following messages ..
Errors in file D:\oracle\ora81\RDBMS\trace\livePMON.TRC:
ORA-00376: file 8 cannot be read at this time
ORA-01110: data file 8: 'D:\ORACLE\ORA81\ORADATA\LIVE\ENTROLL'
Looks like it has lost the data file, or something like that.
what do I do?
It is a rollback segment ... can I copy the one from the cold backup at the weekend over it, or will this screw things up evenh more?
How do I get to enter commands like "recover datafile" etc if I do not have sqlplus available?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
