Paresh Sarma

• Apr 5th, 2006

 

When physical disk fail, physical database file corrupt then media recovery required

Mohammed Abdul Afroze

• Mar 25th, 2007

 

Answer:

  Media recovery is done,in response to recover a command issued by the DBA.It is also used to make current and to restore changes that were lost when a current datafile went offline with out checkpoint.

bhendega

 Profile Answers by bhendega 

• Feb 24th, 2009

 

Loss of tablespaces, datafiles, controlfile, tables it is media failure and we need to recover such a tablespaces, datafiles, controlfile or tablespace through latest backup
It is MEDIA recovery.

kannan7

 Profile Answers by kannan7 

• Apr 14th, 2010

 

Media recovery is used to recover from a damaged(or lost) datafile, controlfile, or spfile. The goal of media recovery is to restore database integrity.

narendra05

 Profile Answers by narendra05 

• Apr 23rd, 2010

 

Recovery is method of making the database consitent.  The database keeps this by way of SCN in headrer of all the datafile and controlfile. In case the SCN on datafile and controlfile database throws as exception. Media recovery is a two step process of restoring the backups / archivelogs and applying the same to corrupted datafiles in sequential manner. Media recovery can be done using SQLPlus or with RMAN.

Thanks
Narendra