1 2 Previous Next 21 Replies Latest reply: Nov 24, 2012 5:37 AM by 951027 RSS

    backup database required recovery

    951027
      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