Re: EM scheduled RMAN backup & daylight saving time

"Matthias Hoys" <anti_at_spam.com> wrote in message news:46142706$0$13860$ba620e4c_at_news.skynet.be...
>
> <epokopac_at_excite.com> wrote in message
> news:1175697665.487753.28390_at_w1g2000hsg.googlegroups.com...
>> Try this:
>>
>> OEM Database Control
>>
>> Administration
>> Global Attributes (located under Scheduler)
>> "set DEFAULT_TIMEZONE to Canada/Eastern"
>> Apply
>>
>> Or log into SQL*Plus as sysdba and:
>>
>> execute
>> dbms_scheduler.set_scheduler_attribute('DEFAULT_TIMEZONE','Canada/
>> Eastern');
>>
>> "Bounce" OEM. May NOT be required, but it doesn't take long to do.
>>
>> My WEEKNIGHT_ and WEEKEND_ Scheduler windows were behaving similar to
>> your backup issue (i.e. running an hour later than they should since
>> the switch to DST). Setting the DEFAULT_TIMEZONE to a DST-aware value
>> (America/New_York) fixed it for me. There was NO value in there
>> previously.
>>
>> Regards,
>>
>> Eugene
>>
>
> Thanks ! Will check it out tomorrow.
>
> Matthias
>

I checked it but the DEFAULT_TIMEZONE was already filled in : set to Europe/Paris. Maybe this only influences user-created scheduler jobs and not EM backup jobs.

Matthias Received on Thu Apr 05 2007 - 16:18:57 CDT