Define redo logs, Database Management System

 

 Redo Logs:Any database must have minimum two redo logs. These are the rules for the database; the redo logs record all modifies to the system objects or user objects. If any type of failure happens, modifies recorded in the redo logs may be used to bring the database to a proper state without losing any committed operations. In the case of non-data loss failure, Oracle may accept the information in the redo logs automatically without intervention from the DBA. The redo log files are fixed in shape and size and never show dynamically from the size at which they were prepared.

 

Posted Date: 7/30/2012 3:10:35 AM | Location : United States







Related Discussions:- Define redo logs, Assignment Help, Ask Question on Define redo logs, Get Answer, Expert's Help, Define redo logs Discussions

Write discussion on Define redo logs
Your posts are moderated
Related Questions
Do the 11.1 11.1 Credit Card Use. Consider the following hypothetical bank data on consumers’ use of credit card credit facilities in Table 11.3. Create a small worksheet in Exce

What is an E-R model? Draw an E-R Diagram for the company database with following Descriptions? The company is organized within departments. Each department has a unique name a

Table_Name( attribute_1, attribute_2, attribute_3, ….. ,attribute_x) Primary Key ( attribute_1, attribute_2) Foreign Key attribute_4 References Table_Name_2 (repeat for each fore

#quesDefine a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pi

Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i

State the data flow diagram of functional model Any action initiated by transition in the state diagram can be extended into an entire data flow diagram in functional model. Th

What are the various properties of Relational tables? Relational tables have 6 properties: 1. Each row is unique. 2. Column values are of the same kind. 3. Values are

Question : Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriente

Describe Interfaces for the DBA? Interfaces for the DBA - Most database systems holds privileged commands which could be used only through the DBA's staff. These involves com

The Update Operations : Update operations are used for altering database values. The constraint violations faced by this operation are logically the similar as the problem faced