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
Recovery Manager (RMAN)
Control File Backup
ﻫﻨﺎﻙ ﻋﺩﺓ ﻁﺭﻕ ﻟﻌﻤل ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻟلControl File:
1- ﻋﻥ ﻁﺭﻴﻕ ﺍﻷﻤﺭ CURRENT CONTROL FILE .
RMAN> BACKUP AS COPY CURRENT CONTROLFILE; |
ﺃﻴﻀﺎﹰ ﻴﻤﻜﻥ ﻋﻤل ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻟلControl File ﻤﻥ ﺍﻟﻨﻭﻉ Backupset ﻭﺃﻴﻀﺎ ﻴﻤﻜﻥ ﻀﻐﻁﻪ ﺒﻭﺍﺴﻁﺔ ﺍﻷﻤﺭ Compressed Backupset.
2- ﻋﻥ ﻁﺭﻴﻕ ﺘﻬﻴﺌﺔ ﺍﻟﻤﺘﻐﻴﺭ CONTROLFILE AUTOBACKUP.
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; |
ﻋﻨﺩﻤﺎ ﻴﺄﺨﺫ ﺍﻟﻤﺘﻐﻴﺭ CONTROLFILE AUTOBACKUP ﺍﻟﻘﻴﻤﺔ ON ﻓﻬﺫﺍ ﻴﻌﻨﻰ ﺃﻨﻪ ﻜﻠﻤﺎ ﻗﻤﻨﺎ ﺒﻌﻤﻠﻴﺔ ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻓﺈﻨﻪ ﺁﻟﻴﺎﹰ ﺴﻴﺘﻡ ﻋﻤل ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻟﻤﻠﻑ ﺍلControl File.
ﻜﻤﺎ ﻴﻤﻜﻥ ﻋﻤل ﺍﺴﺘﻌﻼﻡ ﻋﻥ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻟلControl file ﺒﻭﺍﺴﻁﺔ ﺍﻷﻤﺭ
LIST BACKUP OF CONTROLFILE
-----------------------------------------