Oracle Database Physical File Structure-
1. Data files -
Each tablespace in an Oracle database consists of one or more files called datafiles.
Note : - (All tablespace having there datafiles is depends upon the tablespace required size.)
2. Redo log files -
Redo log is used for recovery a database after Failures like hardware, software, or media failure.
Note :- (Minimum 2 redo log groups with one member in each group, Oracle recommanded 3 redo log groups with 2 members with multiplexing.)
3. Control files -
Control file is a small binary file that records the physical structure of the database.
The control file includes:
1. The database name.
2. Names and locations of associated datafiles and redo log files.
3. The timestamp of the database creation.
4. The current redo log sequence number.
5. Checkpoint information.
Note :- (Minimum 2 controlfiles are required to run a database, Oracle recommanded 3 controlfiles with multiplexing.)
Thanks
DB Tech Solutions
1. Data files -
Each tablespace in an Oracle database consists of one or more files called datafiles.
Note : - (All tablespace having there datafiles is depends upon the tablespace required size.)
2. Redo log files -
Redo log is used for recovery a database after Failures like hardware, software, or media failure.
Note :- (Minimum 2 redo log groups with one member in each group, Oracle recommanded 3 redo log groups with 2 members with multiplexing.)
3. Control files -
Control file is a small binary file that records the physical structure of the database.
The control file includes:
1. The database name.
2. Names and locations of associated datafiles and redo log files.
3. The timestamp of the database creation.
4. The current redo log sequence number.
5. Checkpoint information.
Note :- (Minimum 2 controlfiles are required to run a database, Oracle recommanded 3 controlfiles with multiplexing.)
Thanks
DB Tech Solutions
