Oracle 19c Data Guard on Windows Step By Step Setup

00:00 Introduction
12:00 Setup Environmental Variables
17:00 Create Listener
21:30 Create Primary Database
28:00 Setup DB Parameters on Primary
41:30 Duplicate Database as Standby
50:00 Verify Data Guard Configuration
52:00 Perform Some Transactions
55:00 (Optional) Switch over
1:02:00 (Optional) Switch back
1:06:10 Conclusion

Script Location

[edgardonb]

👏👏👏👏 congratulations. Now you have to do one to REactivate the standby when it stops in the different cases.

[billalhossain]

Your tutorial very helpful thank you very much..!!

[gravewassify]

Very helpful. need a tutorial on Data guard with RAC DB on windows

[derekfon]

Thank you so much for doing these videos, they've helped me in understand in great detail. Please can you do a video on how to install OEM on windows and how you would setup monitoring for the above Data Guard environment??? Would be greatly appreciated...🙏

[santoshjadhav-xezr]

how to resolve archive log gap 19c step by step please upload video

[vimalbisht]

I have a doubt. During the installation of any application, we provide information about the primary database to connect. If the primary database is down, how does the user application automatically switch the connection to the secondary database when we provide primary database details during the user application or software installation?

Regarding Data Guard, it copies data from the primary database and stores it in its own storage. So, if the primary database is down and the application is running on the frontend, where will the data be stored in the secondary database? How does this happen?

[suriyam]

Hi bro i have a doubt on creating the environment so can u please add that part of having the two like from the beginning it will be very useful bro can u do that!???