High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Can I change forward and backward again the date of the master server with an offline standy databas

Hello, I have an Oracle 10g  Standard Edition database running on linux. Configured with a manual standby database (non Dataguard, using linux scripts to copy and apply logs).

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center