psm dbcs rollback

Rolls back a patch that was applied to an Oracle Database Cloud Service instance.

Syntax

In the following syntax, line breaks have been added for clarity. Do not include them when entering the command.

psm dbcs rollback
  -s|--service-name instance-name
  -r|--rollback-id rollback-id
  [-n|--additional-note note-text]
  [-of|--output-format json|html|short]

Parameters

Parameter Description

-s|--service-name instance-name

Specifies the name of the Database Cloud Service instance on which you want to roll back the patch.

-r|--rollback-id rollback-id

Specifies the rollback ID of the patch to roll back. To learn the rollback ID of a patch applied to a service instance, use the psm dbcs applied-patches command.

-n|--additional-note note-text

(Optional) Specifies custom note text you want to associate with the rollback operation.

-of|--output-format json|html|short

(Optional) Specifies the output format of the command’s response:

  • json—output is formatted as a JSON array.

  • html—output is formatted as HTML

  • short—output is formatted as a brief summary.

The default output format is the one you specified when using the psm setup command to configure the psm CLI.

Examples

The following example rolls back application of the patch specified by rollback ID 131003 from the db12c-xp-si Database Cloud Service instance.

$ psm dbcs rollback --service-name db12c-xp-si --rollback-id 131003
{
    "status":"Completed",
    "details":{
        "message":"PATCHING-5038: Rollback of service from patch [22291127-EE] is submitted as an asynchronous job.",
        "jobId":"5858496"
    }
}
Job ID : 5858496

Here is the information about job 5858496 upon successful completion of the operation:

$ psm dbcs operation-status --job-id 5858496
{
    "activityLogId":3654168,
    "serviceName":"db12c-xp-si",
    "serviceType":"dbaas",
    "identityDomain":"usexample",
    "serviceId":129996,
    "jobId":5858496,
    "startDate":"2016-07-27T19:09:08.157+0000",
    "endDate":"2016-07-27T19:28:35.272+0000",
    "status":"SUCCEED",
    "operationId":129996,
    "operationType":"ROLLBACK",
    "summaryMessage":"ROLLBACK",
    "authDomain":"usexample",
    "authUser":"dbaasadmin",
    "initiatedBy":"USER",
    "messages":[
        {
            "activityDate":"2016-07-27T19:09:08.155+0000",
            "message":"Phase initialize completed"
        },
        {
            "activityDate":"2016-07-27T19:09:08.157+0000",
            "message":"Patching job [5858496] initiated by [dbaasadmin] started.."
        },
        {
            "activityDate":"2016-07-27T19:28:35.219+0000",
            "message":"Phase rollback completed"
        },
        {
            "activityDate":"2016-07-27T19:28:35.270+0000",
            "message":"Completed"
        }
    ]
}