修改系统时间需重启Oracle数据库

昨天，一个朋友需要修改Oracle所在服务器的系统时间，问我是否需要重启oracle。
我也拿不准，专门去MOS查了查，确实需要重启数据库，不然对sysdate和调度job都有影响。

What is the Impact on the Database When Modifying the OS Date? (文档 ID 559660.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
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