While the Export or Import process is in progress, we can switch to the interactive command line mode with Ctrl+C from the keyboard. We can …
Read More »Onur ARDAHANLI
Data Pump Jobs Kill
In today’s article, I will tell you how to Kill Data Pump Jobs in 3 steps. 1. First, Data Pump Jobs are listed. [crayon-6605f3322aeaf950444352/] 2. …
Read More »DataPump Commands
In today’s article, we will be learning DataPump Commands. 1. İmport: [crayon-6605f3322b334395927029/] 2. Export: [crayon-6605f3322b338238033223/] 3. Dump file size estimation: [crayon-6605f3322b33a157963709/] 4. Remap schema: [crayon-6605f3322b33b888134790/] …
Read More »Create Database Directory
We can create a new “Database Directory” without using existing database directories in the database. [crayon-6605f3322b55f786213678/] We can view the directories that exist in the …
Read More »Data Pump Architecture
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) …
Read More »Performing SwitchOver
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-6605f3322b991968273021/] (PRIMARY_2) [crayon-6605f3322b995077684389/] …
Read More »Client Connectivity – RAC
Today we will learn how to Automatically Connect Clients to New Primary in Role Changes (Client Connectivity – RAC). Management of database services in RAC …
Read More »Client Connect
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 …
Read More »Failover From Broker
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 …
Read More »Change The Server’s IP In The RAC Database
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 …
Read More »