DBA ARABIC

Orcale Tutorial Content

Getting Started - البدء مع إدارة قواعد البيانات

أنواع مستخدمي قواعد البيانات:

مهام مسؤول قاعدة البيانات:

SQL Statements:

Identifying Your Oracle Database Software Release - تحديد إصدار اوركل

About Database Administrator Security and Privileges- أمان وامتيازات مسؤول قاعدة البيانات

Database Administrator Authentication - مصادقة مسؤول قاعدة البيانات

Creating and Maintaining a Database Password File - إنشاء ملف كلمة المرور

Oracle Architectural Components - مكونات قاعدة البيانات أوركل

ﻤﻜﻭﻨﺎﺕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ

Oracle Instance

Oracle Database

Installing Oracle Database - تثبيت الأوركل

Installing oracle database 10g in windows

Creating and Configuring Database - إنشاء قاعدة البيانات

ﺍﻟﺘﺨﻁﻴﻁ ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ

ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﺎﻟﻁﺭﻴﻘﺔ ﺍﻟﻴﺩﻭﻴﺔ علي Windows:

ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻋﻥ ﻁﺭﻴﻕ ﺍل(DBCA)

About Creating an Oracle Database

About Selecting a Character Set

Prerequisites for Database Creation

Creating a Database with the CREATE DATABASE Statement

Specifying CREATE DATABASE Statement Clauses

Specifying Initialization Parameters

Controlling The Database -التحكم في قاعدة البيانات

التحكم في قاعدة البيانات - Controlling The Database

ﺘﺸﻐﻴل ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ

ﺇﻏﻼﻕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ

Opening a Database in Read-Only Mode

Opening a Database in Restricted Mode

Managing Tablespaces and Data files

ﻤﻔﺎﻫﻴﻡ ﻋﺎﻤﺔ ﻋﻥ ﺍل: Tablespaces

عملي

Control File & Redo Log Files

Control File

ﺘﻐﻴﻴﺭ ﺍﺴﻡ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ

Redo Log Files

Administrating Users - إدارة المستخدمين

ﺇﻨﺸﺎﺀ ﻭﺇﺩﺍﺭﺓ ﺍﻟﻤﺴﺘﺨﺩﻤﻴﻥ

Quota

ﻭﺴﻴﻠﺔ ﺍﻟﺘﺤﻘﻴﻕ

ﺍﻟﺼﻼﺤﻴﺎﺕ - Privileges

ROLES

PROFILES

Database Security & Monitoring - تأمين ومراقبة قاعدة البيانات

Database Security

ﻤﺭﺍﻗﺒﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ - AUDITING

Oracle Net Services & Database Link & Metrlized Viewِ

Oracle Net Services

ﺍﻟﺘﺤﻜﻡ ﻓﻲ ﺍﻟﻭﺼﻭل ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ

Undo Management & Flashback Technology

UNDO MANAGEMENT

Flashback Query

Flashback Table

Flashback Versions Query

Flashback Transaction

Flashback Drop

Flashback Database

Managing Shared Servers

Why Shared Server

Dedicated Server

Shared Server Architecture

ﻤﺘﻰ ﻨﺴﺘﺨﺩﻡ ﺍل Shared Server ؟

Using Globalization Support

Globalization

ﺍﺨﺘﻴﺎﺭ وتغيير ﺍل Character Set

ﻤﺴﺘﻭﻴﺎﺕ ﺍل Globalization

ﺍﺴﺘﺨﺩﺍﻡ ﺍل Zones Time

Logical Backup & Recovery

Use Export Utilities to Export Data

TABLES EXPORT Using Export Utilities

SCHEMAS EXPORT Using Export Utilities

TABLESPACE EXPORT Using Export Utilities

DATABASE EXPORT Using Export Utilities

Use Import Utilities to Import Data

TABLES IMPORT Using Import Utilities

SCHEMAS IMPORT Using Import Utilities

DATABASE IMPORT Using Import Utilities

DATA PUMP

TABLES EXPORT Using Data Pump

SCHEMAS EXPORT Using Data Pump

DATABASE EXPORT Using Data Pump

TABLES IMPORT Using Data Pump

SCHEMAS IMPORT Using Data Pump

DATABASE IMPORT Using Data Pump

SQL*Loader

Physical Backup & Recovery

Physical Backup

ﻜﻴﻑ ﻨﻬﻴﺊ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻟﺘﻌﻤل ﻓﻲ ﺍﻟﻨﻤﻁ ARCHIVELOG؟

Cold Backup

Full Database Recovery

Loss of a Non-SYSTEM Data File

Loss of a SYSTEM Data File

Loss of an Un-archived Online Log Files

Loss of Control Files

Loss Unbackup Datafile

Damage Tempfile

Damage Temporary Tablespace

Damage Online Logfile Member

Point in Time Recovery

Backup and Recovery Options

Hot Backup

Recovery Manager (RMAN)

مقدمة

مكونات ال Recovery Manager (RMAN)

ﺃﻨﻭﺍﻉ ﺍﻻﺘﺼﺎل ﺒﺎل RMAN

ﺨﻴﺎﺭﺍﺕ وأنماط ﺍﻟﻨﺴﺦ ﺍﻹﺤﺘﻴﺎﻁﻰ

RMAN Configuration Setting

Archived Redo Log Files Backup

Restore ControlFile and spfile

Managing Resources

Consumer Groups

Resource Manager Plans

Resource Manager Configuration

Create Consumer Group

Update Consumer Group

Delete Consumer Group

Privileges & Resource Manager

Join To Consumer Group

Move Active User To Other Consumer Group

Create Resource Manager Plans & Directive

Update Resource Manager Plans

Update Resource Manager Plan Directives

Delete Resource Manager Plan Directives

Delete Resource Manager Plans

Create Simple Plan

Consumer Group Mapping

Automating Tasks with the Scheduler

The Scheduler Architecture

Jobs

Programs

Schedules

Using Programs and Schedules

Job Classes

Windows

(Privileges) ﺍﻟﺼﻼﺤﻴﺎﺕ

Job Logs

Dealing with Locking

Shared & Exclusive Locks

Manual Lock Table

The Enqueue Mechanism

Lock Contention

Deadlocks

Diagnostic Sources

Alert Log

Background Trace Files

Server-Generated Alerts

Editing Thresholds

User Trace Files

Instance-Level SQL Tracing

Session-Level SQL Tracing

Dealing With Database Corruption

Block Corruption

ﺍﻜﺘﺸﺎﻑ ﺍﻟﻜﺘل ﺍﻟﻔﺎﺴﺩﺓ (Detecting Block Corruptions)

The DBVERIFY Utility

The ANALYZE Command

DBMS_REPAIR Backage

ﺍﺴﺘﺭﺠﺎﻉ ﺍﻟﻜﺘل ﺍﻟﻔﺎﺴﺩﺓ ﺒﻭﺍﺴﻁﺔ ﺍل:RMAN

Managing & Monitoring Memory

The System Global Area

The Shared Pool

The Database Buffer Cache

The Default, Keep, and Recycle Pools

The Nonstandard Block Size Pools

Sizing the Database Buffer Cache

Automatic Shared Memory Management

Enable Automatic Shared Memory Management

The Program Global Area (PGA)

Performance Tunning

Invalid Objects

Unusable Indexes

Rebuild Invalid Inexes

Optimizer Statistics

Gathering Statistics

The Automatic Workload Repository (AWR)

The Automatic Database Diagnostic Monitor (ADDM)

The SQL Tuning Advisor

The SQL Access Advisor

The Mean Time to Recover Advisor

The Segment Advisor

The Undo Advisor

Recovery Manager (RMAN)

Complete Recovery

ﺤﺩﻭﺙ ﻋﻁل ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻫﻭ ﺃﻤﺭ ﻭﺍﺭﺩ ﻟﺫﺍ ﻭﺠﺏ ﻋﻠﻰ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻭﻀﻊ ﺍﻟﺘﺭﺘﻴﺒﺎﺕ ﺍﻟﻼﺯﻤﺔ ﺤﺘﻰ ﻻ ﻴﻔﻘﺩ ﺠﺯﺀ ﻤﻥ ﻗﺎﻋﺩﺓ ﺒﻴﺎﻨﺎﺘﻪ،

ﻭﻟﻘﺩ ﺘﺤﺩﺜﻨﺎ ﻓﻲ سابقاً ﻋﻥ ﺍلComplete Recovery ﻭﻫﻭ ﺇﺭﺠﺎﻉ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺇﻟﻰ ﻤﺎ ﻗﺒل ﺤﺩﻭﺙ ﺍﻟﻔﺸل ﺩﻭﻥ ﺃﻥ ﻨﻔﻘﺩ ﺠﺯﺀ ﻤﻥ ﺍﻟﺒﻴﺎﻨﺎﺕ.

Data File Recovery:

ﻫﻨﺎﻙ ﻨﻭﻋﺎﻥ ﻤﻥ ﺍلData Files:

1- Loss of a Non-SYSTEM Data File:

ﻭﻫﻭ ﺃﻱ Files Data ﻻ ﻴﻨﺘﻤﻲ ﻟل(System or Undo Tablespace)، ﻓﻔﻲ ﻫﺫﻩ ﺍﻟﺤﺎﻟﺔ ﻗﺩ ﻻ ﻨﺤﺘﺎﺝ ﺇﻟﻰ ﺇﻏﻼﻕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻹﻨﺠﺎﺯ ﻋﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ.

RMAN> RUN{

ALLOCATE CHANNEL D١ TYPE DISK;

RESTORE DATAFILE 4;

RECOVER DATAFILE 4;

}

ﻴﻤﻜﻥ ﻜﺫﻟﻙ ﺇﻋﺎﺩﺓ ﺘﺴﻤﻴﺔ ﺍلData File ﺃﺜﻨﺎﺀ ﻋﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ ﻭﺫﻟﻙ ﺒﺎﺴﺘﺨﺩﺍﻡ ﺍﻷﻤﺭ SET NEWNAME ﻟﺘﻐﻴﻴﺭ ﺍﺴﻡ ﺃﻭ ﻤﻜﺎﻥ ﺍلFile Data .

ﻭﺍﻷﻤﺭ SWITCH ﻟﺘﻌﺩﻴل ﻫﺫﺍ ﺍﻟﺘﻐﻴﻴﺭ ﻓﻲ الControl File.

RMAN> RUN{

ALLOCATE CHANNEL D١ TYPE DISK;

SET NEWNAME FOR DATAFILE 4 TO

'C:\oradata\orcl\USERS.DB F';

RESTORE DATAFILE 4;

SWITCH DATAFILE 4;

RECOVER DATAFILE 4;

}

2- Loss of a SYSTEM Data File:

ﻭﻨﻘﺼﺩ ﺒﻪ ﻫﻨﺎ ﺃﻱ Data Files ﻴﻨﺘﻤﻲ ﻟل(System or Undo Tablespace)، ﻭﺒﺎﻟﻁﺒﻊ ﻻ ﻨﺴﺘﻁﻴﻊ ﻋﻤل ﺍﺴﺘﺭﺠﺎﻉ ﻟلSystem Data File.

ﺩﻭﻥ ﺇﻏﻼﻕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻭﺫﻟﻙ ﻷﻥ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻻ ﺘﻌﻤل ﺇﺫﺍ ﺤﺩﺜﺕ ﻤﺸﻜﻠﺔ ﻓﻲ System Datafile.

RMAN> RUN{

ALLOCATE CHANNEL D1 TYPE DISK;

SHUTDOWN ABORT;

STARTUP MOUNT;

RESTORE DATAFILE 2;

RECOVER DATAFILE 2;

SQL 'ALTER DATABASE OPEN';

}

ﻭﻴﻤﻜﻥ ﻫﻨﺎ ﺃﻴﻀﺎﹰ ﺇﻋﺎﺩﺓ ﺘﺴﻤﻴﺔ ﻤﻠﻔﺎﺕ ﺍلData Files ﺃﺜﻨﺎﺀ ﻋﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ ﺒﻭﺍﺴﻁﺔ ﺍﻷﻤﺭ SET NEWNAME ﻭﺍﻷﻤﺭ SWITCH.

Tablespace Recovery:

ﻭﻴﻤﻜﻥ ﺃﻥ ﻨﻘﻭل ﻫﻨﺎ ﻤﺎ ﻗﻠﻨﺎﻩ ﻓﻲ ﻤﻭﻀﻭﻉ ﺍلData Files ﻤﻥ ﺃﻨﻪ ﺇﺫﺍ ﻓﻘﺩﻨﺎ ﺍلSystem or Undo Tablespace ﻻﺒﺩ ﻤﻥ ﺍﻟﻘﻴﺎﻡ ﺒﻌﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ ﻓﻲ ﺍﻟﻭﻀﻊ MOUNT.

ﺃﻤﺎ ﻏﻴﺭﻫﻤﺎ ﻤﻥ ﺍلTablespaces ﻓﻴﻤﻜﻥ ﺃﻥ ﻨﻘﻭﻡ ﺒﻌﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ ﺩﻭﻥ ﺇﻏﻼﻕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻭﻟﻜﻥ ﺒﻌﺩ وﻀﻊ ﺍلTablespace ﻓﻰ ﺍﻟﻭﻀﻊ Offline.

RMAN> RUN{

ALLOCATE CHANNEL D1 TYPE DISK;

SQL 'ALTER TABLESPACE USERS OFFLINE';

RESTORE TABLESPACE USERS;

RECOVER TABLESPACE USERS;

SQL 'ALTER TABLESPACE USERS ONLINE';

}

Database Recovery:

ﻴﻤﻜﻥ ﻋﻥ ﻁﺭﻴﻕ ﺍلRMAN ﻋﻤل ﺍﺴﺘﺭﺠﺎﻉ ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ، ﻭﺍﻟﻴﻙ ﺍﻟﺨﻁﻭﺍﺕ:

1- ﻓﺘﺢ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻰ ﺍﻟﻭﻀﻊ MOUNT.

RMAN> STARTUP MOUNT;

2- ﻋﻤل RESTORE ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.

RMAN> RESTORE DATABASE;

3- ﻋﻤل RECOVERY ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.

RMAN> RECOVER DATABASE;

4- ﻓﺘﺢ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.

RMAN> ALTER DATABASE OPEN;

--------------------------------------------

DATABASE

SQL

VIDEOS

Orcale Tutorial Content

Recovery Manager (RMAN)

Complete Recovery

Data File Recovery:

1- Loss of a Non-SYSTEM Data File:

Tablespace Recovery:

Database Recovery: