Re: Problems with Public Rollback Segments

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Thu, 16 Apr 1998 09:03:55 +0200
Message-ID: <6h4aqm$d5n$1@sunrise.pg.gda.pl>

>Has anybody heard of circumstances where public rollback segments can cause
>corruption or other problems in a V7 or V8 database ?
>
>This is not a parallel server installation.
>
>I have heard some comments recently to this effect but the source did not
>know under what circumstances.
>

That problem may occur when database is mounted accidentially by another instance.
For example while you're creating database on NT box running another database
with oradim73.exe you MUST DIRECTLY specify -pfile parameter (pointing to init<sid>.ora).
In other case, oradim73 would get default init<sid>.ora (depending on ORACLE_SID variable) !!!
And then, for one moment, previous database is mounted by two instances !!!

Piotr Kolodziej
pkol_at_otago.gda.pl Received on Thu Apr 16 1998 - 02:03:55 CDT