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
(a)    Provide the description of the following ODMG schema in the Object Definition Language (ODL). (b)   Based on the above object database, write the following queries i

What is DML Query Langauge? Data Manipulation Language (DML) - A data manipulation language is a language in which enables users to access or manipulate data as organized throu

Which data manipulation command combines the records from one or more tables ? JOIN data manipulation command combines the records from one or more tables.

Create Student DB and perform delete operation? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, co

what is cascading? what is rollback cascading? please explain in detail

Describe the iterative and incremental life cycle For an iterative and incremental life cycle, two criteria are process and time. The main components of showing a project devel

give some example real life situation where DBMS are most suitable

Project: Microsoft Access You have been asked by the ABC Tanning Salon to create a database that can be used to track the salon's customers.  You are to create a table in Access

When are two schedules said to be view equivalent?     Ans: Two schedules that is denoted as S and S' are said to be view equivalent if the subsequent three conditions are met

The Transactions- A transaction is definite as the unit of work in a database system. Database systems that deal with a huge number of transactions are also termed as transaction p