Environment:
Oracle DB Version 11.2.0.3.0
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
O.S Version HP-UX B.11.31 U ia64
Question : How to determine when a cluster ready database service started on a RAC node?
I have cluster ready database services running on their available nodes rather than their preferred nodes. I am trying to find when they switched.
Where to look for ? Either by looking in a log or querying a data dictionary view or some other method.
I am aware that a service starts on the first node if it automatic.
I want to know how to find when it started on a particular node.