Learn from Videos

Understanding Oracle and High Availability

Ashish Agarwal Goldengate Tutorials

The channel is dedicated to Oracle Goldengate related videos. Oracle Goldengate is a replication tool which allows real time replication.

Contact Me -
Call/WhatsApp@+14168715708
Email - Email @ashishagarwalag@gmail.com
LinkedIn - linkedin.com/in/ashishagarwalag


#ogg, #cloud, #goldengate, #databaseadministration, #Ashish_Agarwal_Goldengate_Tutorials, #goldengatetutorials, #ashishtutorials

Ashish Agarwal Goldengate Tutorials
in this video we discuss regarding different available architectures of Oracle Goldengate and Veridata.There are two types of Golden Gate architecture:1- Classic Architecture2- Microservices ArchitectureA. Classic Architecture : It is command prompt based Architecture and is available for oracle as well as non oracle platforms.In classic Architecture there are different type of processes which are Extract processes and Replicat processes. Goldengate is a change data capture tool. Whatever changes are happening in the databasethose changes are stored in redo logs of database. Goldengate source are redo logs or archive logs of a database. Goldengate processes capture the data from source database and applied it to targetdatabase.B. Microservices Architecture : It was introduced in 2017 and you manage it through GUI and it is available on cloud integration as well. Until today microservices is available for Oracle Databases only.C. Oracle Goldengate Veridata : Oracle Golden Gate has another tool called Veridata. It is a separate licensed tool and is used to verify data. It doesn’t need any downtime while verifying the data.D. In single license we get to work with both classic and Microservices architechture. For working with veridata seperatelicense is required.
Oracle Goldengate Family (Classic Architecture,Microservices and Veridata)
This is the Day 2 session recording of 30 day learning Oracle Goldengate challenge started from 9th oct 2024. Day 1 ession can be watched over below link:https://youtu.be/9_VOMIb92EU?si=Gt8kApsGZwkaVm_tRecap of Oracle Goldengate Classic Architecture 19c Session 2: ============================================================== A. Oracle Goldengate Architecture - How data flows in Goldengate? All the processes in Goldengate work independently from each other however they depend on each other for reading the data. We call capture process as extract process as well. There are two types of extract processes. 1- Classic Extract process 2- Integrated Extract processClassic extract is there since beginning . Capture process is external to database and it reads the data in sequential manner and capture only committed transaction. In integrated capture log minor build happens and logminer sends changes in the form of LCR to the Extract process. Performance of integrated capture is very high and much faster than classic capture. It creates less load on the database as well.+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ B.1. The Goldengate training VM Has 19c Database and 21c OGG Binaries are present in /home/oracle/softwares 2. For Goldengate binaries download, Before download and install Install , make a note of below Source : DB Type , Version , Platform Target : DB Type , Version , PlatformC.Before you proceed with download and installation , always Check the certification matrix-Follow the instructions to download the GG from OTN Check for system requirement and supported platform for oracle goldengate version we are installing use link : https://www.oracle.com/middleware/technologies/fusion-certification.html-After copying the Software , invoke the runInstallerBefore proceeding with installation u need to define location where to install. You may install GG in: Seperate mount point: Existing mount pointTo consider how much space u need for installation, Understand the requirement. Do Research and designHardware requirements: 1. CPUs- 4 or 8 cores  2. Space requirement/mount point size- Whether u want to add new mount point (/goldengate) or use exising mount point(/u01) Space Calculation: 30/60 days day wise archive log generation. 20GB 1 GB 100 MB 100 GB Average of 7 days highest archive log generation -25 GB*7=175 GB *2=350-500 GB of space 3. Which OS user to use to install Goldengate (oracle or any other user ggadmin/gguser) DBAs -oracle Goldengate and DBA responsiblities are seggreagted then - gguser/ggadmin (oinstall group)Post-session assignment: 1) complete lab setup for both VMs 2) install OGG on ggate1 and ggate2
Oracle Goldengate Processes and Installation Requirements
in this video we discuss regarding Oracle Database Architecture and how Goldengate reads data from Oracle Database
How Oracle Goldengate reads data from Oracle Database
This is the Day 1 session recording of 30 day learning Oracle Goldengate challenge started from 9th oct 2024. In this session we discussed below:Recap of Oracle Goldengate Classic Architecture 19c Session 2: ============================================================== A. Oracle Goldengate Architecture - How data flows in Goldengate? All the processes in Goldengate work independently from each other however they depend on each other for reading the data. We call capture process as extract process as well. There are two types of extract processes. 1- Classic Extract process 2- Integrated Extract processClassic extract is there since beginning . Capture process is external to database and it reads the data in sequential manner and capture only committed transaction. In integrated capture log minor build happens and logminer sends changes in the form of LCR to the Extract process. Performance of integrated capture is very high and much faster than classic capture. It creates less load on the database as well.+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ B.1. The Goldengate training VM Has 19c Database and 21c OGG Binaries are present in /home/oracle/softwares 2. For Goldengate binaries download, Before download and install Install , make a note of below Source : DB Type , Version , Platform Target : DB Type , Version , PlatformC.Before you proceed with download and installation , always Check the certification matrix-Follow the instructions to download the GG from OTN Check for system requirement and supported platform for oracle goldengate version we are installing use link : https://www.oracle.com/middleware/technologies/fusion-certification.html-After copying the Software , invoke the runInstallerBefore proceeding with installation u need to define location where to install. You may install GG in: Seperate mount point: Existing mount pointTo consider how much space u need for installation, Understand the requirement. Do Research and designHardware requirements: 1. CPUs- 4 or 8 cores  2. Space requirement/mount point size- Whether u want to add new mount point (/goldengate) or use exising mount point(/u01) Space Calculation: 30/60 days day wise archive log generation. 20GB 1 GB 100 MB 100 GB Average of 7 days highest archive log generation -25 GB*7=175 GB *2=350-500 GB of space 3. Which OS user to use to install Goldengate (oracle or any other user ggadmin/gguser) DBAs -oracle Goldengate and DBA responsiblities are seggreagted then - gguser/ggadmin (oinstall group)Post-session assignment: 1) complete lab setup for both VMs 2) install OGG on ggate1 and ggate2
Oracle Goldengate Introduction and Different Architectures of oracle Goldengate
This is the recording of online webinar on OGG Basics and Practical Demo of Installation session coducted on 6th oct 2024.For Training and consulting requirement for Oracle Goldengate, Pls do fill out contact information form using below link: https://lnkd.in/gC7pfn2 Also u can directly reach out to me via below methods: 1. Email @ashishagarwalag@gmail.com 2. Call/whatsapp@+14168715708 3. DM@ https://www.linkedin.com/in/ashishagarwalag/
Oracle Goldengate Basics and Practical Demo of Oracle Goldengate Installation Oct 2024
This is Day 2 of 7 week learning Oracle Goldengate Classic Architecture session coducted on 10th Aug 2024. Below are the notes from the session:In Day 2 of Oracle GOldengate Classic Architecture weekend training batch we discussed about below: Recap of Oracle Goldengate Classic Architecture 19c Session 2:1. The Goldengate training VM Has 12.2 Database and 19C Binaries are present in /home/oracle/softwares 2. For Goldengate binaries download, Before download and install Install , make a note of below Source : DB Type , Version , Platform Target : DB Type , Version , Platform A. 1.Before you proceed with download and installation , always Check the certification matrix --Follow the instructions to download the GG from OTN --Check for system requirement and supported platform for oracle goldengate version we are installing use link : https://www.oracle.com/middleware/technologies/fusion-certification.html--After copying the Software , invoke the runInstaller 2. Before proceeding with installation u need to define location where to install. You may install GG in: A. Seperate mount point: B. Existing mount pointC. To consider how much space u need for installation, Understand the requirement. Do Research and designHardware requirements: 1. CPUs- 4 or 8 cores 2. Space requirement/mount point size- Whether u want to add new mount point (/goldengate) or use exising mount point(/u01) Space Calculation: 30/60 days day wise archive log generation. 20GB 1 GB 100 MB 100 GB Average of 7 days highest archive log generation -25 GB*7=175 GB *2=350-500 GB of space 3. Which OS user to use to install Goldengate (oracle or any other user ggadmin/gguser) DBAs -oracle Goldengate and DBA responsiblities are seggreagted then - gguser/ggadmin (oinstall group)3. Below are the options available to Install GG: --GUI Installation --Silent Installation – ./runInstaller -silent -responseFile /home/oracle/Downloads/ggate/fbo_ggs_Linux_x64_shiphome/Disk1 /response/oggcore.rsp --Silent installation , You can use the response file --You need to have Different GG install for Different versions of the Database GGSCI is the command to invoke the GG --Go to GG home --execute "./ggsci" --To see all process in GG --info all J. Manager process is default for gg install--Only one manager process for each GG install --All parameter file folder --$GG_HOME/dirprm --Create directories in GG --create subdirs --"dirpcs" is the folder for all the process with running in GG --"dirrpt" stores all the reports files --if you restart the process new report file generates --ggserr.log file is the log for GG , like alert log for Database --Manager Parameter file --mgr.parmsK. Manager Process --Purpose is to manage all the GG resources --differnt commands manager process : --info all -- to gett all details --edit params mgr -- Edit manager parameters --view params mgr -- view teh manager parameters --info mgr -- Manager info --start mgr -- start the manager --stop mgr -- stop the mangerL. There are total 3 processes involved in GG replication process (Classic Architecture) - Capture or Extract process - Pump process - Delivery or Replicat process We will be configuring these process for setting up Oracle GG replication- Oracle GG installed in source and target. (Classis Architecture) - Source GG installation location - /u01/app/oracle/product/ogg_src - Target GG installation location - /u01/app/oracle/product/ogg_trg - We created database in multitenant architecture SOURCE - Container database - OGGDB1 - Pluggable database - PDB1TARGET - Container database - OGGDB2 - Pluggable database – PDB2 4. Below are the Options to Install Goldengate --Install GG on ggate1 for local capture and on ggate2 for local apply --install GG on ggate1 which will capture the data locally from ggate 1 DB and apply to ggate2 DB remotely --Install GG on ggate2 which will capture the data remotely from ggate 1 DB and apply to ggate2 DB locally --Install GG on intermediate server (eg ggate3) which will capture the remotely from ggate1 and apply the data remotely on ggate2--Install GG on intermediate server (eg ggate3) which will capture the remotely from ggate1 but install GG on ggate2 as well for local apply--Install GG on ggate1 which will capture the data locally from ggate1 but install GG on intermediate server (eg ggate3) which will apply data remotely to ggate2 - Prior to setup there are certain pre-requisites we need to meet to setting up Oralce GG at Source and Target level. - Oracle GG already installed in source and target. (Classis Architecture) - Source GG installation location - /data/app/oracle/product/gg_src - Target GG installation location - /data/app/oracle/product/gg_trg - We created database in multitenant architecture SOURCE - Container database - OGGDB1 -Pluggable database - PDB1 - Created GGTRAINING1 under PDB1
Day 2 of 7 Week Learning Oracle Goldengate (Installation, Download and Options to install OGG)
This is Day 1 of 7 weeke learning Oracle Goldengate Classic Architecture session commencing from 3rd Aug 2024. Below are the notes from the session:In Day 1 of Oracle GOldengate Classic Architecture weekend training batch we discussed about below:A. Introduction to goldengate architecture :In 2009 Oracle acquired goldengate and since then it is called as oracle golden gate and till 2017 there is only one goldengate architecture . In 2017 another goldengate architecture was introduced.There are two types of Golden Gate architecture: 1- Classic Architecture 2- Microservices ArchitectureClassic Architecture : It is command prompt based Architecture and is available for oracle as well as non oracle platforms.In classical Architecture there are different type of processes which are Extract processes and Replicat processes. Goldengate is a change data capture tool. Whatever changes are happening in the database those changes are stored in redo logs of database. Goldengate source are redo logs or archive logs of a database. Goldengate processes capture the data from source database and applied it to target database.Microservices Architecture : It was introduced in 2017 and you manage it through GUI and it is available on cloud integration as well. Until today microservices is available for Oracle Databases only.B. Oracle Goldengate Veridata : Oracle Golden Gate has another tool called Veridata. It is a separate licensed tool and is used to verify data. It doesn’t need any downtime while verifying the data.C. In single liscence we get to work with both classic and Microservices architechture. For working with veridata seperate license is required.D. Why Goldengate?Goldengate is near real time replication and it supports heterogeneous environment and heterogeneous platforms across different databases. It is high performance with low impact tool can and move large data volumes very efficiently. No single point of failure. It is an object level replication.E. There are two types of extract processes. 1- Classic Extract process 2- Integrated Extract processF. Classic extract is there since beginning . Capture process is external to database and it reads the data in sequential manner and capture only committed transaction. In integrated capture log minor build happens and logminer sends changes in the form of LCR to the Extract process. Performance of integrated capture is very high and much faster than classic capture. It creates less load on the database as well.Types of Replicat 1- Nonintegrated or Classic Replicat 2- Integrated Replicat 3- Co ordinated Replicat 4- Parallel Replicat a. Parallel integerated Replicat b. Parallel nonintegrated Replicat==============================================================G. Oracle Goldengate Architecture - How data flows in Goldengate? All the processes in Goldengate work independently from each other however they depend on each other for reading the data. We call capture process as extract process as well.++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++For Lab Setup :1) refer to lab-setup doc for complete lab setup for 2 VMs(GGATE1 and GGATE2). Drop an email@ashishagarwalag@gmail.com or whatsapp@+14168715708 for details. 2) DB and GG binaries are present on loaction /home/oracle/software 3) install GG on both the VMs using setup guide .Post-session assignment: 1) complete lab setup for both VMs
1 of 7 week learning Oracle Goldengate July 2024 (Introduction,Overview and Architecture of OGG)
In this session we discussed regarding Difference between Oracle Goldengate and DataguardThumbnail: Comparison between Oracle GoldenGate and DataGuard Add before and after screen to this video and also add the comment which u are adding in all videos for training consulting one
Comparison between Oracle GoldenGate and DataGuard
In this session we have discussed regarding Oracle Goldengate OBEY COMMAND• You can use an Obey file to perform a reusable sequence of commands • Save the commands in a text file, for example: • Then use the GGSCI OBEY command to run the file: GGSCI OBEY obey filename.oby • Note. An Obey file can have any file extension or none. Save below commands in obey file to run at once: START MGR ADD EXTRACT myext, TRANLOG, BEGIN NOW ADD EXTTRAIL /ggs/dirdat/rt, EXTRACT myext START EXTRACT myext To spool the content of obey file: $ ggsci obey.oby obey_output.log
Oracle Goldengate - OBEY COMMAND in Oracle Goldengate
Load More...