DIPTENDU HUI

• Jan 29th, 2006

 

Control File contains

1) Name and location of all Datafiles.
2)Name and location of all redolog files.
3)Current log sequence Number.

Aruna

• Mar 3rd, 2006

 

Controlfile contains

• name and id of database
• time stamp of database creation
• names and location of datafiles
• names of tablespaces
• current SCN number
• current LSN number
• Checkoint information
• Backup

nagabhushan reddy

 Profile Answers by nagabhushan reddy 

• Mar 7th, 2006

 

control file is a binary file

which having information 1.database name

2.database creation

3.checkpoint information

4.no of datafiles

5.redolog files

Mohammed Abdul Afroze

• Sep 20th, 2007

 

The controlfile contains :

1. Name and Location of Datafiles, Redo Logfiles.
2. Timestamp of Database Creation.
3. Current log sequence number is recorded when log switches are occur.
4. Checkpoint information is recorded as checkpoints are made.
5. Database identifier is recorded when the database is created.