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
Physical Backup & Recovery
Backup and Recovery Options
S.No |
Data Files |
Online Redo Logs |
Archived Redo Logs |
Control File |
Online Offiline |
Complete Incomplete |
Conclusion |
1 |
x |
x |
x |
x |
Offline |
Complete (as per last Backup) |
Only Restore Recovery is not possible Because we lost the archive logs also |
2 |
x |
x |
√ |
x |
Offline |
Incomplete |
Restor + Recovery until the last available archive log file |
3 |
x (Non system dbfs) |
√ |
√ |
√ |
Online |
Complete |
Restore + recovery lost datafiles |
4 |
x (system / undo dbfs) |
√ |
√ |
√ |
Offline |
Complete |
Restore + recovery |
5 |
√ |
x |
√ |
√ |
Offline |
Incomplete |
If all the members of a group are lost |
6 |
√ |
√ |
√ |
x |
Offline |
Could be complete or incomplete |
Complete if you recreate the ctl file. Incomplete if you recover from backup control file |
7 |
√ |
x |
√ |
x |
Offline |
Incomplete |
As both online logs & ctl files are lost |