Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

Copy OEM metrics when we upgrade an oracle database from stand-alone to PDB

in Managing Databases using Enterprise Manager (MOSC) 1 commentAnswered ✓

When we upgrade an oracle database from stand-alone to PDB, it gets a new TARGET_GUID. This means that all OEM metrics for the original database are unavailable. How do we copy OEM metrics to the new GUID?

I use OEM metrics on CPU, Memory, I/O, Network and Tablespace Usage for the past year for capacity planning of the production database. The production server is over-powered so we don't need to check things every day but a yearly health check is a good idea and it shows that I'm doing an adequate job. We've seen the loss of OEM metrics on the first non-PROD databases that were converted to PDBs. I would prefer that this doesn't happen in PROD.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center