Re: How to detect missing rollback segments?

> Fumi wrote:

> It's no need to detect, and you can'd detect, before the database is open.
> Just remove or remark the line "rollback_segments" in init.ora,
> startup, identify the rollback segments, edit init.ora, then restartup.

Fumi,

My question was about detecting it *before* it happens. I did have a need for this since I am building an automated troubleshooter that should be
able to detect whatever is wrong with a database and then offer a repair. This was about the last thing that was missing from it (I think).

But your answer seems correct. It cannot be detected since rollback segments are not
recorded in the controlfile and the controlfile is the only file open when the database
is mounted (not opened)

Thanks,

    Erwin Received on Sun Sep 26 1999 - 16:33:37 CDT