learn-oracle




Database Storage Structures


The Control File

A control file tracks the physical components of the database and other control information. It is essential to the functioning of the database.
Redo Log Files

Every Oracle database has a set of two or more redo log files. The set of redo log files is collectively known as the redo log for the database .
 
Archive Log Files

When Oracle DBA archive your redo log, you write redo log files to another medium location prior to their being overwritten.Read on to know more about Arhive Log files .
Tablespaces

A database consists of one or more tablespaces. A tablespace is a logical structure, or container, created by and known only to the Oracle database server in which database objects are stored.
 
Datafiles

Datafiles are the operating system files that hold the data within the database. The data is written to these files in an Oracle proprietary format that cannot be read by programs other than the database server
Initialization Parameter File

Initialization parameters are used by the database server initially at startup to determine the runtime resources for the database.
Password File

A database might use a password file to authenticate administrative users who can have SYSDBA connect privileges.
Backup Files

Backup files are technically not database files, but rather copies of the database in some form that can be used to recover the database should a failure causing loss of data occur.
Viewing Tablespaces in your Database

Oracle DBA can see all tablespaces in your database. From the Administration page, click Tablespaces under Storage. This takes you to the Tablespaces page
Creating a Tablespace

A particular user, groups of users, or an application may require its own tablespace for creating schema objects, rather than using the default USER tablespace. To create a tablespace, follow the steps listed in this section.
Modifying a Tablespace

With Enterprise Manager, Oracle DBA can modify a tablespace, such as extend it, set it to automatically extend, change its space thresholds, or change its status to offline.
Dropping a Tablespace

After a tablespace has been dropped, the objects and data in it will no longer be available. To recover them can be a time consuming process. Oracle recommends a backup before and after dropping a tablespace.
Managing Undo for Your Database

This section discusses undo management which involves storing the changes of database transactions long enough to accommodate rollback, read consistency, and flashback features.

More Tutorials on Oracle dba ...


Liked it ? Want to share it ? Social Bookmarking

Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information


Source : Website | Oracle DBA

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info





   Forum
Oracle Forum   
Google

Oracle DBA Tutorial
Introduction
Installation
Oracle Enterprise Manager
Configuring client/server network
Database Instance
Database Storage Structures
DBA Accounts
Managing Oracle Objects
Backup & Recovery Concepts
Database Monitoring

SQL Statement Tuning
Backup and Recovery Concepts
Oracle 11g New Features
Oracle E Suite & Others
Oracle Data Guard
Oracle DBA FAQ