tag:blogger.com,1999:blog-21118863.post9073755798076084825..comments2024-02-27T01:40:02.429-08:00Comments on My Oracle World: Fast-Start Failover - It is reliableMThttp://www.blogger.com/profile/01128712911412678264noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-21118863.post-72426942619496398012020-09-09T21:57:41.309-07:002020-09-09T21:57:41.309-07:00шалом - заработать интернет
Друзья подскажите п...шалом - заработать интернет <br /> <br />Друзья подскажите плз), есть ли возможность быстро заработать в сети интернет? <br /> <br />метки: удаленный работаAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21118863.post-64787190051283639062019-10-01T03:10:33.107-07:002019-10-01T03:10:33.107-07:00Привет!
Необыкновенно охренеть какой сайт.
Мно...Привет! <br />Необыкновенно охренеть какой сайт. <br /> <br />Много приколов...План, Анаша, Спайс, Мефедрон, и т.д. <br />Заходи на сайт: <br />[b] <br />http://gidra.ijasexul.cf <br /> <br /> <br />[/b]Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21118863.post-30362131507690967412011-08-10T13:45:36.443-07:002011-08-10T13:45:36.443-07:00I've solved problem as it did not start cos th...I've solved problem as it did not start cos there was a damaged observer config file.<br /><br />$ ps -fea | grep obs<br /> oracle 24798 1 0 12:58:10 ? 0:04 dgmgrl -silent sys/sys@orcl3 start observer FILE='/export/home/oracle/fsfo-orcl.dat'<br /><br />by starting observer on another BROKER server, this process generated a new fsfo-orcl.dat file. I transfer this file to the original broker server, I tried to start it worked.<br />Thank you.Pc2Linuxhttps://www.blogger.com/profile/07394427618601453414noreply@blogger.comtag:blogger.com,1999:blog-21118863.post-5166036143068531602011-08-09T17:50:13.309-07:002011-08-09T17:50:13.309-07:00Hi Guys:
I have a scenario like as you said, but...Hi Guys:<br /> I have a scenario like as you said, but I could not start observer. It worked some days ago, before failover was performed.<br /><br />ORIGINAL SITUATION:<br />orcl3 was primary database<br />orcl4 was standby database <br /><br />ACTUAL SITUATION:<br /><br />DGMGRL> show configuration<br /><br />Configuration<br /> Name: dg_iwayprod<br /> Enabled: YES<br /> Protection Mode: MaxAvailability<br /> Fast-Start Failover: ENABLED<br /> Databases:<br /> orcl3 - Physical standby database<br /> - Fast-Start Failover target<br /> orcl4 - Primary database<br /><br />Current status for "dg_iwayprod":<br />Warning: ORA-16608: one or more databases have warnings<br /><br /><br />DGMGRL> show database orcl3<br /><br />Database<br /> Name: orcl3<br /> Role: PHYSICAL STANDBY<br /> Enabled: YES<br /> Intended State: ONLINE<br /> Instance(s):<br /> orcl3<br /><br />Current status for "orcl3":<br />Warning: ORA-16819: Fast-Start Failover observer not started<br /><br />I tried to start observer as follow:<br />DGMGRL> start observer;<br />Error: ORA-16556: error message is in XML already<br /><br />Failed.<br /><br />I can't start it. However both databases seem to be syncronized as I see:<br /><br />SQL> select name,open_mode,fs_failover_status,db_unique_name from v$database;<br /><br />NAME OPEN_MODE FS_FAILOVER_STATUS DB_UNIQUE_NAME<br />--------- ---------- --------------------- ------------------------------<br />ORCL3 READ WRITE SYNCHRONIZED orcl4<br /><br />SQL> select name,open_mode,fs_failover_status,db_unique_name from v$database;<br /><br />NAME OPEN_MODE FS_FAILOVER_STATUS DB_UNIQUE_NAME<br />--------- ---------- --------------------- ------------------------------<br />ORCL3 MOUNTED SYNCHRONIZED orcl3Pc2Linuxhttps://www.blogger.com/profile/07394427618601453414noreply@blogger.comtag:blogger.com,1999:blog-21118863.post-78023493018847414702009-11-14T07:31:39.485-08:002009-11-14T07:31:39.485-08:00Fast-start failover observer is no longer observin...Fast-start failover observer is no longer observing this database<br /><br />The observer is definately started and no firewalls are present? Should the be a special configuration in the /etc/hosts file?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21118863.post-58557885635127989002009-08-13T15:41:22.214-07:002009-08-13T15:41:22.214-07:00Hi ya,
The protection_level is showing as resync...Hi ya,<br /><br /> The protection_level is showing as resynchronization even though there are no gaps. I can see the logs are also being applied but the protection_level is resynchronization instead of Max Availability. Ny ideas y???Binsnoreply@blogger.comtag:blogger.com,1999:blog-21118863.post-66939534937813232122009-05-06T09:43:00.000-07:002009-05-06T09:43:00.000-07:00The presentation can be found at http://prutser.fi...The presentation can be found at http://prutser.files.wordpress.com/2008/12/client_connectivity.pdfvbarunhttps://www.blogger.com/profile/14748871375863136442noreply@blogger.comtag:blogger.com,1999:blog-21118863.post-17629681486149444392009-02-25T22:09:00.000-08:002009-02-25T22:09:00.000-08:00Hi hoffmandirt,Thanks for reading?What kind of JDB...Hi hoffmandirt,<BR/><BR/>Thanks for reading?<BR/><BR/>What kind of JDBC driver are you referring to? Thick(OCI) or Thin?<BR/><BR/>I assume thin.<BR/><BR/>If my assumption is correct, my choice would be to implement Fast Connection Failover. <BR/><BR/>The following URLs can bring you to the documentation about this failover method:<BR/>http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/fstconfo.htm#CIHJBFFC<BR/><BR/>http://download.oracle.com/docs/cd/B19306_01/server.102/b25159/configbp.htm#CHDIFGHE<BR/><BR/>Since I am talking about the thin driver and FCF, you should include the whole connect descriptor in the JDBC URL so it would look like:<BR/><BR/><I>jdbc:oracle:thin:@(DESCRIPTION= <BR/> (LOAD_BALANCE=yes) <BR/> (ADDRESS=(PROTOCOL=TCP)(HOST=server1.localdomain)(PORT=1521)) <BR/> (ADDRESS=(PROTOCOL=TCP)(HOST=server2.localdomain)(PORT=1521)) <BR/> (CONNECT_DATA=(service_name=serviceJDBC)))<BR/></I><BR/><BR/>Be aware that you also need to enable FCF on the client side.<BR/><BR/>You can take a look to Metalink Note 433827.1 where you can find an example about how to setup FCF with JDBC Thin Client in a RAC environment.<BR/><BR/>If your application is making connections to Non-RAC Data Guard environment, the configuration should be more or less the same. For more details about the differences you can refer to this grat White Paper available on OTN: <BR/><A HREF="http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_ClientFailoverBestPractices.pdf" REL="nofollow">Client Failover Best Practices for Highly Available Oracle Databases: Oracle Database 10g Release 2<BR/></A><BR/><BR/>Regarding your question if the URL needs to know about both of the databases, my answer would be YES. It is up to you whether you will define it once in an external file and then load it (preferred) or you will explicitly define it in the application.<BR/><BR/>I tried to provide you with a general answer. If this was not the answer you were looking for, let me know and provide more information about the challenges/issues you are facing so I can be more specific.<BR/><BR/>Cheers,<BR/>MihajloMThttps://www.blogger.com/profile/01128712911412678264noreply@blogger.comtag:blogger.com,1999:blog-21118863.post-73269638055609271682009-02-25T05:14:00.000-08:002009-02-25T05:14:00.000-08:00Great article. Do you have an example of the JDBC ...Great article. Do you have an example of the JDBC URL that you would use to connect to an Oracle database with Fast Start Failover enabled? Does the URL need to know about both hosts (primary and standby)?Unknownhttps://www.blogger.com/profile/03797495540765545079noreply@blogger.comtag:blogger.com,1999:blog-21118863.post-38808288048751530192008-09-14T17:02:00.000-07:002008-09-14T17:02:00.000-07:00Hi Veronica,Thanks for reading the article. In ord...Hi Veronica,<BR/><BR/>Thanks for reading the article. In order to download the paper, you have to be an UKOUG member. There is bronze membership option which is very convinient for those who are not in the UK (<A HREF="http://www.ukoug.org/membership/" REL="nofollow">UKOUG membership details</A>).<BR/>Regarding FSFO implementation and the client/application failover, it all depends on your application architecture. I will try to cover something in some of the next posts.<BR/><BR/>You may also want to read the following White Paper (if you haven't read it already):<BR/><A HREF="http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_ClientFailoverBestPractices.pdf" REL="nofollow">Client Failover Best Practices for Highly Available Oracle Databases: Oracle Database 10g Release 2</A><BR/><BR/>Cheers,<BR/>MihajloMThttps://www.blogger.com/profile/01128712911412678264noreply@blogger.comtag:blogger.com,1999:blog-21118863.post-65843162735791030902008-09-11T08:59:00.000-07:002008-09-11T08:59:00.000-07:00This is a great write-up. We're in the middle of i...This is a great write-up. We're in the middle of implementing fsfo and were wondering how to automatically redirect the clients when the database has failed over. I cannot access the white paper of Harald van breederode about client connectivity because I am not a member of UKoug...I am in the US. Would it be possible to email it to me. I will understand if it is not possible. Thanks! VeronicaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21118863.post-36430537647358559732008-08-18T21:45:00.000-07:002008-08-18T21:45:00.000-07:00Dave, I am really glad to see this article listed...Dave, I am really glad to see this article listed in Log Buffer #110. Thank You !<BR/><BR/>Arnoud, thanks for the nice words. I am glad you like the article. I am looking forward to read Harald's presentation.MThttps://www.blogger.com/profile/01128712911412678264noreply@blogger.comtag:blogger.com,1999:blog-21118863.post-42132386618982970602008-08-18T06:05:00.000-07:002008-08-18T06:05:00.000-07:00Hi Mihajlo,Thanks for this great article. I am sur...Hi Mihajlo,<BR/>Thanks for this great article. I am sure it will be a great help in setting up FSFO for many of us out there.<BR/>To add on this very nice article, Harald van Breederode has a very good presentation on the subject of client connectivity in a Dataguard environment. You can get it here:<BR/>http://ukoug.netxtra.net/calendar/show_presentation.jsp?id=8479<BR/>Very valuable stuff indeed.<BR/>Regards,<BR/>Arnoud RothAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21118863.post-19169024061790955742008-08-15T10:59:00.000-07:002008-08-15T10:59:00.000-07:00Hi Mihajlo. I covered this article in Log Buffer ...Hi Mihajlo. I covered this article in <A HREF="http://www.pythian.com/blogs/1173/log-buffer-110-a-carnival-of-the-vanities-for-dbas" REL="nofollow">Log Buffer #110</A>.<BR/><BR/>Cheers,<BR/>Dave.Anonymousnoreply@blogger.com