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
