We can create a new “Database Directory” without using existing database directories in the database. [crayon-67406bf6810de463244803/] We can view the directories that exist in the …

In today’s article, we will be learning about Oracle Data Pump Architecture. It has 4 important components. -expdp (export data pump) -impdp (import data pump) …

In today’s article we will be learning how to Performing SwitchOver. 1. First, we move the logs in our live database. (PRIMARY_1) [crayon-67406bf68183e440481054/] (PRIMARY_2) [crayon-67406bf681843102654675/] …

Today we will learn how to Automatically Connect Clients to New Primary in Role Changes (Client Connectivity – RAC). Management of database services in RAC …

In today’s article, I will explain how the Clients are Automatically Connected to the New Primary in Role Changes(SINGLE NODE). In case of Switchover or …

In order to make Failover from the broker, we need to set the Listener and TNS settings correctly. Listener and TNS files of a SINGLE …

The IP change procedure in a database that works as a RAC and is then downloaded to a single node due to the necessity of …

It may not be required to apply Redos to the Standby side immediately. In this case, the DelayMins in the Broker and the Delay parameter …

After installing Data Guard, we may need to make some adjustments for it to work effectively. For example, Let’s assume that we have a network …

The database upgrade stages with almost zero interruption from the current Data Guard configuration Single Node Primary and Physical Standby are as follows. 1. We …