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
