Database Administration Interview Question:

Explain What does a control file contains?

Submitted by: Administrator

information about the database,redologfile and datafile,archivelog file location and current scn no
and redo log file

1. Database name and identifier.
2. Time stamp of database creation.
3. Tablespace names.
4. Backup information.
5. Checkpoint information.
6. Current online redo log file sequence numbe
Submitted by: Administrator