GGSCI> info extract extract_name, showch ;
copy the SCN number from above output.
select name, thread#, sequence#, status, first_time, next_time, first_change#, next_change# from v$archived_log where 25772732953522 between first_change# and next_change#;
select name, thread#, sequence#, status, first_time, next_time, first_change#, next_change# from v$archived_log where <scn> between first_change# and next_change#;
Path/to/archivelog/1_8322558_956503891.arc
No comments:
Post a Comment