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. Click on the above link to read more and to become a Oracle DBA.

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 Click on the above link to read more and to become a Oracle DBA.

Archive Log Files

When Oracle DBA archive your redo log, you write redo log files to another medium location prior to their being overwritten. Click on the above link to read more and to become a Oracle DBA.

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. Click on the above link to read more and to become a Oracle DBA.

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 Click on the above link to read more and to become a Oracle DBA.

Initialization Parameter File

Initialization parameters are used by the database server initially at startup to determine the runtime resources for the database. Click on the above link to read more and to become a Oracle DBA.

Password File

A database might use a password file to authenticate administrative users who can have SYSDBA connect privileges. Click on the above link to read more and to become a Oracle DBA.

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. Click on the above link to read more and to become a Oracle DBA.

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 Click on the above link to read more and to become a Oracle DBA.

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. Click on the above link to read more and to become a Oracle DBA.

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. Click on the above link to read more and to become a Oracle DBA.

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. Click on the above link to read more and to become a Oracle DBA.

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. Click on the above link to read more and to become a Oracle DBA.

More Tutorials on Oracle dba ...

Liked it ? Want to share it ? Social Bookmarking