Downgrade Databases

In the event of an error or misconfiguration Grid Infrastructure and Single Instance High Availability (SIHA) databases can be retroactively downgraded to the previous version.

Downgrade Using EM CLI

To downgrade a database using EM CLI, use the following commands:

• Grid Infrastructure:

  emcli db_software_maintenance 
  -performOperation -purpose=DOWNGRADE_GI
  -name="Downgrade GI" 
  -description="Downgrade GI" 
  -target_list=<cluster target list> 
  -target_type=cluster
  -normal_credential=NORMAL:SYSMAN 
  -privilege_credential=ROOT:SYSMAN

• SIHA:

  emcli db_software_maintenance 
  -performOperation 
  -name="Downgrade SIHA"
  -description="Downgrade SIHA" 
  -purpose=DOWNGRADE_SIHA 
  -target_list=<databse target list> 
  -target_type=has
  -normal_credential=NORMAL:SYSMAN 
  -privilege_credential=ROOT:SYSMAN

Note:

Use -force="true" in case of a downgrade, due to upgrade failure. This will force the downgrade operation to execute.

Downgrade Using REST API

To downgrade using REST API use the following:

Table 19-1 Downgrade Grid Infrastructure

Feature	Description
Request Method	POST
URI	<OMS_CONSOLE_HOST>:OMS_CONSOLE_PORT>/em/websvcs/restful/emws/db/fleetmaintenance/performOperation/rollback
Headers	Authorization: Basic Accept: application/json
Payload	{ "name": "Downgrade GI", "targetName" : "example-cluster", "targetType" : "cluster", "normalCredString" : "USER:SYSMAN", "privCredString" : "ROOT:SYSMAN", "downgradeOperation":"true" }

Table 19-2 Downgrade SIHA

Feature	Description
Request Method	POST
URI	<OMS_CONSOLE_HOST>:OMS_CONSOLE_PORT>/em/websvcs/restful/emws/db/fleetmaintenance/performOperation/rollback
Headers	Authorization: Basic Accept: application/json
Payload	{ "name": "Downgrade SIHA", "targetName" : "<Has target>", "targetType" : "has", "normalCredString" : "USER:SYSMAN", "privCredString" : "ROOT:SYSMAN", "downgradeOperation":"true" }