Re: How to prevent Oracle Restart/SIHA/OHAS from attempting to open database needing recovery

There’s a line from the TV series, Agents of S.H.I.E.L.D, where the resident genius, after suffering a brain injury, is unable to help immediately solve a problem. He keeps repeating, “I didn’t solve this today”. My day-to-day is less Oracle focused these days, and that is a phrase that often crosses my mind when I get back into the Oracle side and come across something where I know a previous experience would either be the exact fit or at least get me going in the right direction.

I am curious to see how the crsctl add resource behaves in an HAS (instead of CRS) environment.

Thanks,
Ross

From: Tim Gorman <tim.evdbt_at_gmail.com> Date: Thursday, June 8, 2023 at 12:47 PM To: Ross Ohnesorg <Ross.Ohnesorg_at_cabelas.com> Cc: ORACLE-L <oracle-l_at_freelists.org> Subject: Re: How to prevent Oracle Restart/SIHA/OHAS from attempting to open database needing recovery Ross,

Thank you so much for your response!

This is a real face-palm.

I used the referenced material on behalf of a vendor called Teleran back in 2007 to automate the startup, shutdown, and status checking of the Teleran iSight product into the grid infrastructure for RAC, and did a presentation on the topic at the RMOUG Training Days conference in Feb 2008. I still have the PPTs!

Then, I resurrected similar functionality using the same features (HERE<https://urldefense.com/v3/__https:/community.delphix.com/communities/communityhome/digestviewer/viewthread?GroupId=97&MessageKey=5b8e83ea-bcb1-40d5-8efe-18adaf5a583d&CommunityKey=4e2d7f5c-8842-432b-86ec-1bd8b6f628d7&tab=digestviewer__;!!N4fOi5Mv!avdeQBZRDrsg8B0InN7ADZdX0EN1V0p9ET6W5kxGrVb0GxQZo60oy9lmu4rrFQmx2nK95GugKTlv8KrYXD8JlQ$>) while I was working for Delphix about 4 years ago in 2019.

I can understand forgetting about it all if all this were 15 years in the past, but forgetting stuff I blogged publicly about 4 years ago is pretty hard to admit. I mean, I frequently joke about forgetting what I've had for breakfast, but this is coming close to no longer being a joke.

Oh well.

Thank you so much for bringing this all back to the foreground!

Have a wonderful day!

-Tim

On 6/8/2023 10:13 AM, Ross Ohnesorg wrote: Not sure if I have my full posting privileges right now or not, but the old “action scripts” might be applicable here. We used them years ago on a similar setup. I think ours was a full CRS 11.2 cluster with single instance databases. A quick google search didn’t find the Oracle hosted version of this white paper, but here’s somebody else hosting it, https://levipereira.files.wordpress.com/2012/05/si-db-failover-11g-134623.pdf<https://urldefense.com/v3/__https:/levipereira.files.wordpress.com/2012/05/si-db-failover-11g-134623.pdf__;!!N4fOi5Mv!avdeQBZRDrsg8B0InN7ADZdX0EN1V0p9ET6W5kxGrVb0GxQZo60oy9lmu4rrFQmx2nK95GugKTlv8KpmnIM6Jg$>

You might be able to add logic there to do a startup mount, check for recovery, and then open the database. I don’t know if this would work with Oracle Restart instead of the full CRS stack.

Thanks,
Ross

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org><mailto:oracle-l-bounce_at_freelists.org> on behalf of Tim Gorman <tim.evdbt_at_gmail.com><mailto:tim.evdbt_at_gmail.com> Date: Thursday, June 8, 2023 at 9:26 AM
To: ORACLE-L <oracle-l_at_freelists.org><mailto:oracle-l_at_freelists.org> Subject: How to prevent Oracle Restart/SIHA/OHAS from attempting to open database needing recovery CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Friends and colleagues,

I have a customer using Oracle Restart (i.e. single-instance installation of Oracle Grid Infrastructure, a.k.a. SIHA, a.k.a. OHAS) for access to Oracle ASM.

They have a situation where they are restoring the entire VM from storage-level snapshots, including the Oracle database which was in "backup mode" at the time of the snapshot, and Oracle Restart is attempting to automatically open the database (which needs roll-forward recovery).

This automatic restart makes sense under normal conditions, when the database is not in need of media recovery. However, when the database is in need of media recovery, then automatically opening the database eliminates any possibility of performing roll-forward media recovery.

We can use srvctl to set startoptions from open to mount, and that will solve the problem when roll-forward media recovery is needed, but it leaves the database in unusable mount mode when the automatic restart is expected to automatically open the database.

So, Oracle Restart apparently does either STARTUP OPEN or STARTUP MOUNT blindly, instead of perhaps first MOUNTing the database, then checking if media recovery is needed before an OPEN is attempted, which would be the intelligent thing to do, and not difficult to automate into srvctl.

Has anyone resolved this problem?

Thanks!

-Tim
--

https://urldefense.com/v3/__http://www.freelists.org/webpage/oracle-l__;!!N4fOi5Mv!cm5uEXrwOZkvOVWa5EQU8wRVtXZ4p9_d84wlZVcC22mJVaw646ylOSuIMA04g23raFOZTWnAGoSrbCrsbIUfhA$<https://urldefense.com/v3/__http:/www.freelists.org/webpage/oracle-l__;!!N4fOi5Mv!cm5uEXrwOZkvOVWa5EQU8wRVtXZ4p9_d84wlZVcC22mJVaw646ylOSuIMA04g23raFOZTWnAGoSrbCrsbIUfhA$>

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 08 2023 - 22:56:43 CEST