Re: rollback_segment in initdbname_0.ora

Oliver Belikan wrote:
>
> the initdbname_0.ora sets rollback_segment =().
> Starting the db, the error ORA-1534 Rollback segement '' doesn´t exist
> occur.
> What is the cause ? How could i solve the Problem ?
When you first started the database you then created rollback segments. As they are private rollback you must now name them between the parenthesis of the rollback_segment parameter in your init.ora file. i.e. rollback_segment=(RBS_01,RBS_03,RBS_02,RBS_04) This will ensure they will be started upon Oracle instance startup. Notice I inverted the rollback name 03 vs 02. That's because this decides in which order the rollbacks will be assigned to transactions and I split my rollback on different disks for more performance.

If you had created those rollbacks PUBLIC the transaction and number_of_transaction/rollback parameters would start automatically the rollbacks as needed.

Sylvie Bérubé
sberube_at_cam.org Received on Tue Feb 04 1997 - 00:00:00 CST