This discussion is archived
9 Replies Latest reply: Feb 24, 2013 11:01 PM by Sunny kichloo RSS

Stoping recovery process....ORA-01110

Fayn_dba Newbie
Currently Being Moderated
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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points