Oracle Database Administration (DBA): Oracle 10g, 11g : tutorials, articles, tips, scripts, documentation

Real Application Cluster (RAC)

Maintenance tasks

Backup and Recovery

Database Architecture

Replication

Oracle Performance Tuning

Oracle DBA - Other articles

Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

Oracle Database Administration (DBA): Oracle 10g, 11g

There are many people who ask "What a DBA or a database administrator is ?". Well, a DBA is a person who has to install the database, to assure the database maintenance, to take backup/ restore the database, to perform the tuning of the database and to apply the latest DB patches. And this is not all, but generally that's it. In IT, the tasks cover a larger domain. Sometimes a DBA can work as a data architect, sometimes as a technical architect (if he/ she has in deep experience with the Oracle technologies). To became a technical architect, it is a good start to be/ became a DBA. All the Oracle technologies are working with the Oracle database. There are some exception if we look at the latest Oracle acquisitions (related to the Sun acquisition for instance). Generally speaking, the DBA experience could help you a lot in understanding the Oracle technologies.

Oracle says that the following tasks represent (but not limited to) the main DBA tasks:

             Task 1: Evaluate the Database Server Hardware
             Task 2: Install the Oracle Software
             Task 3: Plan the Database
             Task 4: Create and Open the Database
             Task 5: Back Up the Database
             Task 6: Enroll System Users
             Task 7: Implement the Database Design
             Task 8: Back Up the Fully Functional Database
             Task 9: Tune Database Performance

Click here for more information

Here are some articles related to the Oracle database administration you may be interested on:

Oracle Managed Files (OMF) Oracle OFA : Oracle Optimal Flexible Architecture

Oracle 11g Installation on Windows Oracle RAC Architecture

Oracle Performance Tuning Oracle Execution Plan : Explain plan

Oracle Database Failover and Switchover Oracle Physical Standby Database

Replicate a table with Oracle Streams Oracle Physical Standby Database (RMAN)

In-Oracle.com

-> Oracle DBA