Oracle GoldenGate (OGG), Configuration & Simple Test in our Test ENV Step by Step Procedure to Setup of the OGG Configuration & Tested with simple table in our test ENV, I Have used the below two machine in single instance Oracle DB 11g (11.2.0.4) In the following configuration I have used the following Hosts and Read More

Restore the Oracle database Procedure Copy the datafiles, archivelog files and controlfile to restore backup location Set the SID of the restore database in .bash_profile and run the bash profile — $. .bash_profile Crosscheck the existing backup restore, if any expired, delete those backup… Read more..

Data Guard Broker Configuration (DGMGRL Utility) Data Guard broker configuration using the command line dgmgrl interface,  Below are the step by step procedure tested & verified in our Test ENV Primary Database: PR Standby Database: STD Set the below parameter as on both… Read more..

Perform the Switchover in our Test DB ENV Primary database – IP (10.0.0.1) ===================================== Before Switchover from primary to standby ===================================== SQL> select name,open_mode,database_role from v$database; NAME      OPEN_MODE            DATABASE_ROLE ———… Read more..

Configure the Multiple Listener Port in Oracle DB & Tested in our Environment Configure Port 1521 – Default port Configure Port 1522   – Port Added by request from client $cd $ORACLE_HOME/network/admin/vi listener.ora LISTENER1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL… Read more..

Expdp from Higher version 12c (12.1.0.2) to lower version 11g (11.2.0.4) Export on 12c (12.1.0.2)   – Tested in our env : 10.20.0.82 SQL> select instance_name,version from v$instance; INSTANCE_NAME    VERSION —————- —————– … Read more..