Re: move from UNDO_MANAGMENT=AUTO to MANUAL

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 20 Nov 2008 22:21:38 +0100
Message-ID: <4925d4ea$0$190$e4fe514c@news.xs4all.nl>


sybrandb schreef:
> On 20 nov, 11:21, Ismael <isma.sanc..._at_gmail.com> wrote:

>> On Nov 20, 10:14 am, sybrandb <sybra..._at_gmail.com> wrote:
>>
>>
>>
>>
>>
>>> On 20 nov, 09:14, Ismael <isma.sanc..._at_gmail.com> wrote:
>>>> Hi,
>>>> Oracle 10.2.0.3 on Win 2003 Server
>>>> We have an Oracle database running in automatic undo management.
>>>> An application provider has to upgrade his application and needs the
>>>> database running in manual undo management.
>>>> I've never gone back to manual from auto ... could you give me any
>>>> advice? Do you know the best way to success?
>>>> Thank you very much for your help?
>>>> Best Regards,
>>>> Ismael
>>> I would request the 'application' provider to send his 'developers' to
>>> a course, so the 'application' doesn't need to walk on one leg and one
>>> crutch.
>>> --
>>> Sybrand Bakker
>>> Senior Oracle DBA
>> One of the migration steps is the repository upgrade (the repository
>> is stored in the oracle database). For this step, they advise us to
>> change de undo management to MANUAL before running the processes that
>> are involved. It's not an application requirement, we can change to
>> AUTO after upgrading ...
>> Changing undo management to MANUAL is ONLY for the upgrade.
>> Could you help me?- Tekst uit oorspronkelijk bericht niet weergeven -
>>
>> - Tekst uit oorspronkelijk bericht weergeven -

>
> The obvious solution is of course to take the documentation and to
> read up on undo management,
> and to notice you only need to create rollback segments and change the
> undo_management parameter.
> As this would have required you to do work, which you rather avoid,
> you are asking a volunteer to abstract the docs.
> Current DBA mentality is so sad....
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Luckily we still have our senior DBA's.....

Shakespare
What's in a RAID?? Received on Thu Nov 20 2008 - 15:21:38 CST

Original text of this message