RMAN Point In Time Recovery Options
Hello -
I am testing various point-in-time recovery scenarios and have questions re: datetime and SEQ. Referring to Oracle FAQs and doc 7.6 Performing Database Point-In-Time Recovery
Datetime -
I have tried various formats, none work. Have Windows OS 2008 R2.
some that I have tried:
SET UNTIL TIME 'Mar 31 2014 14:00:00';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/31/2014 16:50:31
ORA-01858: a non-numeric character was found where a numeric was expected
RMAN>
set until time to_date('31-Mar-2014 14:00:00', 'DD-MON-YYYY HH24:MI:SS');
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "double-quoted-s