Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the impact of changing OS time on the database. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

This article: the description provides the impact of operating system date changes on databases, application data, and jobs.

one. It will affect any records inserted, and if sysdate is involved, change the date.

two. It also affects any scheduler jobs that run on that date.

If the system time is adjusted forward, no matter how long the adjustment takes, it will not cause the system to restart. However, if the system time is adjusted backward, it will cause the entire node to restart.

The correct method is to first shut down the database and CLUSTER environment, and then modify the system time. In order to avoid time conflicts in the database, it is best to wait for the current time to exceed the system time before modification, and then start the CLUSTER environment and RAC database.

Follow these steps:

1. Make a backup

two。 Shut down the database (cleaning)

3. Change the date / time operating system

4. Start the database

Add:

1.1. Only modify the date, not the time. Enter:

Date-s 2018-08-03

1.2. Modify time only. Enter:

Date-s 14:15:00

1.3. Modify the date and time at the same time, with double quotation marks and a space between the date and time. Enter:

Date-s "2018-08-03 14:15:00"

two。 Write the system time to CMOS

Clock-w

After reading the above, do you have any further understanding of the impact of changing the OS time on the database? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.