Home » RDBMS Server » Backup & Recovery » 9i windows rollback segment file cannot be read urgent problem
9i windows rollback segment file cannot be read urgent problem [message #148783] Mon, 28 November 2005 02:17 Go to next message
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?
Re: 9i windows rollback segment file cannot be read urgent problem [message #148998 is a reply to message #148783] Tue, 29 November 2005 08:21 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

Shutdown your database then restart your server machine after that try to start the database ... and please note dont forget to tell the status of your error here .

Regards
sunilkumar

[Updated on: Tue, 29 November 2005 08:23]

Report message to a moderator

Previous Topic: Please see this....? when o/s get corrupt .....
Next Topic: Incremental backup
Goto Forum:
  


Current Time: Thu Dec 01 15:02:23 CST 2022