Bug in odacli irestore?
When I run the following command:
odacli irestore-database -r backup_report.json -u dbUniqueName -ro STANDBY
I get this error:
RMAN-05565
The RMAN log file that is generated shows that the SPFILE could not be restored:
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 04/28/2022 12:16:36 RMAN-05501: aborting duplication of target database RMAN-05565: SPFILE backup created before to_date('2022/04/27 01:01:53', 'YYYY/MM/DD HH24:MI:SS') not found in /abcd/files/efgh_bkup/TO_HERE/DB/db
It appears that the odacli irestore command calculates the wrong time for the UNTIL portion of the script: