GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Database Administration

 Print  |  
Question:  What are the components of physical database structure of Oracle database



September 09, 2005 17:56:22 #4
 shalini   Member Since: Visitor    Total Comments: N/A 

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.

     

 

Back To Question