9 Replies Latest reply: Feb 25, 2013 1:01 AM by Sunny kichloo RSS

    Stoping recovery process....ORA-01110

      Hi experts;

      I have created physical Standby. I am getting archives when I start the recovery process by issuing

      alter database recover managed standby database using current logfile disconnect;

      But when I stop this process & alter database open

      alter database recover managed standby database cancel

      logs reports no error but I get when "alter database open"

      ERROR at line 1:
      ORA-16004: backup database requires recovery
      ORA-01194: file 1 needs more recovery to be consistent
      ORA-01110: data file 1: '/u02/app/oracle/oradata/orcl/system01.dbf'

      this. Actually I had copied all datafiles without issuing "ALter database begin backup"

      So please provide me the solution

      Thanks in Advance