Oracle 19c Data Guard 01 Step By Step Setup

[@truthhurts9601]

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.

[@DB2_Oracle]

This is great. Glad to hear that video helped you to setup Data Guard.

[@raveenahans1686]

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. :)

[@DB2_Oracle]

Thank you for nice comment.

[@pankajprakash5790]

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 ...............

[@DB2_Oracle]

Thank you for the comment and glad that it helped.

[@abuzeidmaher9220]

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

[@DB2_Oracle]

I checked the attached link and it was working fine. Check again and let me know if its not working. I have not done any changes.

[@fernandomori9351]

excellent explanation and creation..congratulations

[@sudhakarvennapusa3726]

Really it was nice session..

[@koteswarbalapanuru6222]

Hi i need clear documents on this

[@gotchihaeyo1825]

Thank you so much. Great work!!!🎉

[@UltraNewbieTech]

thanks for detail video

[@vansangvu7380]

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?

[@DB2_Oracle]

If you want to add a delay - ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DELAY 40; Autosync will happen automatically once you run LTER DATABASE RECOVER MANAGED STANDBY No need to do ALTER SYSTEM SWITCH LOGFILE manually however that was done so data can be shown on standby immediately in the tutorial. In real life, this command is not required.

[@vansangvu7380]

@@DB2_Oracle Thanks, my error because i set size of redolog standby too small (50M in oracle 19c), it's must be 100M or 200M so that syn data okie

[@huynhtruong5072]

Thank you very much

[@kirankumar-np7tc]

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

[@DB2_Oracle]

STANDBY_FILE_MANAGEMENT is only applicable on Standby Database. It has no effect on Primary Database. However, when you switch-over, that time, you will have to set it up on new Standby. And hence I have set it up on both.

[@kirankumar-np7tc]

Thank you sir🙏

[@saurabhsaxena4711]

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

[@DB2_Oracle]

Hi Saurabh, What exactly is your requirement? Do you want to stop Data Guard temporarily or make these database standalone again permanently?

[@saurabhsaxena4711]

@@DB2_Oracle Hi I have learnt how to make read only DR setup by your video, now if I want to revert back the DR setup what are the necessary step on Primary site.

[@RajasekarS-rp6ni]

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.

[@DB2_Oracle]

Thank you for pointing out.

[@olayiwolaayodele6400]

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

[@DB2_Oracle]

You can change the hostname after creation of DB. After setting up Data Guard as well. However, you will have to change listener.ora, tnsnames.ora and any init parameter where hostname is specified.

[@Actions_Only]

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

[@DB2_Oracle]

Will do. Soon.

[@neutrinosoup4953]

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!

[@DB2_Oracle]

No. You do not need to.

[@baskark1562]

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

[@DB2_Oracle]

Service name remains the same. You share port which is 1522. You can use 1521 if you want.

[@baskark1562]

@@DB2_Oracle Yes , can do it ..but switch over case which tns entry to connect to DB by Client ..prim - db1 and stdby - db2 so host has db1 and share to Client with db1 after switch over host has changes to db2 as prim to my understand , now client not able to connect DB because host is different now ..so in this case do we need to use DNS ?

[@tolatonh1267]

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?

[@rokroll]

Well done. Thanks

[@r7_guy941]

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 ?

[@DB2_Oracle]

Principle of DataGuard remains same. However there are small tweaks needed to get this working on RAC. I have not recorded such video. But my laptop is not so powerful to have 5 machines running. 3+2. Maximum I have run is three. I can try to do 2Node RAC to 2 Node RAC. I will not be able to do 3 to 2.

[@ShivaKumar-dn8zm]

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

[@DB2_Oracle]

I want to make my videos shorter and hence did like this. People lose interest when Videos are too long.

[@nikunjgupta3086]

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.

[@DB2_Oracle]

Standby can be at higher version however only for upgrade purpose. Or in other words, this config is not supported.

[@publicpeoples7780]

Which passed I need to give from sys/password@orap and oras

[@DB2_Oracle]

password of sys user /password (this is the password of the sys user in my setup)

[@publicpeoples7780]

Thankyou bro which passwd we need to enter?

[@SuperOldWhiteguy]

😁great Job thank you so much

[@boscot5274]

Hello Sir, Well explained how the Oracle database, RAC and Data guard installation and configuration with working session Could you please help me - Oracle RAC with Oracle ASM and Data Guard for SAP

[@DB2_Oracle]

I have no idea on SAP NEVER WORKED ON SAP

[@mohdajazhussainfarooqui2759]

Excellent

[@Sonex1542]

Thank you so much for this.... maybe next time a bit slower.

[@DB2_Oracle]

Sure. Will be slower.

[@aheckman]

You can slow down the playback speed - click settings gear on the video.

[@publicpeoples7780]

Hi bro i need to install rdbms and gridsetup standby server also

[@DB2_Oracle]

Same steps as you setup in RAC. If you know how to setup in RAC, you can do that is standalone server

[@basavarajpatil5574]

Hi, while enabling the LOG_ARCHIVE_DEST_STATE_2=ENABLE; I am getting below error, can someone help how to fix this. ORA-16028: new LOG_ARCHIVE_DEST_STATE_2 causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires

[@DB2_Oracle]

What is the value of LOG_ARCHIVE_MIN_SUCCEED_DEST?

[@basavarajpatil5574]

Hi@@DB2_Oracle , the value of LOG_ARCHIVE_MIN_SUCCEED_DEST? is 1, but I am also not able to edit this parameter.

[@vimalbisht2430]

Kuch bhi smjh nhi aaya....

[@DB2_Oracle]

If you did not yesterstand, I am really sorry. I am not sure how to make it better. Just a small tip: There are many other videos on same topic and you can follow the same if my way of learning does not help.

[@vimalbisht2430]

@@DB2_Oracle actually agr ye windows mei hota to sayad smjh aata sirf mujhe.... But saari video data gaurd ki Linux mei hi q hai

[@DB2_Oracle]

@@vimalbisht2430 So basically you want DataGuard on Windows.. on One Server or Two Servers?

[@vimalbisht2430]

​@DB2_Oracle yes bro, i tried to search data guard on windows based os but there is no such a video available. In my case my lots of clients using win os .

[@DB2_Oracle]

@@vimalbisht2430 I understand and its coming your way.

[@ramakrishnavelaga3157]

Sir too fast