Can I change forward and backward again the date of the master server with an offline standy databas
Due some very specific business case we are facing:
I need to be able to "simulate a monday" over a weekend, by disabling my crontab and jobs (they don't change my data but affect performance if they run all at once), changing the date of the server to monday. Bringing the users to do a work they usually do on monday, and then putting actual date again after they are finished.
However this will result for example on the last log file xxx10, generated during the "fake monday" to have a NEWER timestamp than the next log file (say xxx11), because the server date will be returned back to normal. And some newer data in the redo log files, and undo, with older timestamps.