This discussion is archived
1 2 Previous Next 21 Replies Latest reply: Nov 24, 2012 3:37 AM by 951027 RSS

backup database required recovery

951027 Newbie
Currently Being Moderated
Hello all,

I am trying to perform hot backup and recovery, the bckup was taken and then im getting this error.

iam using oracle 11.2.0.1.0 and on windows environment.


SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database required recovery
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\APP\USER\ORADATA\PROD3\SYSTEM01.DBF'
1 2 Previous Next

Legend

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