Sunday, March 5, 2017

1-oracle architecture - control files



Control Files
its disk file, binary file
if you loose control files database is lost , its best to keep multiple copies of control files(multiplexing)
stores meta data eg. database creation date,
tracks physical components of db, gives answer - thats where my database is
name and location of datafiles ,online redo, time db is created, checkpoints etc.
imp: Backup your control files

Datafiles
physica os/binary file that stores actual data, 1 + more DataFile = table space


Tablespace is logical container for segments, and physically composed of multiple datafiles

Segment is made up of multiple extents ,objects(table, indexes),--extents are grouped together to form segment

Extents is made up of blocks

OnlineRedoLog - recovery method, it is physical file that stores changes made to db, readback the db changes and recover the db changes in the event of crash. archiving redo means copying the redo log to remote machine before its overwritten

parameter file - stores initialization parameters, server info -- num of process, how many process, memory,open cursors, db name, dump location ,user and system dumps etc. some can be changed online and some require restart

password file - stores SYSDBA user info , any user with sysdba grants have entry in this file

Fast Recovery Area - or flash recovery area,  is disk location that does management of backup related files
it basically simplifies db administration, speeds up rman backup ,holds backups, archived redo

AlertLog - stores error and exception messages, this is the first place to look when errors occur

Trace Files- diagonistic files. tool for query tuning, find what is running ,trace session
server and user process write to this file

ASM -automatic storage management
- LVM for oracle
- does striping and raid 10

Grid - G in 11g and 10g
-pools multiple resources and servers into on demand resource
- RAC enable multiple db instances to share a single database, so multiple servers accessing same data files
- Clusterware enable fault tolerance ,performance make multiple server act as single

Cloud backups - oracle secure backup cloud module
allow backups to S3




No comments:

Post a Comment