Orcale Tutorial Content
Getting Started - البدء مع إدارة قواعد البيانات
Oracle Architectural Components - مكونات قاعدة البيانات أوركل
Installing Oracle Database - تثبيت الأوركل
Creating and Configuring Database - إنشاء قاعدة البيانات
Controlling The Database -التحكم في قاعدة البيانات
Administrating Users - إدارة المستخدمين
Database Security & Monitoring - تأمين ومراقبة قاعدة البيانات
Oracle Net Services & Database Link & Metrlized Viewِ
Undo Management & Flashback Technology
Managing Shared Servers
Using Globalization Support
Logical Backup & Recovery
Physical Backup & Recovery
Recovery Manager (RMAN)
Managing Resources
Automating Tasks with the Scheduler
Dealing with Locking
Diagnostic Sources
Dealing With Database Corruption
Managing & Monitoring Memory
Performance Tunning
Physical Backup & Recovery
Loss of Control Files
ﻓﻲ ﻫﺫﺍ ﺍﻟﺴﻴﻨﺎﺭﻴﻭ ﺘﺼﻭﺭ ﻤﻌﻲ ﺃﻨﻙ ﻓﻘﺩ ﺠﻤﻴﻊ ﻤﻠﻔﺎﺕ ﺍلControl Files ، ﺒﺎﻟﻁﺒﻊ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻻ ﺘﻌﻤل ﺩﻭﻥ ﻭﺠﻭﺩ ﺍلControl File،
ﻭﻟﻭ ﺃﻨﻙ ﻓﻘﺩﺕ ﺍﺤﺩ ﻤﻠﻔﺎﺕ ﺍلControl File ﻟﻜﺎﻥ ﺍﻷﻤﺭ ﺴﻬل؛ ﻓﻨﻘﻭﻡ ﺒﻌﻤل ﻨﺴﺦ ﻷﺤﺩ ﻤﻠﻔﺎﺕ ﺍلControl Files ﺍﻟﻤﻭﺠﻭﺩﺓ ﻭﻨﻀﻌﻪ ﻤﻜﺎﻥ ﺍﻟﻤﻠﻑ ﺍﻟﻤﻔﻘﻭﺩ
ﻭﻟﻜﻥ ﻫﻨﺎ ﻓﻘﺩﻨﺎ ﺠﻤﻴﻊ ﻤﻠﻔﺎﺕ ﺍلControl Files، ﺒﺎﻟﻁﺒﻊ ﺴﺘﺘﻭﻗﻑ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻋﻥ ﺍﻟﻌﻤل ﻭﺇﺫﺍ ﻟﻡ ﺘﺘﻭﻗﻑ ﻴﺠﺏ ﺇﻴﻘﺎﻓﻬﺎ ﻓﻭﺭﺍﹰ (Shut Abort) ﺇﻟﻰ ﺤﻴﻥ
ﻋﻤل ﺇﺠﺭﺍﺀ ﺴﺭﻴﻊ ﻹﻨﻘﺎﺫ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.
ﻓﻲ ﻤﺜل ﻫﺫﺍ ﺍﻟﺴﻴﻨﺎﺭﻴﻭ ﻫﻨﺎﻙ ﺨﻴﺎﺭﻴﻥ ﻟﻺﻨﻘﺎﺫ:-
الخيار الأول:
ﻨﻘﻭﻡ ﺒﺈﻨﺸﺎﺀ Control File ﻤﻥ ﺠﺩﻴﺩ ﺒﺎﺴﺘﺨﺩﺍﻡ ﺍﻟﻜﻭﺩ Create Controlfile، ﻭﺫﻟﻙ ﺒﻤﺴﺎﻋﺩﺓ ﺍلTrace Control File ﺇﻥ ﻭﺠﺩ، ﻭﺍﻷﻓﻀل ﻟﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
ﺃﻥ ﻴﻘﻭﻡ ﺒﻌﻤل Backup Trace To Controlfile ﻜل ﻤﺎ ﻗﺎﻡ ﺒﺘﻐﻴﺭ ﻫﻴﻜﻠﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺤﺘﻰ ﻴﺴﺘﻔﻴﺩ ﻤﻥ ﻤﻠﻑ ﺍلTrace ﻓﻲ ﺇﻨﺸﺎﺀ ﺍلFile Control ﻻﺤﻘﺎﹰ
ﻓﻲ ﺤﺎل ﺍﻨﻪ ﻓﻘﺩ ﺠﻤﻴﻊ ﻤﻠﻔﺎﺕ ﺍلControl Files، ﻭﻟﻜﻥ ﺤﺘﻰ ﻟﻭ ﻟﻡ ﻴﻘﻡ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﻬﺫﺍ ﺍﻹﺠﺭﺍﺀ ﻓﻴﻤﻜﻨﻪ ﺍﻟﻘﻴﺎﻡ ﺒﺈﻨﺸﺎﺀ ﻤﻠﻑ ﺍلControl File ﻋﻥ ﻁﺭﻴﻕ
ﻜﺘﺎﺒﺔ ﺍﻟﻜﻭﺩ ﻴﺩﻭﻴﺎﹰ ﺤﺴﺏ ﻫﻴﻜﻠﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.
ﻋﻤﻭﻤﹰﺎ ﻴﺴﺘﻁﻴﻊ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻋﻤل Backup Controlfile To Trace.
ALTER DATABASE BACKUP CONTROLFILE TO TRACE; |
ﻴﻨﺘﺞ ﻤﻥ ﻫﺫﺍ ﺍﻹﺠﺭﺍﺀ Trace File ﻫﻭ ﻋﺒﺎﺭﺓ ﻋﻥ ﻤﻠﻑ ﻨﺼﻲ ﻴﺤﻭﻯ ﻜﻭﺩ ﺇﻨﺸﺎﺀ ﺍلControl File ﻴﻤﻜﻥ ﺍﺴﺘﺨﺩﺍﻤﻪ ﻻﺤﻘﺎﹰ ﻹﻨﺸﺎﺀ ﺍلControl File ﻋﻨﺩﻤﺎ ﻨﺤﺘﺎﺝ ﺇﻟﻰ ﺫﻟﻙ،
ﻭﻴﻭﺠﺩ ﻫﺫﺍ ﺍﻟﻤﻠﻑ ﻓﻲ ﺍﻟﻤﺴﺎﺭ ﺍﻟﻤﺤﺩﺩ ﻋﻠﻰ ﺍﻟﻤﺘﻐﻴﺭ USER_DUMP_DEST.
ﻭﺍﻟﻴﻙ ﺨﻁﻭﺍﺕ ﺇﻨﺸﺎﺀ Control File:
1- ﺘﺸﻐﻴل ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﺍﻟﻭﻀﻊ NOMOUNT.
STARTUP NOMOUNT; |
2- ﻨﻘﻭﻡ ﺒﻜﺘﺎﺒﺔ ﺃﻭ ﺘﺠﻬﻴﺯ ﻜﻭﺩ ﺇﻨﺸﺎﺀ ﺍلControl File ﻤﻥ ﻤﻠﻑ ﺍلTrace ﺇﻥ ﻭﺠﺩ ﺃﻭ ﻜﺘﺎﺒﺘﻪ ﻴﺩﻭﻴﺎﹰ،
ﻭﺍﻟﻴﻙ ﻤﺜﻼﹰ ﻟﻤﻠﻑ ﻴﺤﻭﻯ ﻜﻭﺩ ﺇﻨﺸﺎﺀ ﺍلControl File ﻗﻤﺕ ﺒﻨﺴﺨﻪ ﻤﻥ ﻤﻠﻑ ﺍلTrace File ﻭﺤﻔﻅﺘﻪ ﻓﻲ ﻤﻠﻑ ﺴﻤﻴﺘﻪ CONT.SQL.
3- ﻨﻘﻭﻡ ﺒﺘﻨﻔﻴﺫ ﺍﻟﻜﻭﺩ ﺃﻋﻼﻩ ﻜﻤﺎ ﻓﻲ ﺍﻟﺸﻜل 5-14، ﻟﻜﻥ ﻴﺠﺏ ﺘﻨﻔﻴﺫ ﺍﻟﻜﻭﺩ ﻭﻨﺤﻥ ﻓﻲ ﺍﻟﻭﻀﻊ NOMOUNT.
@C:\CONT.SQL |
4- ﺜﻡ ﻨﻔﺘﺢ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﺍﻟﻭﻀﻊ RESETLOGS.
ALTER DATABASE OPEN RESETLOGS; |
ﺍﻟﺨﻴﺎﺭ ﺍﻟﺜﺎﻨﻲ : -
ﻫﻨﺎ ﻨﻘﻭﻡ ﺒﺎﺴﺘﺭﺠﺎﻉ ﻤﻠﻑ ﺍلFile Control ﻤﻥ ﺍﻟﻨﺴﺦ ﺍﻹﺤﺘﻴﺎﻁﻰ.
1- ﻨﻘﻭﻡ ﺒﻌﻤل Restore ﻟﻤﻠﻔﺎﺕ ﺍلControl File ﻤﻥ ﺍﻟﻨﺴﺦ ﺍﻹﺤﺘﻴﺎﻁﻰ.
2- ﺜﻡ ﻨﻔﺘﺢ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﺍﻟﻭﻀﻊ MOUNT.
STARTUP MOUNT |
3- ﺜﻡ ﻨﻘﻭﻡ ﺒﻌﻤل Recovery.
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCCEL; |
ﻻﺤﻅ ﺍﻨﻪ ﺒﻌﺩ ﺒﺩﺀ ﻋﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ ﻗﺩ ﻨﺤﺘﺎﺝ ﻟﺘﺤﺩﻴﺩ ﺍلRedolog Files ﻹﻜﻤﺎل ﻋﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ ﺃﻭ ﻨﻘﻭﻡ ﺒﻌﻤل ﺫﻟﻙ ﺃﻟﻴﺎﹰ ﺒﻜﺘﺎﺒﺔ ﺍﻟﺨﻴﺎﺭ AUTO،
ﻭﻫﻨﺎﻙ ﺨﻴﺎﺭ ﺁﺨﺭ ﻫﻭ CANCEL ﻹﻨﻬﺎﺀ ﻋﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ، ﻟﻜﻥ ﺇﺫﺍ ﻗﻤﺕ ﺒﻜﺘﺎﺒﺔ Redolog File ﻨﻘﻭﻡ ﺒﺈﻋﺎﺩﺓ ﺍﻟﺨﻁﻭﺓ ﻤﺭﺓ ﺃﺨﺭﻯ ﺒﺘﺤﺩﻴﺩ ﺍلRedolog Files ﺍﻷﺨﺭﻯ.
[Must be current Redolog file , else repeat this steps with other Redolog groups member]
4- ﺃﺨﻴﺭﺍﹰ ﻨﻔﺘﺢ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﺍﻟﻭﻀﻊ RESETLOGS.
ALTER DATABASE OPEN RESETLOGS; |
------------------------------------------