Active – Active (Bi-Directional) Replication using Oracle Golden Gate 12c

Since it was announced in Early 2010 that Oracle GoldenGate will be the RoadMap for Replication for Oracle Database, The adoption of GoldenGate over Streams has been quite Rapid. The complexity of Streams has intimidated many adopters, specially for Multi-Master or Peer-to-Peer Replication. GoldenGate not only makes MultiMaster Replication easy but is so full of … Continue reading Active – Active (Bi-Directional) Replication using Oracle Golden Gate 12c

Multiple Standby Databases Dataguard Oracle

We will create 2 standby databases from a single RAC primary database. 11gR2 allows upto 30 standby databases.  The most important part is to consider the dataguard parameters, the rest is a normal dataguard creation. The important parameters are as below : db_file_name_convert log_archive_config log_archive_dest_1 log_archive_dest_2 log_archive_dest_3 LOG_ARCHIVE_DEST_STATE_1 LOG_ARCHIVE_DEST_STATE_2 LOG_ARCHIVE_DEST_STATE_3 log_file_name_convert remote_login_passwordfile STANDBY_FILE_MANAGEMENT fal_client fal_server … Continue reading Multiple Standby Databases Dataguard Oracle

RAC to Single Instance Standby Database Setup (Oracle 11gR2 Physical Standby)

Primary is a 2 node-rac cluster with instances swx1 and swx2 running on ASM. A service called swxscan is created for client sides. We will use this service name for the tnsnames.ora. The standby instance will be called swxstandby and it will be running single instance on ASM as well. This is a standard dataguard … Continue reading RAC to Single Instance Standby Database Setup (Oracle 11gR2 Physical Standby)

2 Node RAC to Single Instance Dataguard Switchover (Oracle 11gR2 Physical Standby )

Many a times to save cost in building a DR solution for a certain application; you have to create a single instance database for your RAC primary. So you have gone ahead and build the 2-node to single instance setup and now comes the time to test it. Well it is not much different than … Continue reading 2 Node RAC to Single Instance Dataguard Switchover (Oracle 11gR2 Physical Standby )

ORA-38753: Cannot flashback data file ; no flashback log data. ORA-01110: data file

CAUTION !!!! DO NOT DO THIS ON YOUR PRIMARY. IF YOU DO THEN YOU WOULD REQUIRE MEDIA RECOVERY ON THE DATAFILE YOU BROUGHT OFFLINE !!!   If your getting this error when you converting a Snapshot Standby Database (11gR2) back to Physical Standby Database. SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY; ERROR at line 1: … Continue reading ORA-38753: Cannot flashback data file ; no flashback log data. ORA-01110: data file

Oracle 11gR2 Dataguard using Duplicate Active Standby

In this activity we will create Oracle 11gR2 Datagaurd using active duplication. In active duplication, we don't need to take rman backup and copy the backup to the Standby Server. The database can be duplicated over the network. Its an amazing feature which saves you much time and effort. The only thing you have to … Continue reading Oracle 11gR2 Dataguard using Duplicate Active Standby

Apple’s Oracle Dataguard 11g architecture

Apple use's Oracle Active Dataguard 11g for its AppStore.  In Oracle 11g data guard you can have upto 30 active data guard instances. What Apple most likely does is, cascade its Production DB into many Standby instances and uses different applications to interface with each standby database.   For more details read on : http://www.oracledatabase12g.com/archives/oracle-active-data-guard-technical-overview.html