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: mallik034.blog...
LinkedIn: / mallikarjun-ramadurg-3...
twitter: / mallik034
instagram: / mallik034
RU-vid: / @mallik034
Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Blog: mallik034.blog...
LinkedIn: / mallikarjun-ramadurg-3...
twitter: / mallik034
Instagram: / mallik034
RU-vid: / @mallik034
26 авг 2024