Re: EM scheduled RMAN backup & daylight saving time

From: Matthias Hoys <anti_at_spam.com>
Date: Thu, 5 Apr 2007 00:30:30 +0200
Message-ID: <46142706$0$13860$ba620e4c@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 Received on Wed Apr 04 2007 - 17:30:30 CDT