Oracle 19c Data Guard 02 Broker And Fast Start Failover

[@winnithrebello]

very well explained

[@khajaansari6162]

You explained it very nicely. I have a doubt regarding automatically reinstating Is it necessary to manually mount the old primary database after a failover? The old primary database is automatically reinstated as a standby database by observer.

[@DB2_Oracle]

In most cases observer will try to reinstate old primary. However there are scenarios where it will not be possible. Which is rare but possible. In which case you will have to manually perform these actions.

[@ashokgupta4605]

very clearly explained

[@manishjoshi2516]

Thanks a lot for sharing !!

[@kirankumar_badiger]

Hi Can we use multiple observers for high availability??

[@DB2_Oracle]

Yes, you can configure multiple observers. Maximum 3.

[@kirankumar_badiger]

@@DB2_Oracle Thank you for the info

[@kirankumar_badiger]

@@DB2_Oracle Can you please make a video on installing observers on different VM

[@sreenivasanatla8192]

what happens if there is gap and primary database went down

[@aise-te-pareto8524]

data guard broker sql is not there in dropbox sqls , this dropbox has all the sql from previous video. pls upload.

[@DB2_Oracle]

Its already uploaded.

[@aise-te-pareto8524]

can you please upload all sqls for broker related here in dropbox ,

[@aise-te-pareto8524]

dbca_oracle.rsp, setup_01_primary.sql, setup_02_primary.sql, setup_03_primary.sql, setup_04_dataguard_broker.sql, setup_05_fast_start_failover.sql ,..please upload these in dropbox.

[@DB2_Oracle]

I checked again and all the scripts are present.

[@lonelyheart666]

If we switchover or fast start failover, it means our application connect to IP or hostname of server standby? we have to change MANUALLY our application setting to IP or hostname of server standby?

[@DB2_Oracle]

Yes. However there is a concept of Services in Oracle and you can configure the services in such a way that that incase of failover, you do not have to change anything in the client.

[@MrWarbisshop]

@@DB2_Oracle do you have a example with your current setup /names ?

[@rajs4u123]

what it will do if stand by is went down, Will it reinitiate and start stand by?

[@DB2_Oracle]

Nothing. Fast start failover is meant to initiate the Failover. If Observer cannot connect to Standby, it does not do anything. You need to start the Standby manually.