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.
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 ...............
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 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.
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.
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?
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.
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 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 ?
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
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.
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?
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.
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!
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 ?
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.
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.
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
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.
@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 .