There are six general categories for database related failures.
Statement Failures occur when a single database operation fails, such as insert, delete statment.
User Process Failures happen when the abnormal termination of a user session, any uncommited transaction must be cleaned up
Network Failures can be found when the hardware failures between the server and client. It also includes a listener process fails on Oracle server.
User Error Failures when the operation's result is not what the user intended even there is no error message generated, such as delete or modify data or drop an index.
Instance Failues occurs when the instance shuts down without synchronizing all the database files to the same system change number.
Media Failures that are any type of failure that results in the loss of one or more database files.
No comments:
Post a Comment