Question : How can I use Data Guard or GoldenGate to create a slave database where the master does not […]
Tag: dataguard
Oracle RAC with single node Data Guard physical standby
Question : Best practices for Oracle 11gR2 Data Guard implies that the primary and standby databases should have the same […]
Sync oracle DBs using archive log when not connected to each other
Question : I’m trying to synchronize 2 dbs which are not connected to each other, and located in a separated […]
Oracle RAC and DataGuard configuration
Question : We have deployed an Oracle RAC cluster which consists of three Oracle instances. As we are considering the […]
Schema based replication in Oracle using Data Guard
Question : We have active-passive database replication in our system cluster, so passive db belongs to DR class of nodes. […]
Difference between ASYNC & SYNC real time apply
Question : What is the difference between a data guard (Oracle 11g) operating in max performance ASYNC mode and enabling […]
Dataguard: preventing logical standby to loose track after flashback database on primary
Question : We have 2 Oracle databases; a primary and a logical standby, configured with Dataguard. Whenever we have an […]
How to make dataguard switchover seamlessly
Question : In my Dataguard configuration on a 12c environment, when I perform a switchover from primary (foo) to standby […]
How to tell from the OS whether Oracle instance is a standby, assuming no DB access?
Question : One can easily check via SELECT database_role FROM v$database; whether your Oracle database is a primary or standby […]
How to retire a physical standby in Oracle 11.2
Question : I have a production Oracle 11gR2 RAC database with a single node physical standby. Now it has become […]