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
  • ﺍﻟﺘﺤﻜﻡ ﻓﻲ ﺍﻟﻭﺼﻭل ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • External Procedures
  • Clients Side
  • Database Link
  • Materialized Views
    • 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
  • Recovery Catalog
  • RMAN Backups
  • Data Files Backup
  • Tablespaces Backup
  • Archived Redo Log Files Backup
  • Control File Backup
  • Database Backup
  • Incremental Backups
  • RMAN Commands
  • Complete Recovery
  • Incomplete Recovery
  • 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
  • The Log Buffer
  • The Large Pool
  • The Java Buffer
  • The Steams Buffer
  • 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

    • Managing Tablespaces and Data files

    عملي

    1- ﺇﻨﺸﺎﺀ Tablespace ﺠﺩﻴﺩ:

     

    CREATE TABLESPACE TEST DATAFILE 'D:\TEST\TEST١.DBF' SIZE 100M NOLOGGING;

     

    ﺒﻤﺎ ﺃﻨﻨﺎ ﻟﻡ ﻨﺤﺩﺩ ﻨﻭﻉ ﺇﺩﺍﺭﺓ ﺍلTablespace ﻓﺈﻥ ﺍﻷﺼل ﻫﻭ Locally Managed Tablespace.

     

    CREATE TABLESPACE TEST DATAFILE 'D:\TEST\TEST.DBF' SIZE ٠١M EXTENT MANAGEMENT LOCAL UNIFORM 200M;

     

     

    2- زيادة حجم الTablespace:

    ﺍﻟﻁﺭﻴﻘﺔ ﺍﻷﻭﻟﻰ ﺇﻀﺎﻓﺔ Data File ﺠﺩﻴﺩ ﻟﻨﻔﺱ ﺍلTablespace.

     

    ALTER TABLESPACE TEST ADD DATAFILE ‘D:\TEST\TEST.DBF’ SIZE 500M;

     

    ﺍﻟﻁﺭﻴﻘﺔ ﺍﻟﺜﺎﻨﻴﺔ ﺯﻴﺎﺩﺓ ﺤﺠﻡ ﺍلFile Data ﺍﻟﻤﻭﺠﻭﺩﺓ .

     

    ALTER DATABASE DATAFILE 'D:\TEST\TEST.DBF' RESIZE 200M;

     

    3- حذف الTablespace:

    ﺍﻟﻁﺭﻴﻘﺔ ﺍﻷﻭﻟﻰ ﺤﺫﻑ ﺇلTablespace ﻓﻘﻁ ﺩﻭﻥ ﺍلData Files.

     

    DROP TABLESPACE TEST;

     

    ﺒﻬﺫﻩ ﺍﻟﻁﺭﻴﻘﺔ ﻴﻅل ﺍلData File ﻤﻭﺠﻭﺩ ﻋﻠﻰ ﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل ﻭﻴﻤﻜﻥ ﺍﺴﺘﺨﺩﺍﻤﻪ ﻋﻨﺩ ﺇﻨﺸﺎﺀ Tablespace جديد.

     

    CREATE TABLESPACE OBAY DATAFILE 'D:\TEST\TEST.DBF' REUSE;

     

    ﺍﻟﻁﺭﻴﻘﺔ ﺍﻟﺜﺎﻨﻴﺔ ﻟﺤﺫﻑ ﺍلTablespace ﻭﻤﻌﻪ ﺍلData Files.

     

    DROP TABLESPACE OBAY INCLUDING CONTENTS AND DATAFILES;

     

     

    4- نحويل الTablespace الي الوضع Read Only:

     

    ALTER TABLESPACE TEST READ ONLY;

     

    ﺤﺎﻭل ﺃﻥ ﺘﻀﻊ ﺍلSystem Tablespace ﻓﻲ ﺍﻟﻭﻀﻊ  Read Only ستظهر لك رسالة خطأ ORA-01643، 

     

    5- نحويل الTablespace الي الوضع Read Write:

    ALTER TABLESPACE TEST READ WRITE;

     

    6- نحويل الTablespace الي الوضع OFFLINE:

     

    ALTER TABLESPACE TEST OFFLINE;

     

    7- نحويل الTablespace الي الوضع ONLINE:

     

    ALTER TABLESPACE TEST ONLINE;

     

    8- إعادة تسمية الTablespace :

     

    ALTER TABLESPACE TEST RENAM TO EXAM;

     

    9- إنشاء Temporary Tablespace :

     

    CREATE TEMPORARY TABLESPACE TEMPEXAM TEMPFILE 'D:\TEST\TEMPEXAM.DBF' SIZE 100M;

     

    ﻭﺤﺘﻰ ﻴﻜﻭﻥ ﻫﺫﺍ ﺍلTablespace ﻫﻭ ﺍلDefault Temporary Tablespace ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.

     

    ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPEXAM;

     

    ﻴﻤﻜﻥ ﺍﻟﺘﺄﻜﺩ ﻤﻥﺍلDefault Temporary Tablespace .

     

    SELECT PROPERTY_NAME,PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

     

    10- إنشاء Temporary Tablespace Group :

    ﻭﻫﻭ ﻤﻴﺯﺓ ﻤﺴﺘﺤﺩﺜﺔ ﻓﻲ ﺍﻹﺼﺩﺍﺭ  Oracle 10g ﺘﺴﺘﺨﺩﻡ ﻋﻨﺩ ﻨﻘﺹ ﺍلResource ﺍﻟﻤﺴﺘﺨﺩﻡ ﻟﻠﺘﺨﺯﻴﻥ ﺍﻟﻤﺅﻗﺕ .

     

    CREATE TEMPORARY TABLESPACE TEMPG١ TEMPFILE 'D:\TEST\TEMPG١.DBF' SIZE 50M TABLESPACE GROUP GROUB1;

     

    ﺇﻀﺎﻓﺔ Tablespace ﻤﻭﺠﻭﺩ ﺃﺼﻼﹰ ﻟلGroup.

    ALTER TABLESPACE TEMPEXAM TABLESPACE GROUP GROUP1;

    كما يمكن إنشاء Tablespace اخر لنفس الGroup.

     

    11- إنشاء Big Tablespace :

     

    CREATE BIGFILE TABLESPACE BIG١ DATAFILE ‘D:\TEST\BIG١.BDF’ SIZE 60M;

     

     

    ﻟﻼﺴﺘﻌﻼﻡ ﻋﻥ ﺍلDATAFILES & TABLESPACES:

    DBA_TABLESPACES

    USER_TABLESPACES

    DBA_TABLESPACE_GROUPS

    V$TABLESPACE

    DBA_DATA_FILES

    DBA_TEMP_FILES

     

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

    Quick Links
    Get Started

    Get access to your full Free Training

    Login
    Contact Us

    info@dba-arabic.com

    Copyright DBA-ARABIC © 2023. All rights reserved.