DBA Tips

Blog for Oracle/Postgres Database Administrators

Pages

  • Home
  • AI
  • Postgres
  • Oracle
  • MSSQL
  • Backup
  • About

Creating a replication schemas Postgres -> [Postgres & Oracle] using Oracle GoldenGate

                                                                     Next >>>
Đ¢able of Contents

01. Creating PostgreSQL Database Users
02. Additional Configuration for Patroni & Postgres & pg_cron
03. Creating Environment for ggadmin
04. Creating Environment for cron_tech (HB + pg_profile)
05.01. Preparing Replication Servers 'OGG for Postgres' #1,2
05.02. Supplement to Section 05.01
06. Adding Replication Slot for 'Active Node'
07. Preparing PostgreSQL Database 'Active Node' for Replication
08. Preparing PostgreSQL Database 'Passive Node' for Replication
09. Creating Change-Synchronization ER Server for OGG #1 (e_quik1, r_quik2)
10. Executing pg_dump Initial Load [Postgres->Postgres (Database: dbquik2)]
11. Activating Change-Synchronization Replicat Server 'OGG for Postgres' #1 (r_quik2)
12. Adding Replication Slot for 'Passive Node'
13. Creating Change-Synchronization ER Server 'OGG for Postgres' #2 (e_quik2, r_quik1)
14. Preparing Oracle Database (Reports) for Replication
15. Preparing Replication Servers 'OGG for Oracle' #1,2
16. Creating Datapump-Synchronization ER Servers 'OGG for Oracle' #1,2 (ep_rep1, r_rep1a, r_rep1b)
17. Executing pg_dump Initial Load [Postgres->Oracle (Database: dbrep1)]
18. Performance Analysis, Top Workload, and Other Information for Postgres Database



Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Home
Subscribe to: Posts (Atom)

Search This Blog

Recent projects

  • Oracle
    • Creating copies of databases based on ACFS snapshots
    • Enable Fast-Start-Failover Data Guard Broker (in Zero Data Loss Mode) with OBSERVER
    • Two ways to recover data in an Oracle database table containing corruption blocks
  • Postgres
    • PostgreSQL14 HA with Patroni 2.1, Etcd, Haproxy, Keepalived (EL8)
    • Backup PostgreSQL with Barman
    • Connecting PostgreSQL to an Oracle database (oracle_fdw)
    • How to migrate data from Oracle to PostgreSQL using Ora2pg
    • Creating a replication schemas Postgres-> [Postgres &Oracle] using Oracle GoldenGate
    • Migration of Oracle database to Postgres with minimum downtime using Oracle GoldenGate
  • MSSQL
    • Copy SQL Logins by assigning roles and permissions
  • Backup
    • Netbackup tips

About Me

My photo
Roman Grishchenko
Blog for Oracle/Postgres Database Administrators
View my complete profile
Sunower. Powered by Blogger.