What is the oldest REDO archive log file HVR currently has access to

  • This topic is empty.
Viewing 1 post (of 1 total)
  • Author
    Posts
  • #8847
    Frank Knot
    Participant

    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.

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.
Test drive
Contact us