RMAN -K Gowthami.pptx oracle dba ora db ora

rman ppt dba

1. 🎓 Presentation Title: Subtitle: MySQL Replication Presented by : p.anil Date: 16/10/2025

2. Introduction to MySQL Replication : What is replication? Why use replication in MySQL? Key benefits: High availability Load balancing Data redundancy Disaster recovery

3. Types of MySQL Replication : Statement - based replication (SBR) Row – based replication (RBR) Mixed based replication Asynchronus vs semisynchronous vs group replication

4. Incremental Backups: Incremental backups copy only the data blocks that have changed since a previous backup. This makes them faster and more space-efficient than full backups. Level 0 : Acts as the baseline for all future incremental backups. Command: BACKUP INCREMENTAL LEVEL 0 DATABASE; Level 1 : Backs up only the blocks that changed since the last Level 0 or Level 1 backup. Command: BACKUP INCREMENTAL LEVEL 1 DATABASE;

5. Tablespace Backup : Backs up specific tablespaces Useful for partial recovery scenarios Command: BACKUP TABLESPACE users; Datafile Backup: Targets individual datafiles Ideal for isolated file corruption or recovery Command: BACKUP DATAFILE 4 FORMAT '/backup/users_df4.bkp';

6. Control File Backup: Stores metadata about the database structure Manual backup (if autobackup is off) Command : BACKUP CURRENT CONTROLFILE; Archived Log Backup : Backs up redo logs for point-in-time recovery Helps manage log space with deletion Command : BACKUP ARCHIVELOG ALL DELETE INPUT;

7. Compressed Backup: Reduces backup size Saves storage and improves performance Command : BACKUP AS COMPRESSED BACKUPSET DATABASE; Best Practices : ✅ Enable CONTROLFILE AUTOBACKUP ✅ Use BACKUP OPTIMIZATION to skip unchanged files ✅ Schedule Level 0 weekly, Level 1 daily ✅ Store backups in multiple locations (local + offsite)

8. Summary : RMAN offers flexible, powerful backup options Choose backup types based on recovery needs Automate, validate, and test regularly A solid backup strategy = peace of mind