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

From: Tim Gorman <tim.evdbt_at_gmail.com>
Date: Thu, 8 Jun 2023 08:25:06 -0700
Message-ID: <26fe5a82-5874-f504-4d88-c6cebfd670af_at_gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 08 2023 - 17:25:06 CEST

Original text of this message