19c GI Patching - 19c RAC Oracle Home Patching - Database Post Patching Steps - Datapatch
Vložit
- čas přidán 24. 10. 2020
- GI Home patching:
===============
1) Stop GI Home as root user
2) Unlock the GI Home as root user
3) grant permission patch directory as root user
4) As grid user do prechks
Do OPatch version and current lspatches checks
Conflict pre checks:
System space prechk:
5) Apply Patch:
6) Post verification
7) Lock and start GI
DB Home patching
================
Stop DB Home as root user
grant permission on patch directory as root user
As oracle user do prechks
Do OPatch version and current lspatches checks
Conflict pre checks:
System space prechk:
Apply Patch:
Post verification
Start ORACLE_HOME as root user
RAC Database Patching - Datapatch
==============================
Do database prechecks
Run the database post steps - datapatch
Verify the database post steps
#19c #Patching #OPatch #RACPatching #OracleHomePatching #Datapatch #Rolling #12c #Oracle #RAC #Database #Exadata
Please do follow me and support me on,
LinkedIn: / mallik034
CZcams: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
CZcams: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg - Věda a technologie
Very well done, important not to stop at the 17 minute mark as the subsequent demonstration is very informative and helps to illustrate the previous section.
That's nice catch. I believe explanation with graphical illustration will help in understanding easily.
Glad that it helped you.
Your videos are the best, you answered all my questions regarding this topic. Thank you!!!
Your content is Gold for a DBA👏🏻👏🏻👏🏻👏🏻
thanks
Thank you so much for the great explanation
Much thanks for your valuable session sir.
Always welcome
Thank you Bro. Very informative.
Really helpful..Thanks for such great video
Excellent video
Many thanks for your efforts
good contents, very practical... Thanks
You are welcome
Thank you so much 🙏
You're welcome 😊
Create restore point and take backup of binary is missing other wise it is amazing video
Very Good
Is there any way to apply datapatch(OJVM) without downtime like rolling fashion in 3 node rac ??
Do we need to apply datapatch for every database in cluster by setting environment
Suppose we have multiple databases in 2 node rac
Hi sir ,
We can opatchauto sir it will apply on both grid and oracle home , ojvm we will separately
Hi mallik, In the first node we can see 3 diff DB running with diff home. To patch DEV DB using rolling fashion , we can use srvctl stop instance... command right to stop the instance on node 1.
Is srvctl stop instance & srvctl stop home same or different in this scenario?
Yes we can do that. better you can go with srvctl stop home.
If only DBs running on that home means it does not matter you can go with whichever way.
Other than DB some services and listener are all running on that home means then you have to go with srvctl stop home.
Thank you for the detailed session :)
Quick question: For Ex: If a DB_HOME1 has 10 databases, here we are using SRVCTL to STOP/START databases in its original state.
Usually DATAPATCH to be run in UPGRADE mode, in the above case how we can start DB in UPGRADE and once patch completed later need to start DB to its original state.
Can you please suggest
Only only if you apply OJVM patch then you need to start your database instance in upgrade mode and run the datapatch
If you apply PSU you can run the datapatch in open mode.
You have to set cluster_database parameter to false and start only 1 instance in upgrade mode and run the datapatch.
After datapatch set cluster_database parameter back to true and start your database using srvctl
Thanks Mallik, very informative 🙏🙏 , one quick query do we need to run the Datapatch verbose from all the nodes?
Or just running it from one node is fine?
Any one node u can run it.
No need to run from all the nodes
Very nice tutorial, thanks! For 12c I guess that are similar steps. I have to migrate a 12c database, is it correct to install database software on new machines, install patches and after that to restore database with rman? Ty!
Thats correct
Hi , Nice explanation . Really helpful . 1 query While patching on node 1 , DB is fully running on Node 2 correct ? I mean no need to take application downtime? right ?
Please let me know
Please reply ..
Thanks you sir Sir...... You explain steps very well. the ocmrf response file is depricated
Yes that correct
Hi Malik, Nice content.. can u share me the notepad with all commands for reference ?
One quick question, while patching to DB home, do we need to bring down DB or instance only ?
we need to bring down one instance out of two instance running for the database then we can apply the patch at binary level for one instance then start instance one and then go to second node stop instance second and apply the patch to binary of 2nd instance and then start second instance ,, to apply the patch at database level using datapatch we can apply data patch when both the instance are running and up. Datapatch can be applied to only one instance
Hi, why you dont´use opatchauto instead of opatch ? With opatchauto you can patch in a single command both GI home and DB home and will avoid all the manul steps that you are doing
opatchauto is really a great tool. You can use that
In case if opatchauoto fails at end moment suppose after 99% of patching completed and if it fails then it will rollback everything.
opatchauto can to
>>> GI patching
>>> DB patching
>>> datapatch also
sir.when we unlock gi home does it bring down the DBs(instances)on that particular server?
Yes thats correct
@@Mallik034 imagine that there are 2 nodes. Does it apply datapatch verbose during first node or during the second node?