Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT: ORA-01554 upon startup

Re: URGENT: ORA-01554 upon startup

From: Joel Garry <joel-garry_at_home.com>
Date: 18 Mar 2003 17:25:19 -0800
Message-ID: <91884734.0303181725.5ee2f84b@posting.google.com>


netcomrade_at_netscape.net (NetComrade) wrote in message news:<ab810584.0303180839.30c9d2a4_at_posting.google.com>...
> the original values were
> transactions integer 1820
> transactions_per_rollback_segment integer 5
>
> the new values were
>
> transactions 10000
> transactions_per_rollback_segment 40
>
> I've also tried playing around with these.
>
> The trace file
> /u31/app/oracle/admin/BASE/udump/base_ora_15807.trc
>
> contains nothing but the already mentioned errors.
>
> Oracle support wasn't able to recover the database for us.
> They tried to bring it up with
> _corrupted_rollback_segments= (<segment_list>)
> but that didn't help
> they offerred to come on site and recover the data manually, starting
> at $10K, but that wasn't worth our time. We brought up the data in a
> separate instance with 20 hours of data lost.
> This instance is still left for my amusement. If anybody has any
> suggestions, I'll be more than happy to try them out. (we still would
> like this data back)

Is there a reason you can't recover the db until the sequence before the one that crashed?

>
>
>
>
> DA Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3E765BB6.6059E162_at_exxesolutions.com>...
> > NetComrade wrote:
> >
> > > This is really frustrating.. I can't bring up the db
> > > startup force doesn't help
> > > increasing transactions and transaction_per_rollback_segment doesn't
> > > help either.
> > > anybody seen this?
> > >
> > > thnx.
> > > .......
> > > We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> > > remove NSPAM to email
> >
> > I'm not so sure your statement "increasing transactions and
> > transaction_per_rollback_segment doesn't
> > help either." because you give no indication of what it was originally
> > and how much you increased these parameters.
> >
> > My guess here is that Oracle is trying to clean-up or clean-out
> > something and needs a lot more space than it has.
> >
> > Check the log files as Gabriel suggests and publish the original and
> > modified values for us to see.
> >
> > Daniel Morgan

jg

--
@home.com is bogus.
Received on Tue Mar 18 2003 - 19:25:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US