8 Replies Latest reply: Mar 19, 2013 4:09 AM by saratpvv RSS

    Error ORA-01861 by RECOVER DATABASE UNTIL TIME

    455447
      Hello DBA's

      I want to recover a test database with the until time clause but I get always the error with "ORA-01861: Literal Does Not Match Format String".

      I do the following steps: (all under SQLPLUS)

      SHUTDOWN IMMEDIATE
      CONNECT / AS SYSDBA
      STARTUP MOUNT
      ALTER SESSION SET nls_date_format='dd.mm.yyyy hh24:mi:ss';
      RECOVER DATABASE UNTIL TIME '08.12.2006 09:55:00'

      Then I get the error but the date string is right!
      I searched in the forum and found the following command:

      RECOVER DATABASE UNTIL TIME "to_date('08.12.2006 09:55:00','dd.mm.yyyy hh24:mi:ss')";
      But then I get this error "ORA-00972: identifier is too long".

      I use ORACLE 10.2.0.2 on a SUSE LINUX System. Hope anyone can help me.


      Thanks ahead..