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)
Tablespaces Backup
RUN{ ALLOCATE CHANNEL D1 DEVICE TYPE DISK MAXPIECESIZE 1G; BACKUP AS COMPRESSED BACKUPSET TABLESPACE USERS; } |
ﻗﻤﻨﺎ ﺒﻌﻤل ﻨﺴﺨﺔ ﺍﺤﺘﻴﺎﻁﻴﺔ ﻟلUSERS TABLESPACE ﻤﻥ ﺍﻟﻨﻭﻉ Compressed Backupset ﻭﻫﻭ ﻋﺒﺎﺭﺓ ﻋﻥ ﻨﺴﺨﺔ ﻤﻀﻐﻭﻁﺔ ﻤﻥ ﺍﻟﻨﻭﻉ Backupset،
ﻭﻗﺩ ﻗﻤﻨﺎ ﺒﺈﻨﺸﺎﺀ ﺍلChannel ﻴﺩﻭﻴﺎﹰ ﻭﺤﺩﺩﻨﺎ ﺃﻥ ﺍﻜﺒﺭ ﻨﺴﺨﺔ ﻤﻥ ﻗﻁﻊ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻴﺠﺏ ﺃﻥ ﻻ ﻴﺘﺠﺎﻭﺯ 1GB.
ﻋﻤﻭﻤﹰﺎ ﺨﻴﺎﺭ ﺍلCompressed Backupset ﻫﻭ ﺨﻴﺎﺭ ﻤﺘﺎﺡ ﻟﻨﺴﺦ ﺠﻤﻴﻊ ﺍﻟﻤﻠﻔﺎﺕ ﺍﻟﺘﻲ ﺘﺩﻋﻤﻬﺎ ﺍلRMAN ﻭﻤﻴﺯﺓ ﻫﺫﺍ ﺍﻟﺨﻴﺎﺭ ﺃﻨﻪ ﻴﻘﻠل ﻤﻥ ﺤﺠﻡ ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ.
ﻴﻤﻜﻥ ﺒﺎﻟﻁﺒﻊ ﻋﻤل ﻨﺴﺨﺔ ﺍﺤﺘﻴﺎﻁﻴﺔ ﻟلTablespace ﻤﻥ ﺍﻟﻨﻭﻉ Image Copy.
RMAN>BACKUP AS COPY TABLESPACE USERS; |
ﻴﻤﻜﻥ ﺍﻟﺘﺄﻜﺩ ﻤﻥ ﻨﺠﺎﺡ ﻋﻤﻠﻴﺔ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﺃﻋﻼﻩ ﺒﻭﺍﺴﻁﺔ ﺍﻷﻤﺭ
LIST BACKUPSET OF TABLESPACE USERS
ﻭﺫﻟﻙ ﻟﻌﺭﺽ ﻤﻌﻠﻭﻤﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻤﻥ ﺍﻟﻨﻭﻉ Users Tablespace Backupset
LIST COPY OF TABLESPACE USERS
ﻟﻌﺭﺽ ﻤﻌﻠﻭﻤﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻤﻥ ﺍﻟﻨﻭﻉ Users Tablespace Image Copy
---------------------------------