1 2 Previous Next 18 Replies Latest reply: Aug 13, 2012 3:20 AM by 955382 RSS

    Recover deleted datafile

    891135
      Hi All,

      We have a critical situation where one of our datafiles has accidentally been deleted from the production database. Now the scenario is that the last backup of the datafile was taken on 6th of May and after and after the backup was taken no archives are available. The client is asking to restore that particular datafile from 6th may backup and perform a cancel based recovery. But my assumption is that particular datafile should have old scn and the scns of the rest of the datafiles have moved forward so it is not possible. Am I correct here ? And how can the datafile be recovered ?

      Database Version---10.2.0.5.0

      OS Version------------- SunOS 5.9 Generic_122300-60 sun4u sparc SUNW,Sun-Fire-V890
      64-bit sparcv9 kernel modules
        1 2 Previous Next