Hello Friends,

Here with one more topic on.

Complete understanding of Oracle Database Backup and Recovery:
=========================================================
Backup:
Ground Rules for Backup and Recovery:

Types of Backup:
1. Logical backup - Table backup
2. Physical backup - OS files (Datafile) backup

Ways to perform backup:
1. User Managed
--- Cold Database Backup
--- Hot Database Backup
2. Recovery Manager RMAN

Backup states / Types:
1. Consistent Backup
2. Inconsistent Backup

Recovery:
1. Complete Recovery
2. Incomplete Recovery

Performing Cold Backup and Recovery:
Hot Database Recovery (All Datafiles were lost):
Hot Database Recovery (All Datafiles and Control files were lost):
Performing Hot Backup and Recovery (All Datafiles and Control files were lost) with Data:

RMAN:
- Recovery Manager
- Oracle Database backup and recovery automation
- It Introduced in Oracle 8i version
- It performs block level backup
- Parallelism
- Detecting corruption in datafiles
- Validating the backup
- Incremental Backup
- Recovery Catalog etc
- Multi Destination Backups
- Archive log mode is must to use RMAN

RMAN DB FULL back-up on Disk:

RMAN Backup Methodology:
- Full Backup
- Entire Database backup
- Cannot apply Incremental backup on full backup

- Incremental Backup
- Level 0 - FULL Database backup
- Level 1 - Backup changes only from last incremental backup


#RMAN #Backup #Recovery #oracle #database #ColdBackup #Hotbackup #ManualBackup #RMANbackup

Please do follow me and support me on,

Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter: https://twitter.com/mallik034
instagram: https://www.instagram.com/mallik034/
YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA

Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter:https://twitter.com/mallik034
Instagram:https://www.instagram.com/mallik034/
YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA