Home Topics HVR Real-time Replicator Community Discussions What is the oldest REDO archive log file HVR currently has access to
Execute the following query to get the total period of spanning all available REDO files.
select min(first_time), max(next_time) from v$archived_log where standby_dest='NO' AND name <> ' ';
To examine them individually you can run the following statement in the source database:
select name, min(first_time), max(first_time), min(next_time), max(next_time), count(*) from v$archived_log where standby_dest='NO' group by name;
To get not only the dates but also the time alter the date format:
alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';
Bear in mind HVR may only rewind back to that point if supplemental logging for the tables in the channel was turned on at that point.
© 2020 HVR
It appears you are still using Internet Explorer. Support for IE has been discontinued by Microsoft, and many features of our site may not display or work properly.
Please upgrade (it's free!) to Edge, Chrome, Safari, or any modern browser for the best user experience.