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)
Archived Redo Log Files Backup
RUN{ ALLOCATE CHANNEL D1 DEVICE TYPE DISK; ALLOCATE CHANNEL D2 DEVICE TYPE DISK; ALLOCATE CHANNEL D3 DEVICE TYPE DISK; BACKUP AS copy archivelog all DELETE ALL INPUT; } |
ﻗﻤﻨﺎ ﺒﻌﻤل ﻨﺴﺨﺔ ﺍﺤﺘﻴﺎﻁﻴﺔ ﻟﺠﻤﻴﻊ ﻤﻠﻔﺎﺕ ﺍﻷﺭﺸﻴﻑ ﻭﻤﻥ ﺜﻡ ﺤﺫﻑ ﺍﻟﻤﻠﻔﺎﺕ ﺒﻌﺩ ﻨﺴﺨﻬﺎ ﻭﺫﻟﻙ ﻷﻨﻨﺎ ﻻ ﻨﺤﺘﺎﺝ ﺇﻟﻴﻬﺎ ﺍﻵﻥ،
ﻭﻤﺘﻰ ﻤﺎ ﺍﺤﺘﺠﻨﺎ ﻟﻬﺎ ﺴﻨﺠﺩﻫﺎ ﻓﻲ ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ، ﻻﺤﻅ ﺃﻨﻨﺎ ﻗﻤﻨﺎ ﺒﻌﻤل ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻟﻜل ﻤﻠﻔﺎﺕ ﺍﻷﺭﺸﻴﻑ،
ﺃﻨﺕ ﻴﻤﻜﻥ ﺃﻥ ﺘﻘﻭﻡ ﺒﻌﻤل ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻟﻤﻠﻔﺎﺕ ﺍﻷﺭﺸﻴﻑ ﺍﻟﺘﻲ ﺘﺤﺘﺎﺠﻬﺎ.
RMAN> RUN{ ALLOCATE CHANNEL D1 DEVICE TYPE DISK; ALLOCATE CHANNEL D2 DEVICE TYPE DISK; ALLOCATE CHANNEL D3 DEVICE TYPE DISK; BACKUP AS copy Archivelog until sequence 130; } |
ﻴﻤﻜﻨﻙ ﺍﻟﻘﻴﺎﻡ ﺒﻌﺭﺽ ﻤﻌﻠﻭﻤﺎﺕ ﻋﻥ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﻟﻤﻠﻔﺎﺕ ﺍﻷﺭﺸﻴﻑ ﺒﻭﺍﺴﻁﺔ ﺍﻷﻤﺭ
LIST COPY OF ARCHIVELOG ALL
ﻭﺫﻟﻙ ﻟﻌﺭﺽ ﻤﻌﻠﻭﻤﺎﺕ ﻋﻥ ﺠﻤﻴﻊ ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻤﻥ ﺍﻟﻨﻭﻉ Image Copy ﻟﻤﻠﻔﺎﺕ ﺍﻷﺭﺸﻴﻑ.
ﻜﻤﺎ ﻴﻤﻜﻨﻙ ﺍﻟﻘﻴﺎﻡ ﺒﻌﺭﺽ ﻤﻌﻠﻭﻤﺎﺕ ﻋﻥ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﻟﺒﻌﺽ ﻤﻠﻔﺎﺕ ﺍﻷﺭﺸﻴﻑ
RMAN>LIST COPY OF ARCHIVELOG UNTIL SEQUENCE 130; |
----------------------------------------