Define control files, Database Management System

Control Files :The redo and control files logs support the rest of the architecture. Every database must have at least one control file, although you have more than one to guard against replace. The control file records the name of the dataset, the time and date it was prepared, the location of the redoes logs and database, and the synchronization information to confirm that all three groups of files are always in step. Each time you include a new redo log file or database to the database, the information is recorded in the control files.

 

82_control files.png

Posted Date: 7/30/2012 3:09:57 AM | Location : United States







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

Write discussion on Define control files
Your posts are moderated
Related Questions
Explain the Management of Data Store Every system irrespective of its nature of application requires storing permanent data for consequent use in problem solving. Some objects

We have a buildup of payments that need to be processed. You will need:- To prepare customer account on our site Process payment (you must have working Paypal account to d

Hardware failure :  Hardware failures are the failures when some disk or hardware chip fails. This may result in loss of data. One such trouble can be that a disk gets damaged and

Question : (a) Data mining is one of the best ways to analyse data and using software method, hidden and unexpected patterns and relationships in sets of data can be extracte

During the deletion of a tuple two cases can happen: Deletion of tuple in relation having the foreign key: In this type of case simply delete the desired tuple. For example, in

List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view

Let us now talk about the relational operations: SELECT The select operation is used to select few specific record from the database based on different criteria, This is a un

Importance Of File Organisation In Database To execute a database efficiently, there are various design tradeoffs needed. One of the most vital ones is the file Organisation. F

Question 1 Draw a Data Flow Diagram for a University scenario Question 2 Discuss the following with suitable examples Relational Algebra Operators Database Pla

Durability : This property necessitates that once a transaction has committed, the changes made by it be never lost because of subsequent failure. Thus, a transaction is also a bas