Complete Understanding of Oracle Database Backup and Recovery - Cold, Hot, Manual and RMAN Backup

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,

Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]

[trieutruong]

thank you, sir, your explanation helps me effortlessly understand RMAN concept and recovery solution

[ayoob]

very help full videos specially for Freshers an also I want you to share some more videos or Demo on RMAN Backup an performing Disaster Recovery ... Thanks

[mrijgic]

When you explain cold backups at 5:50, how do you expect DBA backup to copy all the physical database files and tablespaces for cold backup, Since most Oracle databases use ASM storage for tablespaces, in last 8yrs..?
I dont think "cp" copy command can reach ASM files.. and O/S level backup utilities dont reach ASM either.

[RajnishKumar-tjfl]

why cold backup, not hot backup in the ground rule of backup and recovery? Please explain the reason.

[hindimusic]

Good morning Mallik garu,
I have L0 backup in +DATA ..can I use this backup and RECOVERY/RESTORE THE DATABASE TO TEST MACHINE WHICH IS NON ASM .DO YOU HAVE ANY VEDIOS PLEASE LET ME KNOW SIR.

[akshay]

One question though! Are hot backup information stored anywhere? Like in the controlfile or any place else!

[sairamakrishna]

Hi Malik can u upload realtime scenario like error in dataguard and patching