9 Replies Latest reply: Oct 5, 2012 12:16 PM by jgarry RSS

    Everthing lost !

    Fayn_dba
      At first Linux file system was repaired by issuing fsck command
      Then the following error >>

      SQL> alter database open resetlogs;
      alter database open resetlogs
      *
      ERROR at line 1:
      ORA-01194: file 1 needs more recovery to be consistent
      ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'


      datafile 25 will be created automatically during restore operation
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 10/04/2012 16:30:17
      RMAN-06026: some targets not found - aborting restore
      RMAN-06023: no backup or copy of datafile 4 found to restore
      RMAN-06023: no backup or copy of datafile 3 found to restore
      RMAN-06023: no backup or copy of datafile 2 found to restore
      RMAN-06023: no backup or copy of datafile 1 found to restore

      No cold backup is there

      Archives are also missing !

      Whats the solution ??