<div dir="ltr"><div><div><div>Hi, <br></div>thanks for advice and your intrest.<br></div>We would use oracle database over DRBD. Datafiles (and control and redo files) will be on DRBD. FRA also (on an other DRBD device). But we are new in DRBD, and DRBD is also a component what can fails. We plan a scenario to recover the database without DRBD (without data loss, if possible). We would use nfs or local filesystem for this. If we use local FS, the control file is out of sync on the B node when switch over (from A to B). We would copy controlfile (and redo files) from DRBD to the local FS. After this, oracle can start, and it keeps
the controlfiles
syncronized. If other backup related files (archlog, backup) are also available on the local FS of either node, we can recover the DB without DRBD
(without data loss)<br>(I know it is a worst case scenario, because if DRBD fails, the FS on it should be available at least on one node)<br></div>Thanks: lados.<br><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2018-03-07 10:20 GMT+01:00 Klaus Wenninger <span dir="ltr"><<a href="mailto:kwenning@redhat.com" target="_blank">kwenning@redhat.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 03/07/2018 10:03 AM, Mevo Govo wrote:<br>
> Thanks for advices, I will try!<br>
> lados.<br>
><br>
> 2018-03-05 23:29 GMT+01:00 Ken Gaillot <<a href="mailto:kgaillot@redhat.com">kgaillot@redhat.com</a><br>
</span>> <mailto:<a href="mailto:kgaillot@redhat.com">kgaillot@redhat.com</a>>>:<br>
<span class="">><br>
> On Mon, 2018-03-05 at 15:09 +0100, Mevo Govo wrote:<br>
> > Hi,<br>
> > I am new in pacemaker. I think, I should use DRBD instead of copy<br>
> > file. But in this case, I would copy a file from a DRBD to an<br>
> > external device. Is there a builtin way to copy a file before a<br>
> > resource is started (and after the DRBD is promoted)? For example a<br>
> > "copy" resource? I did not find it. <br>
> > Thanks: lados.<br>
> ><br>
><br>
> There's no stock way of doing that, but you could easily write an<br>
> agent<br>
> that simply copies a file. You could use ocf:pacemaker:Dummy as a<br>
> template, and add the copy to the start action. You can use standard<br>
> ordering and colocation constraints to make sure everything happens in<br>
> the right sequence.<br>
><br>
> I don't know what capabilities your external device has, but another<br>
> approach would be to an NFS server to share the DRBD file system, and<br>
> mount it from the device, if you want direct access to the original<br>
> file rather than a copy.<br>
><br>
<br>
</span>csync2 & rsync might be considered as well although not knowing<br>
your scenario in detail it is hard to tell if it would be overkill.<br>
<br>
Regards,<br>
Klaus<br>
<br>
> --<br>
> Ken Gaillot <<a href="mailto:kgaillot@redhat.com">kgaillot@redhat.com</a> <mailto:<a href="mailto:kgaillot@redhat.com">kgaillot@redhat.com</a>>><br>
<span class="">> ______________________________<wbr>_________________<br>
> Users mailing list: <a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a><br>
</span>> <mailto:<a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a>><br>
> <a href="https://lists.clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">https://lists.clusterlabs.org/<wbr>mailman/listinfo/users</a><br>
<div class="HOEnZb"><div class="h5">> <<a href="https://lists.clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">https://lists.clusterlabs.<wbr>org/mailman/listinfo/users</a>><br>
><br>
> Project Home: <a href="http://www.clusterlabs.org" rel="noreferrer" target="_blank">http://www.clusterlabs.org</a><br>
> Getting started:<br>
> <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a><br>
> <<a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a>><br>
> Bugs: <a href="http://bugs.clusterlabs.org" rel="noreferrer" target="_blank">http://bugs.clusterlabs.org</a><br>
><br>
><br>
><br>
><br>
> ______________________________<wbr>_________________<br>
> Users mailing list: <a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a><br>
> <a href="https://lists.clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">https://lists.clusterlabs.org/<wbr>mailman/listinfo/users</a><br>
><br>
> Project Home: <a href="http://www.clusterlabs.org" rel="noreferrer" target="_blank">http://www.clusterlabs.org</a><br>
> Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a><br>
> Bugs: <a href="http://bugs.clusterlabs.org" rel="noreferrer" target="_blank">http://bugs.clusterlabs.org</a><br>
<br>
______________________________<wbr>_________________<br>
Users mailing list: <a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a><br>
<a href="https://lists.clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">https://lists.clusterlabs.org/<wbr>mailman/listinfo/users</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" rel="noreferrer" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://bugs.clusterlabs.org" rel="noreferrer" target="_blank">http://bugs.clusterlabs.org</a><br>
</div></div></blockquote></div><br></div>