RMAN backups not showing actual date and time just the format, in execution of comands and in listing backups.
Oracle 12.1.0.2
OS is Windows 2008R2
RMAN> backup AS compressed backupset database plus archivelog delete
RMAN> input;
2> delete noprompt force obsolete;
3> exit;
Starting backup at DD-MON-YYYY HH24:MI:SS current log archived allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=19 device type=DISK channel ORA_DISK_1: starting compressed archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=38 RECID=37 STAMP=944953853 input archived log thread=1 sequence=39 RECID=38 STAMP=944978427 input archived log thread=1 sequence=40 RECID=39 STAMP=945013934 channel ORA_DISK_1: starting piece 1 at DD-MON-YYYY HH24:MI:SS channel ORA_DISK_1: finished piece 1 at DD-MON-YYYY HH24:MI:SS piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2017_05_26\O1_MF_ANNNN_TAG20170526T155216_DLK5D288_.BKP tag=TAG20170526T155216 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:37 channel ORA_DISK_1: deleting archived log(s) archived log file name=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\ARCHIVELOG\2017_05_25\O1_MF_1_38_DLHBP3V2_.ARC RECID=37 STAMP=944953853 archived log file name=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\ARCHIVELOG\2017_05_26\O1_MF_1_39_DLJ2P4CB_.ARC RECID=38 STAMP=944978427 archived log file name=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\ARCHIVELOG\2017_05_26\O1_MF_1_40_DLK5CSXX_.ARC RECID=39 STAMP=945013934 Finished backup at DD-MON-YYYY HH24:MI:SS
Then when I list backups
RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 3 using channel ORA_DISK_1 Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 36 DD-MON-YYYY HH24:MI:SS
Backup Piece 36 DD-MON-YYYY HH24:MI:SS C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2017_05_23\O1_MF_NNNDF_TAG20170523T155215_DL9880OO_.BKP
Backup Set 37 DD-MON-YYYY HH24:MI:SS
Backup Piece 37 DD-MON-YYYY HH24:MI:SS C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2017_05_23\O1_MF_ANNNN_TAG20170523T155312_DL989RPT_.BKP
Backup Set 39 DD-MON-YYYY HH24:MI:SS
Backup Piece 39 DD-MON-YYYY HH24:MI:SS C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2017_05_24\O1_MF_ANNNN_TAG20170524T155212_DLCWMXPY_.BKP
deleted backup piece
backup piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2017_05_23\O1_MF_NNNDF_TAG20170523T155215_DL9880OO_.BKP RECID=36 STAMP=944754736 deleted backup piece backup piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2017_05_23\O1_MF_ANNNN_TAG20170523T155312_DL989RPT_.BKP RECID=37 STAMP=944754792 deleted backup piece backup piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2017_05_24\O1_MF_ANNNN_TAG20170524T155212_DLCWMXPY_.BKP RECID=39 STAMP=944841133 Deleted 3 objects
Just trying to figure out if I have a setting missing or why it does not display actual time.
k