Saturday, May 10, 2008

17-9. Flashback Database Limitations

  • You cannot use Flashback Database if the control file has been restored or re-created.
  • Data file dropped after Flashback target time cannot be recovered (the dropped data file is added to the control file and marked offline, but it is not flashed back)
  • Data file that has been shrunk since the Flashback target time cannot be flashed back. Any such data files must be taken offline before performing the flashback operation.

0 comments: