CONTROL FILE in ORACLE-SAP
CONTROL FILE and its Functions in ORACLE-SAP...
Control file is a small binary file which is necessary for the database to start and operate successfully.
Functions of control file :
Each control file is associated with only one database. Oracle continuously updates control file during database use so this file must be available for writing whenever the database is in the
Contents of control files :
Control file contains information such as :-
Database name
Timestamp of database creation
Tablespace information
The log history
Archive log information
Current log sequence number
Checkpoint information
Names and locations of associated datafiles and redolog files
Datafile copy information
Datafile offline ranges
Backup set and backup related information
Backup datafile and redolog information
Best Regards,
JUNAID AHMAD
CONTROL FILE and its Functions in ORACLE-SAP...
What is control file in Oracle and what are its functions :
Control file is a small binary file which is necessary for the database to start and operate
successfully.
Functions of control file :
Each control file is associated with only one database. Oracle continuosly updates control file
during database use so this file must be available for writing whenever the database is in the
Contents of control files :
Control file contains information such as
Database name
Timestamp of database creation
Tablespace information
The log history
Archive log information
Current log sequence number
Checkpoint information
Names and locations of associated datafiles and redolog files
Datafile copy information
Datafile offline ranges
Backup set and backup related information
Backup datafile and redolog information
Best Regards,
JUNAID AHMAD
No comments:
Post a Comment