Dataguard architecture || 19c Data Guard Basic Understanding? – Oracle Dataguard - 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,

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

[diptasaha]

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

[hariprakash]

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

[raviy]

Thank you !! Very detailed and Easy to follow

[eswar]

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

[xhkdyke]

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.

[sreeramya]

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 off from all of our oracle

[NikhilKUMAR-okhu]

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.

[BalvinderSingh-uhmy]

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

[nadunsamarasinghe]

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.

[SK-luwk]

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

[priyaachilukuri]

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

[kamalkannan]

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.

[devilsgaming]

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

[bharathkumar-dscd]

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

[dot]

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

[venkireddy]

Second part missing please upload 2part

[sreeramya]

we need to change archive location when it is full.