ITPub博客

首页 > Linux操作系统 > Linux操作系统 > What is the Impact on the Database When Modifying the OS Date

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

原创 Linux操作系统 作者:zhouwf0726 时间:2019-06-16 20:33:06 0 删除 编辑
一个简单文档,记录下。
 
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

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/756652/viewspace-732033/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2006-02-22

  • 博文量
    458
  • 访问量
    416611