Re: Clusterware with single instance and ACFS
From: Ludovico Caldara <ludovico.caldara_at_gmail.com>
Date: Thu, 13 Aug 2020 15:11:14 +0200
Message-ID: <CALSQGrLNkjH63Y=odR=-y1Fo46Ld7bsYAdn0M=DxCkYv0ZfpqQ_at_mail.gmail.com>
Date: Thu, 13 Aug 2020 15:11:14 +0200
Message-ID: <CALSQGrLNkjH63Y=odR=-y1Fo46Ld7bsYAdn0M=DxCkYv0ZfpqQ_at_mail.gmail.com>
Hi Nenad,
sadly, no. Trivadis has a "standard" script that comes with the BasEnv
framework that we distribute to some customers, but even that is not the
best, IMO.
Beside the "normal" stop and start, there are a few things to deal with,
especially upon relocate, like:
- the EM target host that needs to be updated (if you use EM), you can get
the idea of the problem here:
https://floo.bar/2017/11/16/bulk-relocation-of-oem-targets-related-to-former-agents/
- creating the adump if you don't use a shared ACFS for that
- check that you have a init that points to the spfile in ASM (as it's not a srvctl resource anymore, you cannot specify with spfile you want but it looks in OH/dbs).
- check if the DB is standby and avoid to open the database with RT Apply
- change the static connect identifier host for DG after the relocate
- changing the local_listener to point to the node vip. For this one , my favorite solution is to have an entry "local_listener=(address=(host=hostname-vip)..." different on each node, so that you do not need to change it with the start of the instance.
That's why I never recommend sticking to an example but do it yourself according to your taste...
I always wanted to write a good article for all this stuff, but never managed to find the time... Now the project is over and I do not have access to it anymore to get the material/examples :-)
You can find some material made by my colleague Robert Bialek here: https://cdn2.hubspot.net/hubfs/1878050/Trivadis%20Website/Downloads/Trivadis_RobertBialek_Oracle_Database_Failover_Cluster_with_Grid_Infrastructure_11gR2.pdf
It is for 11g but has not changed at all since then.
-- Ludovico Il giorno gio 13 ago 2020 alle ore 14:44 Noveljic Nenad < nenad.noveljic_at_vontobel.com> ha scritto:Received on Thu Aug 13 2020 - 15:11:14 CEST
> Thank you, Ludo.
>
>
>
> Do you know if somebody have published some start/stop scripts (for
> reference)? We intend to mirror LUNs with SAN, btw.
>
>
>
> Best regards,
>
>
>
> Nenad
>
>
>
> https://nenadnoveljic.com/blog/about/
>
>
>
>
>
> *From:* Ludovico Caldara <ludovico.caldara_at_gmail.com>
> *Sent:* Donnerstag, 13. August 2020 14:29
> *To:* Noveljic Nenad <nenad.noveljic_at_vontobel.com>
> *Cc:* ORACLE-L (oracle-l_at_freelists.org) <oracle-l_at_freelists.org>
> *Subject:* Re: Clusterware with single instance and ACFS
>
>
>
> Hi Nenad,
>
>
>
> I recommend using Clusterware exactly for the points that you mentioned,
> the ACFS mount registry does not work in Oracle Restart and the cluster
> dependencies with the storage are not honored.
>
> I have done a few implementations like this (in 12.2+), they work really
> well.
>
> If you want to upgrade to RAC in the future, be careful that you need to
> correctly configure your private interconnect , or you will need to restart
> your CRS on the node before adding a new one.
>
> You do not need RAC license as long as you stay in single instance (that
> means also no RAC option ON in the binaries).
>
> Cold failover cluster is also an option that does not require RAC, but you
> have to code your stop/start scripts.
>
>
>
> HTH
>
> --
>
> Ludo
>
>
>
> Il giorno mer 12 ago 2020 alle ore 17:45 Noveljic Nenad <
> nenad.noveljic_at_vontobel.com> ha scritto:
>
> I intend to run Oracle 20c Enterprise Edition single instance databases on
> Linux and ACFS.
>
>
>
> Would you recommend using Clusterware? The advantages are:
>
> - It can automount ACFS file systems
>
> - If we opt one day for RAC, Clusterware would already be there.
>
>
>
> Do you see any disadvantages?
>
>
>
> Clusterware without RAC doesn’t inflict any additional license costs,
> right?
>
>
>
> Best regards,
>
>
>
> Nenad
>
>
>
> https://nenadnoveljic.com/blog/about/
>
>
>
> ____________________________________________________
>
> Please consider the environment before printing this e-mail.
>
> Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
>
>
> Important Notice
> This message is intended only for the individual named. It may contain
> confidential or privileged information. If you are not the named addressee
> you should in particular not disseminate, distribute, modify or copy this
> e-mail. Please notify the sender immediately by e-mail, if you have
> received this message by mistake and delete it from your system.
> Without prejudice to any contractual agreements between you and us which
> shall prevail in any case, we take it as your authorization to correspond
> with you by e-mail if you send us messages by e-mail. However, we reserve
> the right not to execute orders and instructions transmitted by e-mail at
> any time and without further explanation.
> E-mail transmission may not be secure or error-free as information could
> be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also
> processing of incoming e-mails cannot be guaranteed. All liability of
> Vontobel Holding Ltd. and any of its affiliates (hereinafter collectively
> referred to as "Vontobel Group") for any damages resulting from e-mail use
> is excluded. You are advised that urgent and time sensitive messages should
> not be sent by e-mail and if verification is required please request a
> printed version. Please note that all e-mail communications to and from the
> Vontobel Group are subject to electronic storage and review by Vontobel
> Group. Unless stated to the contrary and without prejudice to any
> contractual agreements between you and Vontobel Group which shall prevail
> in any case, e-mail-communication is for informational purposes only and is
> not intended as an offer or solicitation for the purchase or sale of any
> financial instrument or as an official confirmation of any transaction.
> The legal basis for the processing of your personal data is the legitimate
> interest to develop a commercial relationship with you, as well as your
> consent to forward you commercial communications. You can exercise, at any
> time and under the terms established under current regulation, your rights.
> If you prefer not to receive any further communications, please contact
> your client relationship manager if you are a client of Vontobel Group or
> notify the sender. Please note for an exact reference to the affected group
> entity the corporate e-mail signature. For further information about data
> privacy at Vontobel Group please consult www.vontobel.com.
>
>
> Important Notice
> This message is intended only for the individual named. It may contain
> confidential or privileged information. If you are not the named addressee
> you should in particular not disseminate, distribute, modify or copy this
> e-mail. Please notify the sender immediately by e-mail, if you have
> received this message by mistake and delete it from your system.
> Without prejudice to any contractual agreements between you and us which
> shall prevail in any case, we take it as your authorization to correspond
> with you by e-mail if you send us messages by e-mail. However, we reserve
> the right not to execute orders and instructions transmitted by e-mail at
> any time and without further explanation.
> E-mail transmission may not be secure or error-free as information could
> be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also
> processing of incoming e-mails cannot be guaranteed. All liability of
> Vontobel Holding Ltd. and any of its affiliates (hereinafter collectively
> referred to as "Vontobel Group") for any damages resulting from e-mail use
> is excluded. You are advised that urgent and time sensitive messages should
> not be sent by e-mail and if verification is required please request a
> printed version. Please note that all e-mail communications to and from the
> Vontobel Group are subject to electronic storage and review by Vontobel
> Group. Unless stated to the contrary and without prejudice to any
> contractual agreements between you and Vontobel Group which shall prevail
> in any case, e-mail-communication is for informational purposes only and is
> not intended as an offer or solicitation for the purchase or sale of any
> financial instrument or as an official confirmation of any transaction.
> The legal basis for the processing of your personal data is the legitimate
> interest to develop a commercial relationship with you, as well as your
> consent to forward you commercial communications. You can exercise, at any
> time and under the terms established under current regulation, your rights.
> If you prefer not to receive any further communications, please contact
> your client relationship manager if you are a client of Vontobel Group or
> notify the sender. Please note for an exact reference to the affected group
> entity the corporate e-mail signature. For further information about data
> privacy at Vontobel Group please consult www.vontobel.com.
>
-- http://www.freelists.org/webpage/oracle-l