6 Replies Latest reply: Aug 2, 2013 12:04 PM by jrmtl RSS

    11.2.0.3 Dataguard setup standby activation fails

    jrmtl

      Hello all,

      I have done all steps ( logs properly shipped and applied ) prior to activating a standby DB.

      When I perform the following steps i get this error which is very strange.

       

      ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH; OK
      shutdown immediate; OK
      startup mount; OK
      alter database activate physical standby database;

      ORA-01152: file 1 was not restored from a sufficiently old backup
      ORA-01110: data file 1: '/usr/oradata/orastdby/oradata2/system01.dbf'

       

      Any ideas?

       

      Thx in advance for the help