current system time within the log shows a date 6 days ago from the real current system time
Customer facing the issue that current system time within the cocurrent program log shows five days ago from the real current system time.
i.e.
if a concurrent request is being run today ( 17/Oct/2014) , the log file from within the concurrent request after completion display as
"Current System time is 11-Oct-2014" instead it displays " Current system time is 17-Oct-2014".
Customer back up db on 11-Oct-2014 and restore DB by RMAN.
After restore DB , customer started to face the issue.
system date is as below:
SQL> SELECT TO_CHAR
2 (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW"
FROM DUAL;
3
NOW
-------------------
10-17-2014 18:00:31