Does Oracle use rowid to recover from redo log and archives?
From Oracle Database Utilities - section Supplemental Logging

An application that applies reconstructed SQL statements to a
different database must identify the update statement by a set of
columns that uniquely identify the row (for example, a primary key),
not by the ROWID shown in the reconstructed SQL returned by the
V$LOGMNR_CONTENTS view, because the ROWID of one database will be
different and therefore meaningless in another database

While they don't say it in so many words, the &quot;not by ROWID&quot; (in the context of the sentence) strongly suggests that normal redo recovery is by rowid..