RE: Standy database on standard edition
Date: Wed, 12 Jun 2013 10:54:45 -0400
Message-ID: <C1117B1AA0340645894671E09A7891F71511DF68EC_at_EIHQEXVM2.ei.local>
I do not want to use Data Guard. I will be able to create the standby -- (just give the standby its own db_unique_name, or both primary and standby ie db dbprd, db dbsty).
No I am just asking opinions on licensing issues -- assume both boxes are licensed for oracle std edition.
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.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: Sweetser, Joe [mailto:JSweetser_at_icat.com]
Sent: Wednesday, June 12, 2013 10:50 AM
To: Patterson, Joel; oracle-l_at_freelists.org
Subject: RE: Standy database on standard edition
In my opinion, if you are running Standard Edition you cannot use Data Guard. Or am I missing something in your question? As the doc states, there are ways "around it" with Standard Edition...notably you need to copy and apply the archive logs manually. I have done that and it works fine. But it's not Data Guard.
As far as naming, Data Guard makes use of the db_unique_name parameter. It is normal for the primary and standby databases to have the same db_name.
hth,
-joe
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Patterson, Joel
Sent: Wednesday, June 12, 2013 8:41 AM
To: oracle-l_at_freelists.org
Subject: Standy database on standard edition
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]<http://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
Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 12 2013 - 16:54:45 CEST