Things not always go right, and recently I had to recover the OEM repository using a one month old datapump backup. Only SYSMAN schema was corrupted, and I did not touch the other schemas.<\/p>\n\n\n\n
I probably still miss doing some things and this post is mostly a note to make it faster for other people going through the process and not having a DB backup… <\/p>\n\n\n\n
A full restore of the database would be certainly a much better and efficient solution than the one below. \ud83d\ude42<\/p>\n\n\n\n
To recover the corrupted SYSMAN schema where the OEM repository resides, first I drop it and then I did:<\/p>\n\n\n
\n# Restore user\nimpdp schemas=SYSMAN directory=BACKUP_DIR dumpfile=expdp_sysman_april2021.dmp include=USER\n\n# Restore system grants:\nSQL> grant execute on dbms_crypto to sysman;\nSQL> grant execute on dbms_lock to sysman;\nSQL> grant execute on dbms_rls to sysman;\nSQL> grant execute on dbms_aq to sysman;\nSQL> grant execute on dbms_aqadm to sysman;\nSQL> grant execute on dbms_alert to sysman;\n\n# Restore other object grants \nimpdp directory=BACKUP_DIR dumpfile=expdp_sysman_april2021.dmp include=GRANT\n\n# Restore data\nimpdp schemas=SYSMAN directory=BACKUP_DIR dumpfile=expdp_sysman_april2021.dmp \n\n# Restart queues\n\/* select 'exec DBMS_AQADM.START_QUEUE(queue_name => ''SYSMAN.'||name||''');' from dba_queues where enqueue_enabled like '%NO%' and owner='SYSMAN' order by 1; *\/\nSQL> exec dbms_aqadm.start_queue('SYSMAN.MGMT_ADMINMSG_BUS',true,true);\nSQL> exec dbms_aqadm.start_queue('SYSMAN.EM_CNTR_QUEUE',true,true);\nSQL> exec dbms_aqadm.start_queue('SYSMAN.EM_LOADERJOB_QUEUE',true,true);\nSQL> exec dbms_aqadm.start_queue('SYSMAN.EM_EVENT_BUS',true,true);\nSQL> exec dbms_aqadm.start_queue('SYSMAN.EM_NOTIFY_Q',true,true);\nSQL> exec dbms_aqadm.start_queue('SYSMAN.EM_GROUP_EVENT_Q',true,true);\nSQL> exec DBMS_AQADM.START_QUEUE('SYSMAN.EM_JOB_STATUS_UPD_Q');\nSQL> exec DBMS_AQADM.START_QUEUE('SYSMAN.MGMT_HOST_PING_Q');\nSQL> exec DBMS_AQADM.START_QUEUE('SYSMAN.MGMT_LOADER_Q');\nSQL> exec DBMS_AQADM.START_QUEUE('SYSMAN.MGMT_NOTIFY_INPUT_Q');\nSQL> exec DBMS_AQADM.START_QUEUE('SYSMAN.MGMT_TASK_Q');\nSQL> commit;\n\n# Perform partitionion maintenance (as SYSMAN):\nSQL> exec gc_interval_partition_mgr.partition_maintenance;\nSQL> exec mgmt_audit_admin.add_audit_partition;\n<\/pre><\/div>\n\n\nStart OEM again:<\/p>\n\n\n
\nemctl start oms\n<\/pre><\/div>\n\n\nUnblock the agents (Setup – Manage Cloud Control – Agents – select blocked agents + “unblock”) and on each monitored host, clear the agent state, restart it and test:<\/p>\n\n\n
\nemctl clearstate agent\nemctl stop agent\nemctl start agent\nemctl control agent runCollection $(hostname -f):host Response\nemctl status agent\n<\/pre><\/div>\n\n\nAfter this, OEM was running again without problems.<\/p>\n","protected":false},"excerpt":{"rendered":"
Things not always go right, and recently I had to recover the OEM repository using a one month old datapump backup. Only SYSMAN schema was corrupted, and I did not touch the other schemas. I probably still miss doing some things and this post is mostly a note to make it faster for other people […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[],"class_list":{"0":"post-484","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-oms","7":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/484","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=484"}],"version-history":[{"count":2,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/484\/revisions"}],"predecessor-version":[{"id":487,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/484\/revisions\/487"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}