The control file is a small binary file necessary for the database to start and operate successfully. Control file records the physical structure of the database.Each control file is associated with only one Oracle database. Before a database is opened, the control file is read to determine if the database is in a valid state to use.The information in the control file can be modified only by the Oracle server.The information in the control file includes:
- Database name
- Names and locations of associated datafiles and online redo log files
- The timestamp of database creation
- Current log sequence number
- Checkpoint information
- Tablespace information
- Datafile offline ranges
- Redo log history
- Archived log information
- RMAN information means (database backup taken through RMAN)
- Datafile copy information.
1 comments:
The control file is very important and small binary file which is very necessary for the database to start and operate successfully.
sap migration
Post a Comment