Re: how can i increase rollback segments simultaneously??

From: Stephen Harris <sweh_at_mpn.com>
Date: 30 Dec 1998 16:44:48 GMT
Message-ID: <76dla0$rno$1@nebula.mpn.com>

Piotr Kolodziej (pkol_at_otago.gda.pl) wrote:

: Stephen Harris wrote in message <76bknd$12b$1_at_nebula.mpn.com>...

: >careful with thos though - if your database crashes while the largeroll is
: >online you may not be able to perform instance recovery properly...

: Why ? Could you tell us ...

As I understand it (and I may be wrong....) this is because largeroll is not listed in the init.ora file as being initially online, so the instance recovery will be unable to find some of the rollback information required to rollback incomplete transactions, after having replayed the redo logs.

Simple fix is to add largeroll to the list of rollback segments in the init.ora file, startup the database (which will now correctly perform instance recovery), take the largeroll offline, shutdown the database (cleanly!) and then remove largeroll from init.ora again.

Note: this has only happened to me once before, so I may be wrong about this :-)

rgds
Stephen Received on Wed Dec 30 1998 - 10:44:48 CST