سر فصل دوره Oracle Database 11g Administration Workshop I

سر فصل دوره Oracle Database 11g: Administration Workshop I Release 2

در این درس شما به عنوان یک حرفه ای اوراکل کار , اولین گام را به سوی موفقیت بر می دارید ،این درس طوری طراحی شده تا بعنوان مدیر پایه ی پایگاه داده اوراکل باشید. در این کلاس شما یاد می گیرند:

۱- چگونه نصب و نگهداری پایگاه های داده اوراکل .

۲- درک مفهومی از معماری پایگاه داده اوراکل و چگونگی ارتباط اجزای آن با یکدیگر

۳- چگونگی ایجاد پایگاه داده ی عملیاتی و مدیریت درست ساختار های مختلف به شیوه ای موثر و کارآمد از جمله:

نظارت بر عملکرد ، امنیت پایگاه داده ، مدیریت کاربران ، و روش تهیه پشتیبان و بازیابی آن .

این دوره شما را برای امتحان OCA(Oracle Certified Associate) آماده می کند.

این دوره مباحث زیر را پوشش نمی دهد:

۱-فنون Grid

۲- Enterprise Manager Grid Control

۳-Real Application Clusters

۴-Streams

۵-Data Guard

پیشنیاز درس:

Oracle database 11g  SQL Fundamental I & II

سرفصل دروس:

Exploring the Oracle Database Architecture

Oracle Database Architecture Overview

Oracle ASM Architecture Overview

Process Architecture

Memory structrues

Logical and physical storage structures

ASM storage components

Installing your Oracle Software

Tasks of an Oracle Database Administrator

Tools Used to Administer an Oracle Database

Installation: System Requirements

Oracle Universal Installer (OUI)

Installing Oracle Grid Infrastructure

Installing Oracle Database Software

Silent Install

Creating an Oracle Database

Planning the Database

Using the DBCA to Create a Database

Password Management

Creating a Database Design Template

Using the DBCA to Delete a Database

Managing the Oracle Database Instance

Start and stop the Oracle database and components

Use Oracle Enterprise Manager

Access a database with SQLPlus

Modify database installation parameters

Describe the stages of database startup

Describe database shutdown options

View the alert log

Access dynamic performance views

Manage the ASM Instance

Set up initialization parameter files for ASM instance

Start up and shut down ASM instances

Administer ASM disk groups

Configuring the Oracle Network Environment

Use Enterprise Manager to create and configure the Listener

Enable Oracle Restart to monitor the listener

Use tnsping to test Oracle Net connectivity

Identify when to use shared servers and when to use dedicated servers

Managing Database Storage Structures

Storage Structures

How Table Data Is Stored

Anatomy of a Database Block

Space Management in Tablespaces

Tablespaces in the Preconfigured Database

Actions with Tablespaces

Oracle Managed Files (OMF)

Administering User Security

Database User Accounts

Predefined Administrative Accounts

Benefits of Roles

Predefined Roles

Implementing Profiles

Managing Data Concurrency

Data Concurrency

Enqueue Mechanism

Resolving Lock Conflicts

Deadlocks

Managing Undo Data

Data Manipulation

Transactions and Undo Data

Undo Data Versus Redo Data

Configuring Undo Retention

Implementing Oracle Database Auditing

Describe DBA responsibilities for security

Enable standard database auditing

Specify audit options

Review audit information

Maintain the audit trail

Database Maintenance

Manage optimizer statistics

Manage the Automatic Workload Repository (AWR)

Use the Automatic Database Diagnostic Monitor (ADDM)

Describe and use the advisory framework

Set alert thresholds

Use server-generated alerts

Use automated tasks

Performance Management

Performance Monitoring

Managing Memory Components

Enabling Automatic Memory Management (AMM)

Automatic Shared Memory Advisor

Using Memory Advisors

Dynamic Performance Statistics

Troubleshooting and Tuning Views

Invalid and Unusable Objects

Backup and Recovery Concepts

Part of Your Job

Statement Failure

User Error

Understanding Instance Recovery

Phases of Instance Recovery

Using the MTTR Advisor

Media Failure

Archive Log Files

Performing Database Backups

Backup Solutions: Overview

Oracle Secure Backup

User-Managed Backup

Terminology

Recovery Manager (RMAN)

Configuring Backup Settings

Backing Up the Control File to a Trace File

Monitoring the Flash Recovery Area

Performing Database Recovery

Opening a Database

Data Recovery Advisor

Loss of a Control File

Loss of a Redo Log File

Data Recovery Advisor

Data Failures

Listing Data Failures

Data Recovery Advisor Views

Moving Data

Describe ways to move data

Create and use directory objects

Use SQL*Loader to move data

Use external tables to move data

General architecture of Oracle Data Pump

Use Data Pump export and import to move data

 Working with Support

Use the Enterprise Manager Support Workbench

Work with Oracle Support

Log service requests (SR)Save changes

Manage patches