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)
Data Files Backup
ﺘﺴﺘﻁﻴﻊ ﻋﻥ ﻁﺭﻴﻕ ﺍلRMAN ﻋﻤل ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻟﻤﻠﻔﺎﺕ ﺍلData Files ﺒﺸﺭﻁ ﺃﻥ ﺘﻜﻭﻥ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﺍﻟﻭﻀﻊ Mount or Open،
ﺃﻤﺎ ﺍلRecovery Catalog Database ﻓﻴﺠﺏ ﺃﻥ ﺘﻜﻭﻥ ﻤﻔﺘﻭﺤﺔ، ﻭﻫﻨﺎﻙ ﻋﺩﺩ ﻤﻥ ﺍﻟﺨﻴﺎﺭﺍﺕ ﻟﻌﻤل ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ (Backup) ﻟلData Files:
1- Data Files Backup as Backup Set.
RMAN> BACKUP AS BACKUPSET DATAFILE 1,2 TAG ‘FILE(1,2)’; |
ﻻﺤﻅ ﻟﻘﺩ ﻗﻤﺕ ﺒﻌﻤل ﻨﺴﺨﺔ ﺍﺤﺘﻴﺎﻁﻴﺔ ﻟﻜل ﻤﻥ(2&1)Datafile ﻭﺍﻟﺭﻗﻡ 1 ﻭ 2 ﻋﺒﺎﺭﺓ ﻋﻥ ﺍلFile ID.
ﺒﺎﻟﻁﺒﻊ ﻴﻤﻜﻥ ﻜﺘﺎﺒﺔ ﺍﺴﻡ ﺍلData File ﺒﺩﻻﹰ ﻤﻥ ﻜﺘﺎﺒﺔ ﺍلFile_Id، ﻴﻤﻜﻨﻙ ﻤﻌﺭﻓﺔ ﺍلFile_Id ﻋﻥ ﻁﺭﻴﻕ :
ﺍﻻﺴﺘﻌﻼﻡ ﺍﻟﺘﺎﻟﻲ:
SELECT FILE_NAME,FILE_ID FROM DBA_DATA_FILES; |
ﻜﻤﺎ ﻗﻤﻨﺎ ﺒﻌﻤل ﺘﺴﻤﻴﺔ ﻤﻨﻁﻘﻴﺔ ﻟﻬﺫﺍ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﺒﻭﺍﺴﻁﺔ ﺍﻟﻤﺘﻐﻴﺭ TAG ﻭﺴﻤﻴﻨﺎﻩ (1,2)FILE ﻜﻤﺎ ﻫﻭ ﻤﻭﻀﺢ،
ﻜﻤﺎ ﻴﻤﻜﻨﻙ ﻤﻼﺤﻅﺔ ﺃﻨﻨﺎ ﻟﻡ ﻨﻘﻡ ﺒﺈﻨﺸﺎﺀ ﻗﻨﻭﺍﺕ ﻟﻠﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻴﺩﻭﻴﺎﹰ Channels ﻭﺇﻨﻤﺎ ﻗﺎﻤﺕ ﺍلRMAN ﺒﺎﺴﺘﺨﺩﺍﻡ ﺍﻟﺘﻬﻴﺌﺔ ﺍﻵﻟﻴﺔ Configuration Setting.
ﻋﻤﻭﻤﹰﺎ ﻴﻤﻜﻨﻨﺎ ﺍﻟﺘﺄﻜﺩ ﻤﻥ ﻋﻤﻠﻴﺔ ﻨﺠﺎﺡ ﻋﻤﻠﻴﺔ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﺒﻭﺍﺴﻁﺔ ﺍﻷﻤﺭ LIST ﺤﻴﺙ ﻴﻘﻭﻡ ﺒﻌﺭﺽ ﺘﻔﺎﺼﻴل ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ،
ﻓﺈﺫﺍ ﻜﺘﺒﻨﺎ LIST BACKUPSET SUMMARY ﻴﻘﻭﻡ ﻫﺫﺍ ﺍﻷﻤﺭ ﺒﻌﺭﺽ ﺠﻤﻴﻊ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﺍﻟﻤﺨﺯﻨﺔ ﻓﻲ ﺍلRecovery Catalog ﻤﻥ ﺍﻟﻨﻭﻉ Backup Set ،
ﺃﻤﺎ ﺍﻷﻤﺭ LIST COPY ﻟﻌﺭﺽ ﺘﻔﺎﺼﻴل ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﻤﻥ ﺍﻟﻨﻭﻉ IMAGE COPY ﻭﻏﻴﺭﻩ ﻤﻥ ﺍﻷﻭﺍﻤﺭ ﺍﻟﺘﻲ ﺴﻨﺘﺤﺩﺙ ﻋﻨﻬﺎ ﻻﺤﻘﺎﹰ،
ﻤﺎ ﻴﻠﺯﻤﻨﺎ ﺍﻵﻥ ﺍﻟﺘﺄﻜﺩ ﻤﻥ ﺍﻟﻨﺴﺨﺔ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﺍﻟﺘﻲ ﻗﻤﻨﺎ ﺒﻬﺎ ﺍﻵﻥ ﻭﻻﺤﻅ ﺃﻥ ﺍﺴﻤﻬﺎ ﺍﻟﻤﻨﻁﻘﻲ "(1,2)FILE" ﻓﻴﻤﻜﻥ ﻋﺭﺽ ﺘﻔﺎﺼﻴﻠﻬﺎ ﺒﻭﺍﺴﻁﺔ ﺍﻷﻤﺭ
"(LIST BACKUPSET TAG FILE "(1,2
ﺃﻤﺎ ﺇﺫﺍ ﻟﻡ ﺘﻀﻊ ﺍﺴﻡ ﻤﻨﻁﻘﻲ ﻟﻠﻨﺴﺨﺔ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﻓﺎﻥ ﺍلRMAN ﺴﺘﻀﻊ ﻟﻪ ﺍﺴﻡ ﻤﻨﻁﻘﻲ ﺃﻟﻴﺎﹰ، ﻜﻤﺎ ﻴﻤﻜﻨﻙ ﻋﺭﺽ ﻤﻌﻠﻭﻤﺎﺕ ﺍﻟﻨﺴﺨﺔ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﺍﻟﺴﺎﺒﻘﺔ ﺒﻭﺍﺴﻁﺔ ﺍﻷﻤﺭ
LIST BACKUP OF DATAFILE ١,٢
RMAN>LIST BACKUPSET TAG “FILE(1,2)”; |
2- Data Files Backup as Image Copy
RUN { ALLOCATE CHANNEL D1 DEVICE TYPE DISK; ALLOCATE CHANNEL D2 DEVICE TYPE DISK; BACKUP AS COPY DATAFILE 3,4 (DATAFILE 3 CHANNEL D1) (DATAFILE 4 CHANNEL D2) ; } |
ﻗﻤﻨﺎ ﺒﻌﻤل ﻨﺴﺨﺔ ﺍﺤﺘﻴﺎﻁﻴﺔ ﻟل(3,4)Data Files ﻤﻥ ﺍﻟﻨﻭﻉ Image Copy ﻭﻗﺩ ﻗﻤﻨﺎ ﺒﺈﻨﺸﺎﺀ ﻗﻨﺎﺘﻴﻥ Channels ﻴﺩﻭﻴﺎﹰ ﻭﻗﻤﻨﺎ ﺒﺈﺭﺴﺎل ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﺇﻟﻰ ﺍﻟﺩﻴﺴﻙ.
ﻴﻤﻜﻥ ﺍﻟﺘﺄﻜﺩ ﻤﻥ ﻨﺠﺎﺡ ﻋﻤﻠﻴﺔ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﺒﻭﺍﺴﻁﺔ ﺍﻷﻤﺭ
LIST COPY OF DATAFILE 3,4
RMAN>LIST COPY OF DATAFILE 3,4; |
---------------------------------