DB Problem

[netbar]

Hi I have an urgent problem.

ORA-12801: error signaled in parallel query server P002
ORA-01172: recovery of thread 1 stuck at block 11056 of file 22
ORA-01151: use media recovery to recover block, restore backup if needed

Db Crashed last night when performing an over night export error message in alert log is:

ORA-1650: unable to extend rollback segment RBS0201 by 2560 in tablespace RB02

Failure to extend rollback segment 27 because of 1650 condition
Wed Jun 18 00:07:12 2003
Failure to extend rollback segment 27
Failure to extend rollback segment 27 because of 1562 condition
Wed Jun 18 00:09:02 2003
Failure to extend rollback segment 27
Failure to extend rollback segment 27 because of 1562 condition
Wed Jun 18 00:09:17 2003
Failure to extend rollback segment 27
Failure to extend rollback segment 27 because of 1562 condition
Failure to extend rollback segment 27
Failure to extend rollback segment 27 because of 1562 condition
Wed Jun 18 00:34:52 2003
WARNING: aiowait timed out 1 times
WARNING: aiowait timed out 2 times

DBW0: terminating instance due to error 27062
Instance terminated by DBW0, pid = 658



Problem is I don't have a backup. (Awful practice I know but this was supposed to be a piddle test db, not so know thought the heat is on.

Incidentally I have offlined the datafile in question and then tried to start db is this OK?

[SANJAY_G]

Originally posted by netbar
Problem is I don't have a backup. (Awful practice I know but this was supposed to be a piddle test db, not so know thought the heat is on.

I hope you learnt a lesson here.

Incidentally I have offlined the datafile in question and then tried to start db is this OK?

I don't think you can just offline and start the db. You may have to do a offline drop, remember you will lose all the data in the file and if that is the only datafile for the tablespace, drop and recreate the ts.