Just finished running log miner on a development database and found that SQL_REDO column had an invalid SQL statement containing HEXTORAW values
INSERT INTO HR.EMPLOYEES(col#1, col#2) values (hextoraw('69i57j33i22i29i30'),hextoraw('a108944'));"
Generally, the SQL_REDO column contains an SQL statement that allows you to revert any query. For example, for an INSERT statement, SQL_REDO will contain DELETE statement. For a DELETE statement, SQL_REDO will contain INSERT statement.
Basically, you can rollback by running the query under SQL_REDO column. But in my case, I got an invalid INSERT statement (against a delete statement) with some HEXTORAW values.
Problem: I just cannot run it directly against the database 😞