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
What Is Sql?  Structured Query Language (SQL) is a standard query language. It is usually used with all relational databases for data manipulation and definition. All the re

How does the two phase protocol ensure serializability in database schedules?   Ans:  A transaction is termed to follow the two-phase locking protocol if all locking operations

How is concurrency identified? Concurrency in objects can be identified by the way they alter their state. Current objects can change their state independently. Aggregation imp


A video rental company has several branches. The data held on each branch is the branch address made up of street, city, state, and zip code, and the telephone number. Ea

Primary Index In primary index, there is a one-to-one relationship among the entries in the index table and the records in the major table. Primary index can be of two types:

List the requirements needed to design a trigger. The requirements are:- Specifying when a trigger is to be implemented. State the actions to be taken when the trigger im

Example:  //REVOKE ALL ON EMP FROM MCA12;                              (All permissions will be cancelled) You can also cancel only some of the permissions. Drop: A user-

discuss the array implementation of a stack.

Consider an information system designed for an online company which provides IT products and services These include desktops, laptops, networking products, IT books, parts, and