After cluster service relocation Oracle DB was switched to read-only mode

Issue

• In two node cluster one of the node was fenced/rebooted so the cluster service cantoning Oracle databse was relocated to remaining node. Although the service was relocated was successfully and fs, lvm, Oracledb resources were started, it was found that Oracle db was switched to read-only mode.

• This issue occurs only if the service relocation is triggered when databse backup is going on. The databse administrator had manually executed following command to switch the db in read-write mode:

  To check the current status:

  SELECT FILES#, STATUS FROM V$BACKUP;
  

  To change the status and bring the database out of read only mode

  ALTER DATABASE END BACKUP; 
  

• Is it possible to configure rgmanager to verify if the Oracle DB status is read-only and execute above commands automatically to switch it to read-write mode again?