Farewell to ClickOps: OCI CLI seamless Data Guard Replication for ExaC@C

by CloudDudeUncategorizedPosted on Comments are Disabled

Intro Since the very beginning, everyone got introduced to  Cloud services through the console as it’s very quick. But the cloud CLI tooling provides a stronger, yet user-friendly way to automate tasks, often covering features not even available in the console. Moreover, DBAs often assume that the CLI is primarily designed for managing compute-based services, …

Read more “Farewell to ClickOps: OCI CLI seamless Data Guard Replication for ExaC@C”

MAA setup– Creating Single instance Physical Standby for RAC Primary – 12c

by CloudDudeUncategorizedPosted on Comments are Disabled

Introduction: Oracle provides many options for preventing downtime and data loss, all of which make up the Maximum Availability Architecture (MAA). The Oracle Maximum Availability Architecture offers a set of standard reference architectures–Bronze, Silver, Gold, and Platinum Solutions– that comply with Customer Business Objectives. With multiple instances, the RAC system gives a transparent HA and …

Read more “MAA setup– Creating Single instance Physical Standby for RAC Primary – 12c”

Deploying Oracle active Data Guard 12c on Windows servers Part II (Administration)

by CloudDudeUncategorizedPosted on Comments are Disabled

6.Data Guard Administration  In the Part II We will perform the following tasks in this lab to manage and validate the data guard configuration (followed in order). if you wonder  how we got here check the Part I :  Implementation 1. Configure the Data Guard Broker   2. Change the redo transport mode (via Broker/ sqlplus) …

Read more “Deploying Oracle active Data Guard 12c on Windows servers Part II (Administration)”

Deploying Oracle active Data Guard 12c on Windows servers part I

by CloudDudeUncategorizedPosted on Comments are Disabled

1. INTRODUCTION Data Guard started with a very simple database function designed to keep a synchronized database copy with a lot of manual work. It has now become a tool with automation, recovery and failover features. Oracle Data Guard remains the only solution available today with the best RPO and RTO benefits for businesses. This …

Read more “Deploying Oracle active Data Guard 12c on Windows servers part I”

Deploying Oracle active Data Guard 12c on Windows servers Part III (FAST START FAILOVER)

by CloudDudeUncategorizedPosted on Comments are Disabled

7. FAST START FAILOVER 7.1 CONFIGURATION FAST START FAILOVER Fast start failover allows Data Guard to automatically failover to a previously selected standby database without human intervention. Data Guard monitors the status of the configuration continuously and triggers a failover if necessary.This architecture makes the fast-start failover ideal for high availability and disaster recovery. » …

Read more “Deploying Oracle active Data Guard 12c on Windows servers Part III (FAST START FAILOVER)”

12c Data Guard : Resolve Log gap Error: ORA-16724: “cannot resolve gap for one or more standby databases”

by CloudDudeUncategorizedPosted on Comments are Disabled

This error happened while my Lab standby server was unreachable for few days. Although my setup was built on top of a Windows environment, the resolution process stays the same here for fixing this error (using an RMAN incremental backup) . For more details about the Data Guard setup used in this example please refer …

Read more “12c Data Guard : Resolve Log gap Error: ORA-16724: “cannot resolve gap for one or more standby databases””