RE: what is the difference between a system crash and a media failure?
system crash in the sense the whole instance along with redologs and archieves are lost and the next one media failure comes when the recovery what ever we do is not completed.....
RE: what is the difference between a system crash and a media failure?
According to me , system crash should be related with either software /O.s corruption . where as media failure should be something what previously said , corruption of archive logs and other logs etc.
RE: what is the difference between a system crash and a media failure?
A system crash is when an operating system or an application fails corrupting or deleting database objects or the database itself. Media failure is when the hardware that houses the database fails ie: hard disk failure.
RE: what is the difference between a system crash and a media failure?
In simple terminology, combination of S/w(Operating system et all) and hardware(Disk Drives) on which these S/W(OS) are loaded, are vital for smooth runing of system. Failure of any of these tools make a system to crash. now if any software(OS) fails it is called System failure or System Crash, and if hardware (Hard Disk) fails it is called media failure.
