Dataguard architecture || 19c Data Guard Basic Understanding? - Oracle Dataguard - 1

Подписаться 22 тыс.

Просмотров 32 тыс.

50% 1

Hi Friends,
Welcome you back on exciting topic, today’s session is on
Dataguard architecture || 19c Data Guard Basic understanding? - Oracle Dataguard - 1
=========================================================================
1) Primary and Standby:
2) The types of standby databases:
3) Oracle Data Guard Services:
4) Oracle Data Guard Protection Modes
5) Creating a Physical Standby Database
6) Creating a Logical Standby Database
7) DataGuard Process
Questions:
1. What all the secnario Standby DB will go out of sync?
--- Give me 4 scenarios
2. DB is hung because of archive_dest is full?
--- Give me 1 or 2 solutions
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

Опубликовано:

4 окт 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 30

@diptasaha6131 Год назад

Great Video to clear the basic idea & architecture of Oracle Dataguard

@Mallik034 Год назад

🙏

@hariprakash7071 3 года назад

For first question scenario 1 is archives at prod site gets deleted after backing up immediately by rman before waiting for log shipping to standby site . Scenario 2 there may be a space crunch on standby site at arch dest For second question one solution is to trigger archive log backup immediately to clear some space in arch dest Thanks for sharing your knowledge , it's clear to understand your videos

@raviy10 10 месяцев назад

Thank you !! Very detailed and Easy to follow

@Mallik034 9 месяцев назад

You are welcome

@eswar6311 2 года назад

Tnq so mallik for covered each nd evey details Eswar from vizag

@Mallik034 2 года назад

My pleasure 😊

@user-xh9kd2yk1e Год назад

Standby sync may fail due network issue connection, in some cases archive files are missed to copy to standby side because of logfile miss or dropped unexpected.

@sreeramya177 Год назад

Mallik Sir, Can you provide second part also... i have searched in ur vedios i didn't seen. Please provide second part link for my sake. Thanks alot for ur wonderful knowledge sharing..............hats off from all of our oracle dba's........

@BalvinderSingh-uh3my 3 года назад

Great video have you created part 2? I could not see it on your channel many thanks.

@NikhilKUMAR-ok9hu 3 года назад

Hi Mallik Sir, first of all thank you for sharing such short and simple videos on almost every topics. Just to point out that at 9:56 min of this video you said that to convert standby database into snapshot standby database it must be logical one, i think that is incorrect. We can convert physical standby database into snapshot and vice versa. Please correct me if i am wrong.

@Mallik034 3 года назад

Thats correct

@SK-lu9wk 4 года назад

Explaination of basic in a way of unique :) good one.

@Mallik034 4 года назад

Thank you so much.

@sureshkumar4915 4 года назад

good explaination. nice to share knowledge to all.

@Mallik034 4 года назад

@@sureshkumar4915 Yes true. Always share your learning lessons to others.

@kamalkannan164 2 года назад

Hi Mallik, This is really very good demo of DG we have refreshed once, Can you please share the document link , I could not see the doc.

@priyaachilukuri7940 2 года назад

The way you explain the content is amazing👏... But the audio is too low and sometimes not even herd... Kindly increase the volume for videos

@devilsgaming5915 3 года назад

Hi sir, Can we able to see the standby log sequence Of standby database from primary database

@mukidkhan952 4 года назад

Super session

@Mallik034 4 года назад

Thanks a lot Mukid. Please do watch my videos and inform you friends and colleagues

@dot7605 3 года назад

Nice,is it possible if you can upload second part.

@bharathkumar-ds8cd 4 года назад

Hi, one interview question,how to increase log applying to avoid delay. I checked google, 1. Increase mrp parallisum 2. Rman>configure archivelog deletion policy to applied on standby. Is there any other way. Please explain

@Mallik034 4 года назад

Nice question Bharath. I will answer for your question in my next videos. I am planning to make one video on complete questions and answers on datagurad. Some other interesting question to this are 1) How to apply delayed by 1 hours at my DR site 2) How to send logs to Standby site after 1 hour delay.

@nadunsamarasinghe5592 Год назад

Answer for Q2: Adding proper Archived log deletion polices in both Primary and Standby Instances by considering approach whether shifting or applying. Deleting applied archived logs from standby site after querying sequences order tread wise (if the primary is RAC) respectively.

@sreeramya177 Год назад

we need to change archive location when it is full.