Ever wanted to know if the optimizer is obeying your hint?
+HINT_REPORT #oracle_19c
+HINT_REPORT #oracle_19c
#oracle
UNTIL CONSISTENT Use this clause to recover the standby database to a consistent SCN point so that the standby database can be opened in read only mode.
Instead, to recover the standby database to a consistent point, but no further, use the statement
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE UNTIL CONSISTENT.
UNTIL CONSISTENT Use this clause to recover the standby database to a consistent SCN point so that the standby database can be opened in read only mode.
Instead, to recover the standby database to a consistent point, but no further, use the statement
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE UNTIL CONSISTENT.