How to perform step by step manual failover | Oracle Data Guard

[@rajatsanwal9919]

Arun sir, at 13:33 u r creating table and inserting data. But you are connected via sys user and such objects created are not shipped to standby , then why u shown example of creating table via sys schema?

[@dbaserhatcelik]

Hello Dear. I have a question. My enviroment information like this. A >Primary DB 12c B>First Physical Standby DB 12c C> Second Physical Standby DB 12c. We will perform failover test from A to B in my company. Temporary I will cancel MRP on C. After failover I will reinstate A using flashback technology there is no problem here. I will start MRP on A and there is no problem here, also. After tests are completed I will switchover from B to A. A will be primary and B will be standby as before. As you know after failover, B will have new incarnation and log numbers are reseted. After all tests if I start MRP on C, what will happen? I think that I will lost my C physical standby db. Because A and C will have different incarnation, right? If you clarify, appreciated!

[@ssoo1985]

Hey can you share doc link so that we can refer?

[@mahavishnu5498]

Fail over oprtaion its peform automatically in protection mode its Right I am wrong

[@tarunbhardwaj7967]

Dear Arun, does the database gets new incarnation(log sequence) in case of switchover too. I haven't performed switcher till now..

[@dbagenesis]

Why not perform once and check yourself !! It will be fun ;)

[@ssoo1985]

hi, any one have these docs and can share it please ??

[@dbagenesis]

www.support.dbagenesis.com/post/performing-manual-failover-on-physical-standby

[@nikitapatil9803]

Hey can you share doc link so that we can refer

[@naseemshaik32]

Hey can you share doc link so that we can refer

[@dbagenesis]

support.dbagenesis.com/knowledge-base/perform-manual-failover-on-physical-standby/