Database Administration (MOSC)

MOSC Banner

"versions between scn|timestamp" and "as of timestamp" actually does not need flashback database set

edited Sep 9, 2020 9:26AM in Database Administration (MOSC) 6 commentsAnswered ✓

Hi

Oracle 19c RAC EE.

OEL 7

SQL> select flashback_on from v$database;FLASHBACK_ON      ------------------NO                1 row selected.

I can successfully execute and see which rows were changed between that timeframe (within by undo_retention parameter of course).

SQL> select versions_startscn, versions_starttime, versions_endscn, versions_endtime, versions_xid, versions_operation, ...FROM tab1VERSIONS between timestamp sysdate -1/24/20 and sysdateWHERE id = 65;

Also I can query table's data at certain time (within by undo_retention parameter of course).

SQL> select * from tab1 as of timestamp sysdate -1/24 where id = 65;

I understood, that these features are available whenever I have flashback database set to ON.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center