Database failures can be divided into two general categories: media failures and nonmedia failures.
Media failures, the more serious type, occur when a server hardware component fails and the contents of one or more disk files are either unreadable or corrupted. The DBA is solely responsible for recovering from this type of failure by restoring the unreadable or corrupted file from a tape or disk backup. The DBA can perform the recovery process using one of the tools described in this.
Media Failure A type of database failure where a server hardware component fails and the contents of one or more disk files are either unreadable or corrupted.
Nonmedia Failure A type of database failure that is not related to a server disk-related hardware component and is one of several types: statement failure, process failure, instance failure, or user error.
Nonmedia failures are all other types of failures, including the following:
Statement failure The SQL statement being executed has a syntax error or the user executing the statement has the wrong permissions. Recovery from a statement failure is generally simple: Rerun the SQL statement with the right syntax or obtain the proper permissions on the objects in the query, and then rerun the query.
Process failure The user may be disconnected from the database due to a network problem or because a resource limit was exceeded. One of the Oracle background processes automatically cleans up the terminated process by freeing the memory used by the process.
Instance failure The entire database instance fails due to a power outage, a server memory problem, or a bug in the Oracle software. When the database instance is restarted, Oracle uses the redo log files to make sure that all committed transactions are recorded properly in the database datafiles.
User error A user may drop a table or delete rows from a table unintentionally.
In the following sections, we'll cover the processes used by DBAs and users to recover from the two types of errors that Oracle cannot handle automatically: media failures and user errors.
Oracle DBA Related Interview Questions
|Oracle 10g Interview Questions||Oracle 9i Interview Questions|
|Oracle 8i Interview Questions||Oracle 11g Interview Questions|
|Oracle apps Interview Questions||Oracle Apps ERP Interview Questions|
|Oracle 7.3 Interview Questions||Oracle ADF Interview Questions|
|Oracle Application Framework Interview Questions||Oracle Apps Functional Interview Questions|
|Oracle Apps DBA Interview Questions||Oracle Workflow Interview Questions|
Oracle Dba Tutorial
Relational Database Concepts
Sql*plus And Isql*plus Basics
Oracle Database Functions
Restricting, Sorting, And Grouping Data
Using Multiple Tables
Advanced Sql Queries
Installing Oracle And Creating A Database
Creating And Maintaining Database Objects
Users And Security
Making Things Run Fast (enough)
Saving Your Stuff (backups)
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.