I have a cluster of Oracle RAC with 4 primary nodes
master 1, master2, master3, master 4
I want to know which master node generates an online redo log or archived redo log.
For example, if there is an online redo log with a sequence of 120, can I be sure that it was generated by a master node?
If the redo log sequence for an archive is 100, is it also certain that it was generated by a primary node?
I see that there is a thread field in V$LOG. Can use this value to find the instance name in the $thread table and then find the corresponding host in v$instance ?
I don’t know if this is possible.
The thread field in the v$log table is not clearly explained in the oracle documentation, and this value is not a thread in the process at the operating system level.
Is it a logical concept? Is it possible for multiple instances of thread ids to conflict?
Can I use the table information in the database to find out which instance the redo log belongs to
wang michael is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.