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
What is Cardinality Ratio? Cardinality Ratios - The cardinality ratios for relationship kinds specifies the maximum number of relationship instances in which an entity can pa

entity relationship diagram for online examination system

Compare the Nested-loop join and block-nested loop join Ans: Nested  loop join - It is costly as worst case cost, no. of block accesses needed is n r * b s + b r   where b

Define Single Value and Multivalued attribute Single value attribute comprise a single atomic value for an entity and multivalued attribute may have much more than one value f

Define data model? A data model is a collection of conceptual tools for explaining data, data relationships, data semantics and consistency constraints.

Question 1 What is data mining? Write Data Mining applications Question 2 What is OLAP? Write the benefits of OLAP Question 3 What is Business Intelligence? Explai

An entity set that does not have sufficient attributes to form a primary key is called? An entity set that doesn't have sufficient attribute to form a primary key is known as w

What are the drawbacks of shadow-paging technique? The drawbacks of shadow paging is:- a) Commit Overhead b) Data fragmentation c)  Garbage collection

Record based Logical Models: Use records as the key data representation components Examples: Relational Model: It shows data as well as relationship between data in the form

The following relational database schema represents part of a simplified database used by a library: tblBook (BookID, Title, PublisherID, Category,Price) tblPublisher (Publishe