What is the Impact on the Database When Modifying the OS Date

一個簡單文件，記錄下。

 

What is the Impact on the Database When Modifying the OS Date? [ID 559660.1]
		修改時間 01-MAY-2008 型別 HOWTO 狀態 PUBLISHED

In this Document
Goal
Solution

---

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3
Information in this document applies to any platform.

Goal

What is the impact on the database when modifying the OS date?

Solution

1. It will affect any records that are inserted while changing the date if it involves the sysdate.

2. It will also affect any scheduler jobs that will run on that date.

Please follow those steps :

1. Take a backup
2. Shutdown database (clean)
3. Change date/time on OS
4. Startup database