How to continue a broken duplicate database
I'm duplicating a production DB to a test DB on the same Node, both 10.2.0.2.
Everything worked fine until the SET UNTIL clause.
executing command: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 05/08/2009 09:21:49
ORA-01858: a non-numeric character was found where a numeric was expected
because I forgot to set the NLS_DATE_FORMAT format in the shell.
...I know that there is a to_date function...
Is there a way to continue the duplication or do I have to start all over again?
regards