Oracle Data Guard Failover Vs Switchover

preview_player
Показать описание
In short, the #failover is the deformation of the production (primary) #database and activating #standby database as the #primary.
Switchover is the planned role change. So, primary database will operate as standby and standby will operate as primary database. Spare our database interoperability #testing, to do maintenance work in production (primary) database , etc. can make for things like #switchover.

00:00 Data Guard important components
00:51 Log shipping service
01:59 Log apply service
03:14 Data Guard important terms
04:03 Failover
05:05 Switchover
08:50 In sync
10:31 Gap
13:27 Log apply service

Рекомендации по теме
Комментарии
Автор

Can you make a video on how index rebuild and how gather stats is working and what is the use of it. I mean like how these things serve better the database and improve performance.

himanshugarg
Автор

Excellent Sir, Now One question apart from this.
Can You let me know how much minimum number of archives should be applied to open a database when we are performing a restoration of db on another server? It's help me alot as I have searched it on many sites but not got any solution...

himanshugarg
Автор

I guess by mistake you said buffers will move from primary to standby which actually you meant archive logs.

kuchbhikaho
Автор

Do we need to have primary and standby servers of same physical configuration. At times, if the standby server goes out of memory and the MRP process LAS stop working then how to handle the situation. Will adding ASM disk help here and GAP will be automatically taken care ?

gnadiger