DBA Tips

Blog for Oracle/Postgres Database Administrators

Pages

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

Wednesday, December 7, 2022

Global Temporary Table support from Standby

One of the primary use cases for physical standby is running read only workloads. 
But read only workloads are not 100% read only and may require the final results to be written. 
In this case, we can use the new features, the ability to read/write global temporary tables for physical standby (ADG configuration) version 12c.
<read more...>
- December 07, 2022
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Post Older Post Home

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.