|
Тема |
Re: днес е един шибан ден... [re: Vesi] |
|
Автор |
oracle9 (ora-600) |
|
Публикувано | 09.08.02 01:14 |
|
|
Pich,
Obiasnenieto za tvoiata ora-600 e:
------------------------------------------------------------------------------------------------------
The ORA-600[4194] is signalled when the transaction table and the undo block is out of sync. Theres possible data corruption.
Please log an iTAR for further support as there is potential rollback segment corruption.
Problem Explanation:
====================
Oracle is unable to roll back an uncommitted transaction in its transaction table. You have corruption in the rollback segment or corruption in an object which the rollback segment is trying to apply undo record.
--------------------------------------------------------------------------------------------------------
Officilanata pozicia e:
In all cases, the ideal solution for a corrupted ROLLBACK SEGMENT is to
restore your backup and do a point in time recovery to just prior to when
the problem occurred.
Neoficialnata e da probash s _offline_rolback_segments ili _corrupted_rollback_segments. Sled tova nai_dobre e da si recreatenesh bazata danni nanovo( predi tova estestveno shet napravish export za da si zxapazish tvoite danni i sled tova ste go importnesh v novata bd ) ama sum vijdal dosta hora deto oste si vuvrviat na takava BD.
Eto obiasnenie i za tezi parametri:
|
| |
|
|
|