Vagrant: Create a Red Hat 8 base box packaged for Oracle 19c (Vbox)

Intro Vagrant is an opensource tool for working with virtual environments (VirtualBox,HyperV,Vmware..etc). It provides a simple command-line client for managing these environments, using a text-file (VagrantFile) defining the attributes of each environment.   To know more about vagrant you can try their getting started guide or consult the Vagrant official documentation. Vagrant cloud already offers a …

Clone a RAC 12c VM environment with Virtualbox (import/export)

  Intro Have you ever finished a lab in your laptop with several virtual machines connected to each other and thought “Well that was neat! but how can I create a backup in my external hard drive and run it again at work or in any other computer?” The answer lays in this very article. …

Oracle Cloud 2nd gen DBAAS Tutorial: Deploy a 2 Nodes RAC database service

Intro Oracle Database Cloud Service (DBaaS) provides a platform to create full Oracle database instances in a virtual machine (VM). It’s the same familiar Oracle Database, now in Oracle cloud. Oracle made things even easier since you can now Sign Up for Free Oracle Cloud service and Get $300 of free credits good for up …

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

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 …

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

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) …

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

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 …

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

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. » …

Restore standard naming of network interfaces on Red Hat enterprise linux 7

Disabling consistent network device naming To disable The consistent network device naming feature and create your own manual ma,ing scheme ,for example eth0,internet0 or lan0. Follow the below steps so that all network device names will be eth followed by an integer. Log in as root, or as a user with superuser privileges. Edit the GRUB 2 general settings file. …

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

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 …