siddhant

• Feb 22nd, 2006

 

diff bitween media recovery crash recovery

Arock Lincy.R

• Feb 23rd, 2006

 

 what is the difference between media recovery & crash recovery?

ritish

• Feb 24th, 2006

 

Media recovery: is related to disc failure...

crash recovery:- Is related to instance recovery.which is automatically done by  SMON background process.

i hope im able to clear your doubts

KS

• Mar 2nd, 2006

 

Datafile media recovery or media recovery is used when we need to recover datafile, controlfile or spfiles( server parameter file).Crash recovery is the recovery of a database in a single-instance configuration or an Oracle Real Application Clusters configuration in which all instances have crashed.Like crash recovery Oracle will not initiate media recovery on its own, it must be demanded by a DBA only.

Paresh Sarma

• Apr 5th, 2006

 

Media recovery is a process to recover database from backup when  physical disk failure occure.

cash recovery is a automated process take care by oracle when instance failure occure.

sabita

• Jul 8th, 2006

 

Media Recovery means disk failure, in other way loss of physcial file which has to be taken care by Oracle DBA

but Crash Recovery means Instance recovery which is done automatically by SMON background process

jiawei wang

• Jul 13th, 2006

 

media failture involves a physical when reading from  or writing to a file that is necessary fo the database to operate. media failure is the  most serious type of failure and dba intervention requires.
To recover database depends on the following:
.backup method you choose and which files are affected.
.the arechivelog mode of operation of the database. if archiving is used you can apply archived redo log files to recover committed data since the last backup. if you are using rman, you can also apply incremental backups.
instance failure:
.power outage
.hardware problems
.background processes
startup instance---- the oracel server will automatically recover, performing both the roll forward and roll back phases.
investigates the cause of failure by reading the alert log and any other trace files that were generated during the instance fuilure.

shabirwani

 Profile 

• Sep 17th, 2006

 

oracle never accepts the inconsistency of the database. so when oracle goes down due to power outage or aborted manually, next time once the database base is opened it goes mainly to the three states nomount,mount,and open when oracle try to open the database it makes check of SCN in the controlfile and each database datafile header if the check is not correct it will try to perform crash recovery and apply the online redo logs to bring the database in consistent state. By any means if it could not apply then it will try to locate the archive logs to apply and asks for media recovery.  

hemant

• Oct 23rd, 2007

 

The basic diff between the media and crash recovery is that , media recovery is performed by the user or dba with the helps of backups while the crash recovery is performed by the oracle itself by using his sman background process.