Oracle Database Restore archivelogs from Sequence to Sequence Based on the Dates we give.

select ‘restore archivelog from logseq ‘|| min(sequence#) || ‘ until logseq ‘ || max(sequence#) || ‘ thread ‘ || thread# || ‘;’from gv$archived_logwhere completion_time between to_date(‘&start_date’,’DD-MON-YY HH24:MI:SS’) AND to_date(‘&end_date’,’DD-MON-YY HH24:MI:SS’) group by thread#;     Input Required: Enter value for start_date: 02-OCT-16 Enter value for… Read More