I'm having a senior moment here. The SA is wanting to change the OS date/time....how will this affect the Oracle instances running on the box.? Should I bring the instances down, let him change the date (date command I'm guessing, this is a RH box)...and then bring it back up..
Or, do I need to take it down at all....just leave it up and let them do the date command ?
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.