This content has been marked as final. Show 2 replies
Changing the OS date will change the SYSDATE on the database. If you have something that depends on SYSDATE, that could cause problems (i.e. if there is a process that inserts records using SYSDATE and another that orders by the date, you could get things out of order if the time is going backwards). If you have to recover to a point in time during the window, you may have to recover to a SCN rather than a timestamp. Other than that, it should be pretty safe.
there will be no effect and its not necessary to shutdown DB for this. Only you need to take care of any issues with the SYSDATE in oracle.1 person found this helpful