闪回查询和闪回版本查询是否需要开启闪回？

不需要！

备份恢复Lesson 14. Using Flashback Technologies

SELECT * FROM DBA_OBJECTS AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '8' HOUR) where rownum < 3;

SELECT * FROM DBA_OBJECTS AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' HOUR) where rownum < 3;

SELECT * FROM dba_objects AS OF TIMESTAMP TO_TIMESTAMP('2022-04-01 02:30:00', 'YYYY-MM-DD HH:MI:SS') where rownum < 3;