Considerations for the Oracle database server to modify operating system time:
For stand-alone or ha
1. In fact, the database itself is not affected. Because the SCN does not depend on OS time
2. For apps (apps), if you use Sysdate in your app, it really does have an impact.
Based on this situation, we generally recommend: Change the OS time does not go to the previous time to change, but to the future time to change.
to RAC
1. For the database itself, it has an impact because CRS requires the node's OS time to stay in sync, otherwise it may cause the node to evict.
2. For apps (apps), if you use Sysdate in your app, it really does have an impact.
Based on this situation, we generally recommend: Change the OS time does not go to the previous time to change, but to the future time to change.
Considerations for Oracle database server to modify operating system time