Does it make sense to have enterprise manager installed on the standby database server?
I am running 11gr2 on Windows Server 2008R2 64 bit. I have primary database (pprd) on one server, and standby server (pprd_dr0) on another server.
I do not have grid control set up (yet).
After getting my standby database working with data guard, there is no Enterprise Manager. I only have SQL Plus to administer it. Does it make sense for me to install enterprise manager on the standby database server? If I do that, wouldn't the schemas then be out of sync with the primary database (sysman) for example, thus defeating part of the purpose of having the standby database be identical to the primary?
Or do people typically NOT install EM on the standby database server?
"Does it make sense to have enterprise manager installed on the standby database server" No. You would only install the agent on the standby in most cases. ( After you setup EM of course if you want it )
If you are new to Data Guard run it with SQL for awhile and get the feel of it.
Later you can decide if you want to use Data Guard Broker or EM.
Here's a query to monitor using SQL: