What is a media failure?

What is a media failure?

Rating:

A media failure occurs when a physical problem prevents Oracle from writing or reading a database file that is required for continuing the database operation. For example, when a disk head crashes, all the database files on the disk drive are lost. Disk failure can affect a variety of files, including the data files, redo log files, and control files. Because the database instance cannot continue to function properly, it cannot write the data from the database buffer cache of the system global area (SGA) to the data files.

The appropriate recovery from a media failure depends on the files affected. Media failure is the primary concern of a backup and recovery strategy because it typically requires restoring some or all the database files and the application of redo data during the recovery.

Rating: