Getting Started DB 11g - Oracle Instance Overview

Oracle Instance Overview

An Oracle database system consists of an Oracle database and an Oracle instance.


A database consists of a set of disk files that store user data and metadata.
Metadata consists of structural, configuration, and control information about the database.

An Oracle instance (or database instance) contains the set of Oracle background processes and a shared memory for them (System Global Area SGA)

Getting Started DB 11g - Basic Definitions

The Oracle Database Administrator

The Oracle DB Administrator (DBA) is the one who is responsible for the overall operation of Oracle Database. In this chapter Oracle describe common DBA tasks and tools. This chapter contains the following sections:

Database Backup - Your First Approach

-- This Article describe the actual steps done in order to backup a database
-- These are the most basic manual steps but also the most effective

-- The most basic steps are the following
 -- 1. Change database to work in ARCHIVE LOG mode
 -- 2. Perform a full backup for first time from OS
 -- 3. Create rman catalog database, register your database
 -- 4. Backup your database FULL Backup monthly, Incremental levle 0 weekly, Incremental levle 1 daily

-- Here are the actual steps