Re: Oracle Active Data Guard
From: onedbguru <onedbguru_at_yahoo.com>
Date: Tue, 6 Dec 2011 14:38:04 -0800 (PST)
Message-ID: <ce03de49-a379-414f-a934-f294bf04b098_at_z12g2000yqm.googlegroups.com>
On Dec 1, 1:36 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> Oracle 11g has a very interesting option: active DG. Basically, one can
> create a physical standby db which is open for querying. It is much
> better thing than a logical standby database because there is no hassle
> with streams and unsupported types. The cost of the "active DG" is the
> same as the cost of an EE license on the CPU basis, which means that this
> is the same thing as logical standby, at least money wise. There is even
> a new status field:
>
> DGMGRL> show database stby
>
> Database - stby
>
> Role: PHYSICAL STANDBY
> Intended State: APPLY-ON
> Transport Lag: 0 seconds
> Apply Lag: 0 seconds
> Real Time Query: ON
> Instance(s):
> O11
>
> Database Status:
> SUCCESS
>
> The "Real Time Query: ON" means that this database is open for querying.
>
> This is a great thing, especially when paired with fast fail-over
> mechanism. This makes a logical standby completely obsolete. I am getting
> more and more enthusiastic about Oracle 11g. I believe it's the time to
> convert.
>
> --http://mgogala.byethost5.com
Date: Tue, 6 Dec 2011 14:38:04 -0800 (PST)
Message-ID: <ce03de49-a379-414f-a934-f294bf04b098_at_z12g2000yqm.googlegroups.com>
On Dec 1, 1:36 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> Oracle 11g has a very interesting option: active DG. Basically, one can
> create a physical standby db which is open for querying. It is much
> better thing than a logical standby database because there is no hassle
> with streams and unsupported types. The cost of the "active DG" is the
> same as the cost of an EE license on the CPU basis, which means that this
> is the same thing as logical standby, at least money wise. There is even
> a new status field:
>
> DGMGRL> show database stby
>
> Database - stby
>
> Role: PHYSICAL STANDBY
> Intended State: APPLY-ON
> Transport Lag: 0 seconds
> Apply Lag: 0 seconds
> Real Time Query: ON
> Instance(s):
> O11
>
> Database Status:
> SUCCESS
>
> The "Real Time Query: ON" means that this database is open for querying.
>
> This is a great thing, especially when paired with fast fail-over
> mechanism. This makes a logical standby completely obsolete. I am getting
> more and more enthusiastic about Oracle 11g. I believe it's the time to
> convert.
>
> --http://mgogala.byethost5.com
and alter database switch role; is really cool to watch... makes primary the standby and standby the primary all automagically. Received on Tue Dec 06 2011 - 16:38:04 CST