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

In object oriented design, which steps must designer take to adjust inheritance? To readjust inheritance following steps should be taken: i)  Rearrange and adjust the classe

Question: (a) List four disadvantages of the File Processing System as compared to the Database Systems. (b) The integrity of a database is enforced by integrity rules. One

Describe queries with complex types? The present extension of the SQL query language deal with the complex type Let us start with the simple example: Find the title and t

Define Deadlock detection If a system does not employ a few protocols that make sure deadlock freedom, after that a detection and recovery scheme should be used. An algorithm

Explain the B + tree? B + tree is a type of tree which denotes sorted data in a way that permits for efficient insertion, retrieval and removal of records, each of which is

What is aggregate function? Briefly describe it? Aggregate functions are functions that take a collection of values as input and return a one value. SQL offers 5 built-in aggre

Define Atom of domain relational calculus An atom has the outline 1 , x 2 , ... , x n > -> r , in which r stands for a relation on n attributes and x 1 , x 2 , ... , x n ar

Explain the Project-Join normal form A relation R is in PJNF along with respect to a set of functional dependencies D if for all join dependencies of the outline *(R 1 , R 2 ,

It can be easily defined as: The database must not have any unmatched foreign key values. The term "unmatched foreign key value" means a foreign key value for which there doe