This content has been marked as final. Show 5 replies
yakub21 wrote:Where is proof? Please paste here your findings.
I just checked one of my primary databases which has an active standby database on a different zone server and I'm seeing the Standby Processes on both the Primary Server and the Standby Server.
The Primary is accessible though I don't understand why the Oracle Standby Processes are showing up on the Primary Database when I do a:
ps -ef|grep pmon
On the Primary Both PMONS show up on the Primary. Any Ideas Why.
Oracle 11gR2 Database Primary Name and Standby.
What do you think is 'the Standby Processes' ? It's not PMON - that process will always be at every started instance regardless which kind of database (or ASM instance) you have.
Do you see MRP0 (Managed Recovery Process) on the Primary? That would indeed be strange - I hesitate to say impossible :-)
"Don't believe it, test it!"
It looks like you might have some process or scripts with prefix or suffix "Standby" and it is causing the confusion to you.
If you still see both process provide the output.
ORA-01031: insufficient privileges
How to Change Oracle DBNAME and DBID
No. After further analysis of the problem I discovered that the System Administrator claims that he created the Solaris 10 Global zone on the Primary Database server and created a Local Zone for the Physical Standby Server. I find that very confusing from the Unix Server configuration perspective because now you have to ask the question about Global and Local Zones. My expectation was that the primary and physical standby would be in its own zone utilizing the carved out resources from the global zone. However the System Administrator argued that you must query the local zone/Global Zone. I simply don't prefer such an approach. I prefer to be able to query the specific processes for a given zone independently so as to confirm optimal configuration of the server.