Oracle Database 10g: Administration Workshop I

grrrgrapeInternet και Εφαρμογές Web

31 Οκτ 2013 (πριν από 3 χρόνια και 9 μήνες)

96 εμφανίσεις

Copyright © 2005, Oracle. All rights reserved.

Introduction

Copyright © 2005, Oracle. All rights reserved.

1
-
2

Course Objectives

After completing this course, you should be able to do
the following:


Install, create, and administer Oracle Database 10
g


Configure the database for an application


Employ basic monitoring procedures


Implement a backup and recovery strategy


Move data between databases and files

Copyright © 2005, Oracle. All rights reserved.

1
-
3

Suggested Schedule

1.

Introduction

2.

Installation

3.

DB Creation

4.

Instance


5.

Storage

6.

Users

7.

Schema

8.

Data & Concurrency


9.

Undo

10.

Security

11.

Network

12.

Proactive Maintenance

13.

Performance

14.

Backup & Recovery
Concepts

15.

Backup


16.

Recovery

17.

Flashback

18.

Moving Data

Copyright © 2005, Oracle. All rights reserved.

1
-
4

Lesson Objectives

After completing this lesson, you should be able to do
the following:


Describe the course objectives


Explain the Oracle Database 10
g

architecture

Copyright © 2005, Oracle. All rights reserved.

1
-
5

Oracle Products and Services


Oracle databases


Oracle Application Server


Oracle applications


Oracle Collaboration Suite


Oracle Developer Suite


Oracle services

Copyright © 2005, Oracle. All rights reserved.

1
-
6

Oracle Database 10
g
:


g
” Stands for Grid


Global Grid Forum (GGF)


Oracle’s grid infrastructure:


Low cost


High quality of service


Easy to manage

Automatic

Storage

Management

Real

Application

Clusters

Oracle

Streams

Enterprise

Manager

Grid Control

Storage

grid

Database

grid

Application

grid

Grid

control

Copyright © 2005, Oracle. All rights reserved.

1
-
8

Oracle Database Architecture

An Oracle server:


Is a database management system that provides
an open, comprehensive, integrated approach to
information management


Consists of an
Oracle instance

and an
Oracle
database

Copyright © 2005, Oracle. All rights reserved.

1
-
9

Database Structures

Storage structures

Memory structures

Process structures

Instance

System Global Area (SGA)

Background processes

Database files

DB structures


-

Memory


-

Process


-

Storage

Copyright © 2005, Oracle. All rights reserved.

1
-
10

Oracle Memory Structures
.

Java pool

Database

buffer cache

Redo log

buffer

Shared pool

Large pool

SGA

Streams pool

Server

process

1

PGA

Server

process

2

PGA

Background

process

PGA

DB structures

>

Memory


Process


Storage

Copyright © 2005, Oracle. All rights reserved.

1
-
12

Process Structures


User process:

Is started at the time a database
user requests a connection to the Oracle server


Server process:

Connects to the Oracle instance
and is started when a user establishes a session


Background processes:

Are started when an
Oracle instance is started

Instance

SGA

Background

processes

Server

process

PGA

User process

DB structures


Memory

>

Process


Storage

Copyright © 2005, Oracle. All rights reserved.

1
-
13

Oracle Instance Management

System

Monitor

(SMON)

Database

Writer

(DBW
n
)

LogWriter

(LGWR)

Process

Monitor

(PMON)

Archiver

(ARC
n
)

SGA

Java pool

Shared pool

Large pool

Streams pool

Database

buffer cache

Redo log

buffer

Checkpoint

(CKPT)

Control

files

Data

files

Redo log

files

Archive

log files

Copyright © 2005, Oracle. All rights reserved.

1
-
14

Server Process and Database

Buffer Cache

Buffers:


Pinned


Clean


Free or
unused


Dirty

DBW
n

Server

process

SGA

Database

buffer cache

Data files

Copyright © 2005, Oracle. All rights reserved.

1
-
15

Physical Database Structure
.

Online redo log files

Password file

Parameter file

Archive log files

Control files

Data files

Alert and trace log files

Backup files

DB structures


Memory


Process

>

Storage

Copyright © 2005, Oracle. All rights reserved.

1
-
17

Tablespaces and Data Files


Tablespaces consist of one or more data files.


Data files belong to only one tablespace.

USERS

tablespace

Data file 1

Data file 2

Copyright © 2005, Oracle. All rights reserved.

1
-
18

SYSTEM

and
SYSAUX

Tablespaces


The
SYSTEM

and
SYSAUX

tablespaces are
mandatory tablespaces.


They are created at the time of database creation.


They must be online.


The
SYSTEM

tablespace is used for core
functionality (for example, data dictionary tables).


The auxiliary
SYSAUX

tablespace is used for
additional database components (such as the
Enterprise Manager Repository).

Copyright © 2005, Oracle. All rights reserved.

1
-
19

Segments, Extents, and Blocks


Segments exist within a tablespace.


Segments are made up of a collection of extents.


Extents are a collection of data blocks.


Data blocks are mapped to disk blocks.

Segment

Extents

Data
blocks

Disk
blocks

Copyright © 2005, Oracle. All rights reserved.

1
-
20

Logical and Physical Database Structures

Database

Logical

Physical

Tablespace

Data file

OS block

Segment

Extent

Oracle data

block

Schema

Copyright © 2005, Oracle. All rights reserved.

1
-
22

Course Examples: The
HR

Schema

REGIONS

REGION_ID (PK)

REGION_NAME

COUNTRIES

COUNTRY_ID (PK)

COUNTRY_NAME

REGION_ID (FK)

LOCATIONS

LOCATION_ID (PK)

STREET_ADDRESS

POSTAL_CODE

CITY

STATE_PROVINCE

COUNTRY_ID (FK)

DEPARTMENTS

DEPARTMENT_ID (PK)

DEPARTMENT_NAME

MANAGER_ID

LOCATION_ID (FK)

JOBS

JOB_ID (PK)

JOB_TITLE

MIN_SALARY

MAX_SALARY

EMPLOYEES

EMPLOYEE_ID (PK)

FIRST_NAME

LAST_NAME

EMAIL

PHONE_NUMBER

HIRE_DATE

JOB_ID (FK)

SALARY

COMMISION_PCT

MANAGER_ID (FK)

DEPARTMENT_ID (FK)

JOB_HISTORY

EMPLOYEE_ID (PK)

START_DATE (PK)

END_DATE

JOB_ID (FK)

DEPARTMENT_ID (FK)

REGIONS

COUNTRIES

LOCATIONS

DEPARTMENTS

JOBS

EMPLOYEES

JOB_HISTORY

Copyright © 2005, Oracle. All rights reserved.

1
-
23

Database Architecture:

Summary of Structural Components


Memory structures:


System Global Area (SGA): Database buffer cache,
redo buffer, and various pools


Program Global Area (PGA)


Process structures:


User process and Server process


Background processes: SMON, PMON, DBW
n
,
CKPT, LGWR, ARC
n
, and so on


Storage structures:


Logical: Database, schema, tablespace, segment,
extent, and Oracle block


Physical: Files for data, parameters, redo, and OS
block

Copyright © 2005, Oracle. All rights reserved.

1
-
24

Summary

In this lesson, you should have learned how to:


Install, create, and administer Oracle Database 10
g


Configure the database for an application


Employ basic monitoring procedures


Implement a backup and recovery strategy


Move data between databases and files