Showing posts from June, 2012

Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration

I read My Oracle Support note “Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration [ID 413484.1]” .
I made decision that let me check this.Then I have create two virtual machines with Oracle Virtual Box. Witch is a virtual machine OS Oracle Linux server 6.2 (x86_64) and a Virtual Machine with OS Microsoft Windows 2008 Server R2 (x64) . Installed Oracle Database 11g Release 2 ( both server, and a database (ADMDB)is created on first server.

I used RMAN Duplicate command for creation of standby database and after creation of standby  database used Data Guard Manager Command-Line interface for creation of data guard configuration.
I think about that I achieved this, this will be for all oracle database administrators very interesting.

[ID 413484.1] :

The simplest path when deploying Data Guard is to configure a homogeneous and symmetric primary/standby configuration.  However, it is often useful to deploy a heterogeneous configur…

Oracle Data Guard 11g - Overview Logical Standby Database

Logical Standby  Database is one part of Oracle Database Guard. The benefits are obvious: the standby database can not only be open for reads, but it can also support additional entities such as indexes and materialized views that can be too expensive to maintain at the primary database. In addition, you can add other tables or even entire schemas to a logical standby database and have complete read-write access to those tables as they are not maintained by SQL Apply. Logical standby databases are support all role transition operations that are available in the context of a physical standby database. Creating Logical  Standby Database.
For creating logical standby database we are need create a physical standby database, then convert to logical standby.
I had created broker-managed configuration admdg with admdb – Primary database, admts – Physical  standby database.
1. Created Physical Standby database