Media recovery is a process to recover database from backup when physical disk failure occur.,in other way loss of physical file which has to be taken care by Oracle DBA

Media failures fall into two general categories: permanent and temporary.

Permanent media failures are serious hardware problems that cause permanent loss of data on the disk. Lost data cannot be recovered except by repairing or replacing the failed storage device and restoring backups of the files stored on the damaged storage device.

Temporary media failures are hardware problems that make data temporarily inaccessible, but do not corrupt the data. Following are two examples of temporary media failures:

  1. A disk controller fails. Once the disk controller is replaced, Oracle can access the data on the disk.
  2. Power to a storage device is cut off. Once the power is returned, the storage device and all associated data is accessible again.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.