Orcale Tutorial Content
Loading...
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
Damage Online Logfile Member
ﺫﻜﺭﻨﺎ ﺴﺎﺒﻘﺎﹰ ﺃﻥ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺘﻌﻤل ﻋﻠﻰ ﺍﻷﻗل ﻋﻠﻰ ﺍﺜﻨﻴﻥ ﻤﻥ ﺍلRedo Logfile Groups ﻭﺃﻱ Group ﻴﺤﻭﻯ ﻋﻠﻰ ﺍﻷﻗل ﻋﻠﻲ Member ﻭﺍﺤﺩ.
ﻭﻟﻨﻔﺘﺭﺽ ﺃﻥ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻟﺩﻴﻙ ﺘﻌﻤل ﻋﻠﻰ ﺜﻼﺙ Redo Logfile Groups ﻭﻜل Group ﻴﺤﻭﻯ Tow Members.
SELECT GROUP#,MEMBER FROM V$LOGFILE; |
ﻟﻨﻔﺘﺭﺽ ﺃﻨﻪ ﺤﺩﺙ ﻤﺸﻜﻠﺔ ﻓﻲ ﺍلMember ﺍﻷﺘﻲ:
D:\ORADATA\REDO11.LOG
ﻭﻫﻭ ﻴﻨﺘﻤﻲ ﺇﻟﻲ Group1.
ﺇﻟﻴﻙ ﺍﻟﺨﻁﻭﺍﺕ ﻟﺤل ﻫﺫﺍ ﺍﻟﺴﻴﻨﺎﺭﻴﻭ:
1- ﻨﻘﻭﻡ ﺃﻭﻻﹰ ﺒﺤﺫﻑ ﺍلMember ﺍﻟﺫﻱ ﺒﻪ ﺍﻟﻤﺸﻜﻠﺔ ﻤﻥ ﺍلGroup ﺜﻡ ﻨﻘﻭﻡ ﺒﺤﺫﻓﻪ ﻋﻥ ﻁﺭﻴﻕ ﻨﻅﺎﻡ.
ALTER DATABASE DROP LOGFILE MEMBER 'D:\oradata\REDO11.LO G'; |
٢- ﺜﻡ ﻨﻘﻭﻡ ﺒﺈﻀﺎﻓﺔ Member ﺠﺩﻴﺩ ﻟلGroup.
ALTER DATABASE ADD LOGFILE MEMBER 'D:\oradata\REDO11.LO G' TO GROUP 1; |
ﻴﻤﻜﻥ ﺍﻟﺘﺄﻜﺩ ﻤﻥ ﺫﻟﻙ ﺒﻭﺍﺴﻁﺔ ﺍﻻﺴﺘﻌﻼﻡ.
SELECT GROUP#,MEMBER FROM V$LOGFILE; |
ﻜﻤﺎ ﻴﻤﻜﻥ ﺍﻟﺘﺄﻜﺩ ﻤﻨﻪ ﻓﻴﺯﻴﺎﺌﻴﺎﹰ ﻋﻥ ﻁﺭﻴﻕ ﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل.
------------------------------------------------------