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
Recovery Manager (RMAN)
Restore ControlFile and spfile
RESTORE CONTROLFILE:
ﻟﻌﻤل RESTORE CONTROLFILE ﻴﺠﺏ ﺃﻥ ﺘﻜﻭﻥ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﺍﻟﻭﻀﻊ NOMOUNT.
ﻟﺫﺍ ﺇﺫﺍ ﻓﻘﺩﻨﺎ ﺠﻤﻴﻊ ﻤﻠﻔﺎﺕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﻤﺎ ﻓﻲ ﺫﻟﻙ ﻤﻠﻔﺎﺕ ﺍلCONTROL FILE ﻓﺈﻥ ﺍﻟﺨﻁﻭﺓ ﺍﻷﻭﻟﻰ ﻨﻘﻭﻡ ﺒﻌﻤل RESTORE CONTROLFILE ﻓﻲ ﺍﻟﻭﻀﻊ NOMOUNT.
ﻭﻤﻥ ﺜﻡ ﻨﻘﻭﻡ ﺒﻌﻤل RESTORE AND RECOVER DATABASE ﺒﻌﺩﻤﺎ ﻨﻔﺘﺢ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﺍﻟﻭﻀﻊ MOUNT.
RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; |
ﻟﺫﺍ ﺃﻨﺼﺤﻙ ﻗﺒل ﺃﻥ ﺘﻘﻭﻡ ﺒﻌﻤل ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺃﻥ ﺘﻘﻭﻡ ﺒﺘﻬﻴﺌﺔ ﺍلCONTROLFILE AUTOBACKUP ﻭﺫﻟﻙ ﻜﺎﻟﺘﺎﻟﻲ:
CONFIGURE CONTROLFILE AUTOBACKUP ON
RESTORE SPFILE:
RMAN> RESTORE SPFILE TO ‘C:\database\TEST.ORA ’ FROM AUTOBACKUP; |
RECOVERY CATALOG:
ﺘﺤﺩﺜﻨﺎ سابقاً عن ﺍلRecovery Catalog ﻭﻫﻰ ﻋﺒﺎﺭﺓ ﻋﻥ ﻗﺎﻋﺩﺓ ﺒﻴﺎﻨﺎﺕ ﻤﻨﻔﺼﻠﺔ ﻴﺘﻡ ﻓﻴﻬﺎ ﺘﺨﺯﻴﻥ ﻤﻌﻠﻭﻤﺎﺕ ﻭﻫﻴﻜﻠﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﻤﺴﺘﻬﺩﻓﺔ
ﺒﺎﻹﻀﺎﻓﺔ ﻋﻥ ﻤﻌﻠﻭﻤﺎﺕ ﻋﻥ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﺒﻨﻭﻋﻴﻬﺎ (Backupset & Image Copy) ﻭﺃﻴﻀﺎﹰ ﻴﺤﻔﻅ ﻓﻴﻬﺎ ﺘﻬﻴﺌﺔ ﺍلRMAN، ﻭﺫﻜﺭﻨﺎ ﺃﻴﻀﺎﹰ ﺃﻨﻪ ﻴﻤﻜﻥ
ﺇﺩﺍﺭﺓ ﻤﺠﻤﻭﻋﺔ ﻤﻥ ﻗﻭﺍﻋﺩ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﻤﺴﺘﻬﺩﻓﺔ ﻋﻥ ﻁﺭﻴﻕ Recovery Catalog ﻭﺍﺤﺩﺓ، ﻤﻤﺎ ﻴﺴﻬل ﺇﺩﺍﺭﺓ ﻋﻤﻠﻴﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻭﺍﻻﺴﺘﺭﺠﺎﻉ.
ﻭﻤﺎ ﻟﻡ ﻨﺫﻜﺭﻩ ﺃﻨﻪ ﻴﻤﻜﻥ ﺍﻻﺴﺘﻔﺎﺩﺓ ﻤﻥ ﺍلRecovery Catalog ﻜﻤﺨﺯﻥ ﻟﺘﺨﺯﻴﻥ ﻤﺠﻤﻭﻋﺔ ﻤﻥ ﺍلScripts ﺍﻟﺘﻲ ﻴﻤﻜﻥ ﺘﻨﻔﻴﺫﻫﺎ ﻓﻴﻤﺎ ﺒﻌﺩ ﻋﻠﻰ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﻤﺴﺘﻬﺩﻓﺔ.
ﻭﺍلScripts ﻓﻲ ﺍﻟﺤﻘﻴﻘﺔ ﻫﻲ ﻤﺠﻤﻭﻋﺔ ﻤﻥ ﺍﻷﻭﺍﻤﺭ ﺍﻟﺘﻲ ﺘﻨﺠﺯ ﻤﻬﺎﻡ ﻤﻌﻴﻨﺔ ﻴﺘﻡ ﺇﻋﺩﺍﺩﻫﺎ ﻭﺘﺠﻬﻴﺯﻫﺎ ﺒﺤﻴﺙ ﻴﺘﻡ ﺘﻨﻔﻴﺫﻫﺎ ﻓﻴﻤﺎ ﺒﻌﺩ ﻋﻨﺩﻤﺎ ﻨﺤﺘﺎﺝ ﻟﺫﻟﻙ.
ﻭﻟﻨﻔﺘﺭﺽ ﺍﻵﻥ ﺃﻨﻨﺎ ﻨﺭﻴﺩ ﺘﺠﻬﻴﺯ Script ﺘﺴﻤﻰ TEST ﻤﻬﻤﺘﻪ ﺍﻟﻘﻴﺎﻡ ﺒﻌﻤل ﺍﺴﺘﻌﺭﺍﺽ ﻟﻬﻴﻜﻠﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﻤﺴﺘﻬﺩﻓﺔ،
ﻭﻻ ﺸﻙ ﺃﻥ ﺍﻷﻤﺭ ﺍﻟﺫﻱ ﻴﻘﻭﻡ ﺒﺎﺴﺘﻌﺭﺍﺽ ﻫﺫﻩ ﺍﻟﻬﻴﻜﻠﺔ ﻫﻭ REPORT SCHEMA.
CREATE SCRIPT:
RMAN> CREATE SCRIPT STR{ REPORT SCHEMA; } |
ﻗﻤﻨﺎ ﺒﺈﻨﺸﺎﺀ Script ﺘﺴﻤﻰ STR ﺘﻘﻭﻡ ﺒﻌﺭﺽ ﻫﻴﻜﻠﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﻤﺴﺘﻬﺩﻓﺔ.
PRINT SCRIPT:
RMAN> PRINT SCRIPT STR; |
ﻫﺫﺍ ﺍﻷﻤﺭ ﻟﻌﺭﺽ ﺍلScript ﺍﻟﺘﻲ ﻗﻤﻨﺎ ﺒﻜﺘﺎﺒﺘﻬﺎ ﺴﺎﺒﻘﺎﹰ.
EXECUTE SCRIPT:
RMAN> RUN{EXECUTE SCRIPT STR}; |
ﻫﺫﺍ ﺍﻷﻤﺭ ﻟﺘﻨﻔﻴﺫ ﺍلScript ﺍﻟﺘﻲ ﻗﻤﻨﺎ ﺒﺈﻨﺸﺎﺌﻬﺎ ﺴﺎﺒﻘﺎﹰ.
REPLACE SCRIPT:
RMAN> REPLACE SCRIPT STR { BACKUP DATAFILE 1;} |
ﻫﻜﺫﺍ ﻗﻤﻨﺎ ﺒﺘﻌﺩﻴل ﻤﻀﻤﻭﻥ ﺍلSCRIPT.
DELETE SCRIPT:
RMAN> DELETE SCRIPT STR; |
ﻫﺫﺍ ﺍﻷﻤﺭ ﻟﺤﺫﻑ ﺍلScript ﻤﻥ ﺍلRecovery Catalog.
Backup of Recovery Catalog:
ﻴﺠﺏ ﻋﻠﻰ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﻤﺤﺎﻓﻅﺔ ﻋﻠﻰ ﺍلRecovery Catalog ﻜﺠﺯﺀ ﻤﻥ ﻋﻤﻠﻪ، ﻭﺫﻟﻙ ﻷﻫﻤﻴﺔ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﺘﻲ ﺘﺤﺘﻭﻴﻬﺎ ﻭﺍﻟﺘﻲ ﺫﻜﺭﻨﺎﻫﺎ ﺴﺎﺒﻘﺎﹰ،
ﻟﺫﺍ ﻜﺎﻥ ﻋﻠﻰ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﻘﻴﺎﻡ ﺒﻌﻤل ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻟلRecovery Catalog ﻭﺫﻟﻙ ﺒﺄﺤﺩ ﺍﻟﻁﺭﻕ ﺍﻵﺘﻴﺔ:
1- ﻋﻤل ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻟﺠﻤﻴﻊ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﺘﻲ ﺘﺤﻭﻯ ﺍلRecovery Catalog.
2- ﻋﻤل ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻟلTablespace ﺍﻟﺫﻱ ﻴﺤﻭﻯ ﺍلRecovery Catalog.
3- ﻋﻤل ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻟلSchema ﺍﻟﺘﻲ ﺘﺤﻭﻯ ﺍلRecovery Catalog.
ﺒﺎﻟﻁﺒﻊ ﺇﺫﺍ ﺤﺩﺜﺕ ﻤﺸﻜﻠﺔ ﻓﻲ ﺍلRecovery Catalog ﻨﺴﺘﻁﻴﻊ ﻋﻤل ﺍﺴﺘﺭﺠﺎﻉ ﻟﻬﺎ ﻤﻥ ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ،
ﻭﻫﺫﺍ ﺍﻷﻤﺭ ﻴﻌﺘﻤﺩ ﻋﻠﻰ ﻨﻭﻉ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻭﻜﺫﻟﻙ ﻋﻠﻰ ﻨﻭﻉ ﺍﻟﻤﺸﻜﻠﺔ ﺍﻟﺘﻲ ﺤﺩﺜﺕ.
--------------------------------------------