DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DB Problem

  1. #1
    Join Date
    Jul 2001
    Posts
    181

    DB Problem

    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?

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Re: DB Problem

    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.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width