Re: Standy database on standard edition
Date: Wed, 12 Jun 2013 11:57:31 -0500
Message-ID: <CAO9=aUwjeQ3JJUVtHkYdt1SKpBFr8PX+hHDLvJhMszqQ2P+XkA_at_mail.gmail.com>
Hi Joel,
*Therefore, there is no command possible for the standby that would violate the data guard licensing provisions. This is the question. It appears you answered it below eventually.*
*
*
I agree with you completely. Look at what happens when I try enabling Data Guard on my test 11gR2 Standard Edition DB:
SQL> startup
ORA-00439: feature not enabled: Managed Standby
I think you're safe as long as DBA_FEATURE_USAGE_STATISTICS shows 0 in DETECTED_USAGES for the given feature you're concerned with.
From the same SE instance:
SQL> select detected_usages, total_samples, currently_used,
first_usage_date, last_usage_date
2 from DBA_FEATURE_USAGE_STATISTICS
3 where name = 'Data Guard';
DETECTED_USAGES TOTAL_SAMPLES CURRE FIRST_USA LAST_USAG --------------- ------------- ----- --------- ---------
0 3 FALSE Hope this helps.
-Justin
On Wed, Jun 12, 2013 at 10:35 AM, Patterson, Joel <jpatterson_at_entint.com>wrote:
> To be clear to everyone offline as well. Both servers are fully
> licensed, Both databases are Standard Edition. Standard Edition cannot
> use Data Guard.
>
> Therefore, there is no command possible for the standby that would violate
> the data guard licensing provisions. This is the question. It appears
> you answered it below eventually.
>
> I am not asking how to do it.
>
> Joel Patterson
> Database Administrator
> 904 928-2790
>
>
>
> --
> Joel Patterson
> Sr. Database Administrator | Enterprise Integration
> Phone: 904-928-2790 | Fax: 904-733-4916
> http://www.entint.com/
>
> http://www.entint.com/
>
> http://www.facebook.com/pages/Enterprise-Integration/212351215444231
> http://twitter.com/#!/entint
> http://www.linkedin.com/company/18276?trk=tyah
> http://www.youtube.com/user/ValueofIT
>
> This message (and any associated files) is intended only for the use
> of the addressee and may contain information that is confidential,
> subject to copyright or constitutes a trade secret. If you are not the
> intended recipient, you are hereby notified that any dissemination,
> copying or distribution of this message, or files associated with this
> message, is strictly prohibited. If you have received this message in
> error, please notify us immediately by replying to the message and
> deleting it from your computer. Messages sent to and from us may be
> monitored. Any views or opinions presented are solely those of the
> author and do not necessarily represent those of the company. [v.1.1]
>
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Hans Forbrich
> Sent: Wednesday, June 12, 2013 11:00 AM
> To: oracle-l_at_freelists.org
> Subject: Re: Standy database on standard edition
>
> Since it's often confused by various people, just to reiterate: All
> servers must be licensed, whether in r/w, r/o or recovery disconnect.
>
> And, as clarification, standby is not DataGuard. DataGuard is simply a
> technology that automates the process [work] flow of standby for Oracle
> databases: the extraction, shipping, receiving, application of logs and
> coordinated switchover/failover control.
>
> Basically Oracle is saying you can not configure DG, although nothing - as
> far as I can tell - is stopping you from manually doing the same thing as
> Data Guard provides.
>
> Rather than try to duplicate DG capabilities, just peek at DbVisit, an
> Oracle partner who provides a great & legal standby solution for Standard
> Edition at a very reasonable price. http://dbvisit.com
>
> /Hans
>
> On 12/06/2013 8:40 AM, Patterson, Joel wrote:
> > Section 2.3.2 of this document indicates that data guard is not part of
> Standard Edition.
> > http://docs.oracle.com/cd/E11882_01/server.112/e25608/standby.htm
> >
> > In your opinions, would my interpretation that the data guard licensing
> could not possibly be violated whether the standby database stays in
> recovery disconnect from session, or whether it is recovered once/day and
> opened read only?
> >
> > I opened an SR, but it is a sev 4...
> >
> > Also, if both databases on the separate servers happen to have the same
> exact name, is that a show stopper or an issue? The standby will point its
> logsource for recovery to the primary archive log destination on a backup
> device.
> >
> >
> > Joel Patterson
> > Senior Oracle Database Administrator
> > jpatterson_at_entint.com<mailto:jpatterson_at_entint.com>
> > Office: 904 928-2790
> > Enterprise Integration Corporation /
> > www.entint.com<http://www.entint.com/>
> > 7601 Centurion Parkway | Jacksonville, FL 32256
> >
> >
> > --
> > Joel Patterson
> > Sr. Database Administrator | Enterprise Integration
> > Phone: 904-928-2790 | Fax: 904-733-4916
> > www.entint.com<http://www.entint.com/>
> >
> > [http://i1202.photobucket.com/albums/bb367/Entint/signaturev61.jpg]<ht
> > tp://www.entint.com/>
> >
> > [http://i1202.photobucket.com/albums/bb367/Entint/th_FaceBook1.jpg]<
> http://www.facebook.com/pages/Enterprise-Integration/212351215444231> [
> http://i1202.photobucket.com/albums/bb367/Entint/th_Twitter1.jpg] <
> http://twitter.com/#!/entint> [
> http://i1202.photobucket.com/albums/bb367/Entint/th_LinkedIn1.jpg] <
> http://www.linkedin.com/company/18276?trk=tyah> [
> http://i1202.photobucket.com/albums/bb367/Entint/th_YouTube1.jpg] <
> http://www.youtube.com/user/ValueofIT>
> >
> > This message (and any associated files) is intended only for the use
> > of the addressee and may contain information that is confidential,
> > subject to copyright or constitutes a trade secret. If you are not the
> > intended recipient, you are hereby notified that any dissemination,
> > copying or distribution of this message, or files associated with this
> > message, is strictly prohibited. If you have received this message in
> > error, please notify us immediately by replying to the message and
> > deleting it from your computer. Messages sent to and from us may be
> > monitored. Any views or opinions presented are solely those of the
> > author and do not necessarily represent those of the company. [v.1.1]
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 12 2013 - 18:57:31 CEST