The situations which must undergo Media Recovery:
•You restore a backup of a datafile.
•You restore a backup control file (even if all datafiles are current).
•A datafile is taken offline (either by you or automatically by the database) without the OFFLINE NORMAL option.
Condition for Media Recovery for a Data file:
•Database must not be open or the specific datafile must be offline, if database is open.
•The datafile that needs media recovery cannot be brought online until media recovery has been completed.
•A database cannot be opened if any of the online datafiles needs media recovery.
No comments:
Post a Comment