Two days ago I migrated the vCenter (2.5U3) database from a local Oracle DB (10gR2 10.2.0.4) to our new Oracle RAC with better availability. Apparently al worked smoothly. Just exporting the vCenter Schema, then importing on the new DB and changing the OBDC DSN's did it, Even more, the performance data retrieval was considerably faster so I was quite happy. But today I noticed that the performance data is not being added to the DB since the graphs are cut just on the same moment we did the migration.
Looks like you've got a problem with the Stats_Rollup. I know this is for MSSQL but take a look at this thread, it may help. There are some scripts mentioned in the last post that could sort it
Thanks,
Neil
Okay... The problem was with the dabatabase jobs running the stats rollup being broken... My DBA simply fixed it by copying the SQL script for these jobs from the old database.
