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 a Non-SYSTEM Data File
ﻭﻫﻭ Datafile ﻻ ﻴﻨﺘﻤﻲ لSystem Tablespace ﺃﻭ Undo Tablespace ، ﻟﺤﻅﺔ ﻓﻘﺩﺍﻥ Non-SYSTEM Datafile ﺍﻟﻤﺴﺘﺨﺩﻤﻭﻥ ﻴﺴﺘﻘﺒﻠﻭﻥ ﺭﺴﺎﺌل ﺨﻁﺄ ﺘﻔﻴﺩ ﺒﻔﻘﺩﺍﻥ ﺍلDatafile ﻜﻤﺎ ﻴﻤﻜﻥ
ﺍﻨﺠﺎﺯ ﻋﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ ﺩﻭﻥ ﺇﻏﻼﻕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ Online Recovery ﻭﻻ ﻴﺘﺄﺜﺭ ﺍﻟﻤﺴﺘﺨﺩﻤﻭﻥ ﺍﻟﺫﻴﻥ ﻴﻌﻤﻠﻭﻥ ﻋﻠﻰ ﺍلTablespaces ﺍﻷﺨﺭﻯ، ﻓﺴﻴﺴﺘﻤﺭﻭﻥ ﻓﻲ ﺍﻟﻌﻤل ﺇﺜﻨﺎﺀ ﻋﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ.
ﺒﺎﻟﻁﺒﻊ ﻴﻤﻜﻥ ﺇﻨﺠﺎﺯ ﻋﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ Recovery ﺩﻭﻥ ﺇﻏﻼﻕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺃﻭ ﺒﻌﺩ ﺇﻏﻼﻗﻬﺎ (Online or Offline) ﻭﻟﻜﻥ ﺒﺎﻟﻁﺒﻊ ﻋﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ ﺩﻭﻥ ﺇﻏﻼﻕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻤﺴﺘﺤﻴﻠﺔ ﺇﺫﺍ
ﻓﻘﺩﻨﺎ Datafile ﻴﻨﺘﻤﻲ System Tablespace.
ﻭﻟﻨﻔﺘﺭﺽ ﻓﻲ ﻫﺫﺍ ﺍﻟﺴﻴﻨﺎﺭﻴﻭ ﺃﻨﻨﺎ ﻓﻘﺩﻨﺎ ﺍلUSERS.DBF Datafile ﺍﻟﺫﻱ ﻴﻨﺘﻤﻲ ﺇﻟﻰ USERS TABLESPACE.
ﻭﻹﻨﺠﺎﺯ ﻋﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ ﻟﻬﺫﺍ ﺍﻟﺴﻴﻨﺎﺭﻴﻭ ﻫﻨﺎﻙ ﻁﺭﻴﻘﺘﻴﻥ :-
ﺍﻟﻁﺭﻴﻘﺔ ﺍﻷﻭﻟﻰ (Data File Recovery):-
ﻫﻨﺎ ﻨﻘﻭﻡ ﺒﻌﺩﺓ ﺨﻁﻭﺍﺕ:-
1- ﻋﻤل USERS01.DBF DATAFILE) Restore) ﻓﻘﻁ ﻤﻥ ﺁﺨﺭ Backup، ﺃﻱ ﻋﻤل ﻨﺴﺦ ﻟﻠﻤﻠﻑ ﻤﻥ ﺁﺨﺭ Backup ﺇﻟﻰ ﻤﻭﻀﻌﻪ ﺍﻷﺼﻠﻲ.
2- ﻨﻘﻭﻡ ﺒﻭﻀﻊ USERS01.DBF DATAFILE OFFLINE.
ALTER DATABASE DATAFILE 'D:\oradata\USERS١٠.D BF' OFILNE; |
3- ﻨﻘﻭﻡ ﺒﻌﻤل RECOVERY ﻟلUSERS.DBF DATAFILE.
alter database recover automatic datafile 'D:\oradata\USERS01.DBF'; |
4- ﺜﻡ ﻨﻘﻭﻡ ﺒﻭﻀﻊ ﺍلUSERS.DBF DATAFILE ONLINE.
ALTER DATABASE DATAFILE 'D:\oradata\USERS01.D BF' ONILNE; |
ﺍﻟﻁﺭﻴﻘﺔ ﺍﻟﺜﺎﻨﻴﺔ Tablespace Recovery:-
ﻫﻨﺎ ﻨﻘﻭﻡ ﺒﻌﺩﺓ ﺨﻁﻭﺍﺕ:-
1- ﻋﻤل Restore ﻟلUSERS01.DBF ﻓﻘﻁ ﻤﻥ ﺁﺨﺭ Backup، ﺃﻱ ﻋﻤل ﻨﺴﺦ ﻟﻠﻤﻠﻑ ﻤﻥ ﺁﺨﺭ Backup ﺇﻟﻰ ﻤﻭﻀﻌﻪ ﺍﻷﺼﻠﻲ.
2- ﻨﻘﻭﻡ ﺒﻭﻀﻊ ﺍلUSERS TABLESPACE OFFLINE.
ALTER TABLESPACE USERS OFFLINE; |
3- ﻨﻘﻭﻡ ﺒﻌﻤل TABLESPACE USERS RECOVERY.
RECOVER TABLESPACE USERS; |
4- ﻨﻘﻭﻡ ﺒﻭﻀﻊ USERS TABLESPACE ONLINE.
ALTER TABLESPACE USERS ONLINE; |
ﻴﻤﻜﻨﻙ ﺍﺴﺘﺨﺩﺍﻡ ﺃﻱ ﻤﻥ ﻫﺫﻩ ﺍﻟﻁﺭﻴﻘﺘﻴﻥ ﻟﻤﻌﺎﻟﺠﺔ ﻫﺫﺍ ﺍﻟﺴﻴﻨﺎﺭﻴﻭ، ﻭﻟﻜﻥ ﻋﻤﻭﻤﹰﺎ ﻟﻥ ﺘﻔﻘﺩ ﺃﻱ ﻤﻥ ﺒﻴﺎﻨﺎﺘﻙ ﻤﺎ ﺩﺍﻡ ﺍﻨﻙ ﻟﻡ ﺘﻔﻘﺩ Present Controlfile ﻭﺍلCurrent Redo Logfile،
ﺃﻱ ﺃﻨﻨﺎ ﻓﻲ ﻜل ﺍﻷﺤﻭﺍل ﺴﻨﻘﻭﻡ ﺒﻌﻤل Complete Recovery.
--------------------------------------------