Difference between Switchover and Failure in Data Guard

Difference between Switchover and Failure in Data Guard

Dost Muhammad Khalil Dost Muhammad Khalil

Dost Muhammad Khalil

Oracle Database Administrator (OCP) | MySQL DBA | SQL Server | PostgreSQL

发布日期: 2024年6月13日
+ 关注

In most of the interviews a question is asked related to Data Guard which is:

What is the difference between Switchover and Failure?

Now most of the time and most of the unexperienced candidates just answers this question

"Switchover is the role transition between Primary and Standby intentially While Failure is the role transition between Primary and Standby in situation of disaster."

I am 100% agree with this but I would like you all to add this as well that Incase of Switchover both the Primary and Standby are avaliable but incase of Failure the primary is not avaliable as it is destroyed with disaster so in Failure situation we have just Standby by has transitioned to Primary.

Summary of the discussion is that incase of Switchover both the Primary and Standby are avaliable while incase of Failure just standby is avaliable

which is transitioned to Primary.

Regards,

Dost Muhammad Khalil (OCP)

Atukuri Bharath Kumar

Oracle Applications Database Administrator @ Tecplix Technologies Pvt Ltd ? Oracle Apps DBA ? Project Management ? Incident and Change Management ? 8+ Years Exp ? Database Security & User Management ? 14K+ Connections

9 个月

Thanks for sharing

赞
回复

要查看或添加评论，请登录

Dost Muhammad Khalil的更多文章

  • Managing MySQL Error Log(mysqld.log) Growth in Production Environments
    2024年11月12日

    Managing MySQL Error Log(mysqld.log) Growth in Production Environments

    Asalam O Alakum! I recently encountered an interesting issue in my production environment that I thought would be…

    1 条评论
  • Issue Faced on Production (MySQL)
    2024年11月6日

    Issue Faced on Production (MySQL)

    Recently, I encountered a critical issue on my production environment that taught me a lot about database management…

    1 条评论
  • HOW TO TAKE RMAN BACKUP WHEN DATABASE IS IN OPEN MODE AND IN NOARCHIVELOG
    2024年8月1日

    HOW TO TAKE RMAN BACKUP WHEN DATABASE IS IN OPEN MODE AND IN NOARCHIVELOG

    Two days before I was assigned a task to take RMAN backup of a tablespace (MORCASZEMYAN) which was in Oracle 19c and…

  • Oracle Home Cloning
    2024年7月24日

    Oracle Home Cloning

    Todays Agenda : What is Home Cloning? How it is different from New Installation? Why it is required? How it can be…

    1 条评论
  • Denormalization in Databases
    2024年3月25日

    Denormalization in Databases

    Have you come across with the term Denormalization? Definetly you will but today we will try to understand the concept…

    1 条评论
  • Recovering RMAN Backup on Different Server and Different location with the same database name
    2024年1月23日

    Recovering RMAN Backup on Different Server and Different location with the same database name

    Document Convention: By the term Target we mean the new server & source we mean the server on which the database is…

  • DELETE vs TRUNCATE
    2024年1月19日

    DELETE vs TRUNCATE

    What is Difference between Delete & Truncate? Why Truncate is DDL although it flushes the data? Practical session?…

  • Column Level Encryption TDE
    2023年11月16日

    Column Level Encryption TDE

    Database Security ========================= Day 7th ========================= Column Level Encryption TDE…

  • Tablespace Level Encryption
    2023年10月26日

    Tablespace Level Encryption

    Database Security ========================= Day 6th ========================= Tablespace Level Encryption (TDE)…

  • Transparent Data Encryption
    2023年10月24日

    Transparent Data Encryption

    Database Security ========================= Day 5th ========================= Transparent Data Encryption (TDE)…

社区洞察

其他会员也浏览了