Patch History

Starting with Oracle Enterprise Manager 13.5 Release Update 21 (13.5.0.21) you can now access database patching history for update and upgrade operations in Fleet Maintenance.

Note:

Your environment's data retention policy dictates how far back Fleet Maintenance can show update and upgrade history.

Currently the following target types are supported for Patch History:

Single Instance databases
RAC databases
Grid Infrastructure
Single Instance High Availability (SIHA)

Obtain Patch History Via EM CLI

Read Patch History:

emcli lcm_operations
-getLcmHistory                
-input_file="<path of the JSON file>"

Where the input file contains the following:

 {
    "targetNames" : [<List of targets>],
    "targetType" : "oracle_database",
    "targetIds" : [<List of ID's>],
    "tasks" : ["update", "upgrade"],
    "timeStartedGreaterThanOrEqualTo" : "<Start date format YYYY-MM-DD HH:MM:SS>",
    "timeStartedLessThanOrEqualTo" : "<End date format YYYY-MM-DD HH:MM:SS>",
    "status" : "completed",
    "sort" : "targetType",
    "limit" : 100,
    "page" : "<Page ID>"
}

Export Patch History:

emcli lcm_operations
-exportLcmHistory                
-input_file="<path of the JSON file>"

Where the input file contains:

 { 
   "destinationHostName" : "<host name>",
   "destinationHostCredential" : "<host_cred>",
   "csvFileLocation" : "<CSV file path>",
   "csvFileName" : "<file_name.csv>"
   "targetNames" : [<list of targets>],
   "targetType" : "oracle_database",
   "targetIds" : [<list of ids>],
   "tasks" : ["update", "upgrade"],
   "timeStartedGreaterThanOrEqualTo" : "<Start date format YYYY-MM-DD HH:MM:SS",
   "timeStartedLessThanOrEqualTo" : "<End date format YYYY-MM-DD HH:MM:SS",
   "status" : "completed",
   "sort" : "targetType"
}

Use the following EM CLI commands to read and export your Fleet Maintenance update and upgrade history:For a complete list of definitions and examples of the lcm_operations verb see: lcm_operations

Obtain Patch History Via REST API

For REST API see: Database Maintenance- Updates (Patching) And Upgrades REST Endpoints.