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

crsctl disable has will disable has entirely. Is that what you are looking for?

On Thu, Jun 8, 2023 at 10:26 AM Tim Gorman <tim.evdbt_at_gmail.com> wrote:

> 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
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l