Skip to Main Content
  • Questions

  • Undo retention in future date - wrong date

Breadcrumb

Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions

Question and Answer

Chris Saxon

Thanks for the question, Ricardo.

Asked: June 27, 2019 - 1:28 pm UTC

Last updated: June 28, 2019 - 8:39 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Dear, I have an atypical situation.
With the change of daylight saving time one of the rac nodes had the time changed for 5 years ahead. The time stayed for a few seconds and did not have a node restart but the tablespace undo is with segments with begin time and end time for the year 2025. I can not release the space used. Would you have any alternative for cleaning?

thankful
Ricardo

select to_char(begin_time, 'DD-MON-RR HH24:MI') begin_time,
to_char(end_time, 'DD-MON-RR HH24:MI') end_time, tuned_undoretention
from v$undostat order by end_time;


Begin Time              End time               UNDOTSN  UNDOBLKS    TXNCOUNT    MAXCON
10/21/2025 00:44:26 10/21/2025 00:45:34 2 255234254 432238549 44
10/21/2025 00:34:26 10/21/2025 00:44:26 2 2665 3605 7
10/16/2025 23:54:26 10/21/2025 00:34:26 2 0 0 0

and Chris said...

How the heck did daylight savings cause the database server to have a date six years in the future?!

Anyway, if fixing the clock and restarting the server/instance doesn't fix this, I think you're going to have to call support.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Date

Ricardo Lyrio, June 27, 2019 - 7:08 pm UTC

The automatic adjustment did not change the date for the year 2025, it was a manual date command. This year the adjustment had patch correction because of change in start date and end.
Chris Saxon
June 28, 2019 - 8:39 am UTC

Regardless of how this happened, contact support to resolve this.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database