Тёмный
No video :(

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

Mallik034
Подписаться 21 тыс.
Просмотров 38 тыс.
50% 1

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

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 22   
@trieutruong2410
@trieutruong2410 Год назад
thank you, sir, your explanation helps me effortlessly understand RMAN concept and recovery solution
@ayoob999
@ayoob999 3 года назад
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
@Mallik034
@Mallik034 3 года назад
Sure definitely more to come in upcoming days
@user-mr8ij8gi7c
@user-mr8ij8gi7c Год назад
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.
@Mallik034
@Mallik034 11 месяцев назад
There several ways to copy file from asm storage to file system
@mdmujahid8761
@mdmujahid8761 3 года назад
Excellent
@narendrastudy4286
@narendrastudy4286 2 года назад
Very nicely explained 🙏🏻🙏🏻🙏🏻
@hindimusic5532
@hindimusic5532 Год назад
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.
@bharathkumar-ds8cd
@bharathkumar-ds8cd 4 года назад
Good explanation.
@Mallik034
@Mallik034 4 года назад
Glad it was helpful!
@RajnishKumar-tj1fl
@RajnishKumar-tj1fl 3 года назад
why cold backup, not hot backup in the ground rule of backup and recovery? Please explain the reason.
@337akshay
@337akshay 4 года назад
One question though! Are hot backup information stored anywhere? Like in the controlfile or any place else!
@Mallik034
@Mallik034 4 года назад
No, HOT backup information will not be logged anywhere inside database. This is one time activity that to performed using OS CP command and no need to store this backup information in side database.
@337akshay
@337akshay 4 года назад
Mallik034 thanks a lot...
@user-mr8ij8gi7c
@user-mr8ij8gi7c Год назад
Hot DB backup with RMAN *is* recorded in the control files. This allows RMAN to know status of what backups were recently performed, so incremental backups may be handled properly, based on earlier backup runs. This info is also critical for RMAN to allow restore/recovery when the database is not open... and this is one of the reasons that backing up your control files is so important for recovery of everything else with RMAN. The backups are not recorded in Oracles main tablespaces like System or Sysaux, because these are not usable If DB is broken, cannot open, and Oracle is only in mount status. There are some low level admin views to allow SYS DBA to view this control file information with SQL statements. If you are using an RMAN recovery catalog in a separate database, then RMAN backup activities for many servers can also be tracked/recorded there.
@Ongolupravallika
@Ongolupravallika Год назад
could plz share that ppt
@sairamakrishna5995
@sairamakrishna5995 3 года назад
Hi Malik can u upload realtime scenario like error in dataguard and patching
@Mallik034
@Mallik034 3 года назад
Sure its noted and will make some videos of DR patching
@amandeepgera4109
@amandeepgera4109 3 года назад
Better to show things practically.
@Mallik034
@Mallik034 3 года назад
Yeah sure noted