Errors and failures in Database

ashlee · #1 (**permalink**) 03-09-2007, 03:41 PM

What are the errors and failures that can occur normally in Oracle database for which recovery procedure must be well planned by database administrator of oracle?

rachelle · #2 (**permalink**) 05-05-2007, 09:36 AM

An Oracle database can meet different types of errors and failures at various instances. To mention few are:
Failure due to an SQL statement issued by a user, which might have occurred due to incorrect handling of statement. Such failures would be automatically handled by oracle.
Some failures due to hardware problems which can occur normally unplanned like power failures. Such failures cause oracle database to stops functioning and no data is written by oracle database.

Adrian · #3 (**permalink**) 05-05-2007, 10:49 AM

Not only hardware failures but also due to problems in software used there is possibility of hand up of operating system which prevents oracle database to proceed further from writing. There may also be instances of failures in oracle database where a particular user process alone terminates due to some problem which allows the other users to proceed and function normally.