| |
GeekInterview.com > Interview Questions > Oracle > Backup and Recovery
| Print | |
Question: what is the difference between media recovery & crash recovery..?
|
| July 07, 2006 10:03:00 |
#7 |
| jiawei wang |
Member Since: Visitor Total Comments: N/A |
RE: what is the difference between media recovery & cr...
|
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. |
| |
Back To Question | |
