Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> SCN tied to the time stamp while doing recovery
Hi all,
I was reading Backup and Recovery Handbook 8i (By Rama Velpuri) and I came across an interesting scenario in the case study.
SCENARIO:
Time change from 2am in the morning back to 1am during day light savings time change. In the database, a mistake was made at 1:55am *after* the day light savings adjustment is made. Or even a crash/media failure can occur around that time.
When trying to recover we could easily end up recovering till the 1:54am *before* the time change. In other words we lose more than an hour's worth of transactions. This happens because apparently the SCN is tied to the time stamp in the log files.
![]() |
![]() |