Tracnac/Recover vs Applied.md

Last active October 19, 2022 11:39

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Tracnac/b3c029ea00571ef5d58e8562ada90a13.js"></script>
Save Tracnac/b3c029ea00571ef5d58e8562ada90a13 to your computer and use it in GitHub Desktop.

Download ZIP

Recover vs Applied #oracle #sql

Raw

Recover vs Applied.md

sqlplus -s / as sysdba << EOF
ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-RR HH24:MI:SS';
select '${i}' from dual;
select SEQUENCE#,first_time from v\$archived_log where sequence# = (select max(sequence#) from v\$archived_log) order by first_time;
select sequence#, first_time from v\$archived_log where (select resetlogs_change# from v\$database) between first_change# and next_change#;
quit

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment