nishit patel

• Mar 12th, 2005

 

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

Jacob

• Jul 9th, 2005

 

ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files.

Taral Desai

• Sep 2nd, 2005

 

1. control files 
2. init file 
3 log files 
4 redo/archive log files 
5 data files 

shalini

• Sep 12th, 2005

 

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.

cmanne

 Profile Answers by cmanne 

• Jan 4th, 2006

 

1. Data files2. Redolog files3. Control File4. init.ora file

monanathan87

 Profile Answers by monanathan87 

• Jan 4th, 2007

 

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

RAVI

• Jan 8th, 2007

 

Components of Physical database are:-

1. Datafile -- One or more

2. Redo log file -- Two or more

3. Control File --- Two or more

Thanks

txrob00

 Profile Answers by txrob00 

• Jan 25th, 2008

 

What are the components of physical database structure of Oracle database

kssatya.69

 Profile Answers by kssatya.69 

• Jan 28th, 2008

 

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.

g.mrunalini

 Profile Answers by g.mrunalini 

• Feb 12th, 2008

 

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

anjali08

 Profile Answers by anjali08 

• Feb 13th, 2008

 

datafile,control file and redo logs

rajat_dua

 Profile Answers by rajat_dua 

• Mar 3rd, 2009

 

Components of Physical database are:-

1. Datafile -?One or more
2. Redo log file - Two or more
3. Control File -?Two or more

premk

 Profile Answers by premk 

• Dec 22nd, 2009

 

The physical structure of ORACLE database consists of three major components.
They are:
1. control files
2. redo log files
3. data files

rajesh.dba9i

 Profile Answers by rajesh.dba9i 

• Feb 16th, 2010

 

Datafiles, Controlfile and online redo log file.

dj_dj_dj

 Profile Answers by dj_dj_dj 

• Feb 18th, 2010

 

Dear, 


           Oracle Physical Database Structure consist of Datafiles, Controlfile  & Online Redo Log files.

           Logical Structure consist of Tablespaces and its components inclusive of tables.


Regards
Dharmedra Jaiswal.

vanithaananth

 Profile Answers by vanithaananth 

• Jun 24th, 2011

 

physical structures of oracle database consists of datafiles,controlfiles redologfiles and archivelogfiles...