totally there are 6 files(components) of physical database structure.3 mandatory & 3 optional.Three mandatory files are :1> datafile : store actual data 2> control file : strores stuctural & status information of database.3> redolog file : stores changed/committed dataThree optional files are :4> parameter file : strores all size related parameters note : this file is mandatory for a1st time u create a database, then it is optional. 5> archivelog file : its offline copy of redolog files6> password file : used to make normal user to behave as a super user.Best Of Luck,Questions & Doubts are most welcome.By Nishit Patel.mailid : nishitptl@yahoo.co.in
RE: What are the components of physical database structure of Oracle database
totally there are 6 files(components) of physical database structure.3 mandatory & 3 optional.Three mandatory files are :1> datafile : store actual data 2> control file : strores stuctural & status information of database.3> redolog file : stores changed/committed dataThree optional files are :4> parameter file : strores all size related parameters note : this file is mandatory for a1st time u create a database then it is optional. 5> archivelog file : its offline copy of redolog files6> password file : used to make normal user to behave as a super user.Best Of Luck Questions & Doubts are most welcome.By Nishit Patel.mailid : nishitptl@yahoo.co.in
RE: What are the components of physical database structure of Oracle database
physical components of oracle database are control files redo log files and datafiles.
Control file: control file is read in the mount state of database. control file is a small binary file which records the physical structure of database which includes
database name
names and locations of datafiles and online redo log files.
timestamp of database creation
check point information
current log sequence number.
Redo log files: This files saves all the changes that are made to the database as they occur. This plays a great role in the database recovery.
Datafiles:datafiles are the physicalfiles which stores data of all logical structure.
RE: What are the components of physical database struc...
The components are
Data files Redo log files Control files Data files are used to store all the database objects which are administered by the oracle system. Redo log files contain records of all database changes which are carried out in the course of transactions Control files record information about physical structure of database
RE: What are the components of physical database structure of Oracle database
The database when made in oracle 10g consists a minimum of ----Two datafiles on the two manadatory tablespaces system and sysaux ----Control file multiplexed or not (Oracle recommends three) ----two online redolog files with atleast one member each.
Apart from the physical componenets mentioned above orcale database also consists of ---password file ---parameter file and or spfile ---and other datafiles depending on the application.
RE: What are the components of physical database structure of Oracle database
The physical components of the database consists of Datafiles -- which contains the actual data of the database and minimum two datafiles are must in a database Redo log files -- which contains the latest transaction in the database and minimum two redo log files are must in a database Control files -- which contains the valuable information of the database which includes database name SCN number location of datafiles location of redo log files