Oracle 19c Data Guard 01 Step By Step Setup

Link to Document and Scripts:

[truthhurts]

Thanks a Lot.. though I am experienced apps DBA, never got chance to work on dataguard.. thanks to you, now I am able to setup my primary and standby dataguard environment on my laptop.

[raveenahans]

Superb session. Very well explained and presented!!! Thanks a ton for such a great session. Came across really a nice stuff I was looking for. :)

[fernandomori]

excellent explanation and creation..congratulations

[pankajprakash]

Thanks a lot, it was very helpful for me. I have seen many videos but finally got this. Now all things are clear. thanks for sharing nots

[senesiethomas]

Database guy thank you for this great work. I am incredibly thankful for sharing what you know with us.

I am also an oracle dba and I have been working on deploying a DG environment using ansible while I see the log switches on the primary applied to the standby, when I check the switchover status of the standby it shows “NOT ALLOWED” just like the first part of your testing for the switchover, I wonder what is the problem and when I test db verify for primary it works but for standby it gives some error. Is there a catch to this brother that you see that I may not ?

I am just working on automation the full deploying DG using ansible in my test environment before I push it out

[tolatonh]

hell sir, do we backup db from primary and restore to standby and change unique name ? I am not sure about changing unique name sir. could you help explain abit sir?

[abuzeidmaher]

Hello, Thanks for your efforts, ,Could you share the DOC as the attached link not working .
Thanks

[saurabhsaxena]

Hi your videos are very helpful, please also make one video on how to deconfigure the oracle data guard on windows.

[olayiwolaayodele]

Please if i change the host name for my db, doest it have any implication.

[vansangvu]

thanks a lot, so how to config auto switch log file.

I Insttall success with option "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;"

And must run manual ALTER SYSTEM SWITCH LOGFILE; --> data must see in standby databse

I want that auto syn and have config time delay. Can you help me resolve that?

[Actions_Only]

Nice video...please upload the video 12c to 19c upgrade..

[kirankumar-nptc]

I think standby file management auto no need to configure on standby ?

[fahdbahoo]

Why you created standby control file, you did not create standby control file on windows dataguard video

[neutrinosoup]

Thank you for the very informative video. Do you still have to modify local_listener if you choose to keep the default port number? If you do need to modify it, can you please explain why? Thanks!

[RajasekarS-rpni]

At one place it was defined as DB_UNIQUE_NAME=orap' --- note there is just a single quote
at the end. -- which is why it showed as two entries. typo issue.

[nikunjgupta]

Can we create the Data guard with Oracle 19.16(Primary) and Oracle 19.17(standby)?
In OCI DB system it will create the standby with latest Patch version only.

[baskark]

1521 is the one default port for DB connection, you setup with 1522 port into prim, stadby and second stby suppose how the client connect to the DB which service name to share with them, whether we need to enable 1521, 1522 port access through n/w ..generally we always use 1521 so just thinking about 1522 from n/w area . You'r DG video can easily understandable without any doubt .thank you so much for sharing this

[r_guy]

Hi Sir thank you for this video, . Is the procedure the same to implement dataguard where the source db is a 3 node RAC and the target db is a 2 node RAC ? Do you have a video or example about this ?

[ShivaKumar-dnzm]

pls execute the each command that are mentioned in the sql scripts step by step so that we can see step by step execution and will get deeper understanding

[BoBoMaung-bn]

I can't download documents file.
Pls kindly share it.