archive logs required to recovery

set echo on feedback on time on pagesize 20000

set linesize 300

set pause off

set serveroutput on

set feedback on

set echo on

set numformat 999999999999999

Spool recover.lst

alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';

select * from v$version;

select to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') as current_date from dual;

column name format a10

select dbid, name,

to_char(created, 'DD-MON-YYYY HH24:MI:SS') created,

open_mode, log_mode,

to_char(checkpoint_change#, '999999999999999') as checkpoint_change#,

controlfile_type,

to_char(controlfile_change#, '999999999999999') as controlfile_change#,

to_char(controlfile_time, 'DD-MON-YYYY HH24:MI:SS') controlfile_time,

to_char(resetlogs_change#, '999999999999999') as resetlogs_change#,

to_char(resetlogs_time, 'DD-MON-YYYY HH24:MI:SS') resetlogs_time

from v$database;

select * from v$instance;

archive log list;

select file#,substr(name, 1, 50), status,enabled from v$datafile;

select distinct to_char(checkpoint_change#, '9999999999999999')

from v$datafile;

select status, distinct checkpoint_change#, to_char(checkpoint_time,'DD-MON-YYYY HH24:MI:SS') as checkpoint_time

from v$datafile_header;

select substr(name,1,50), recover, fuzzy, checkpoint_change# from v$datafile_header;

select * from v$backup;

select name, open_mode, checkpoint_change#, ARCHIVE_CHANGE# from v$database;

select GROUP#,THREAD#,SEQUENCE#,MEMBERS,ARCHIVED,STATUS,FIRST_CHANGE#

from v$log;

select GROUP#,substr(member,1,60) from v$logfile;

select * from v$recover_file;

select * from v$recovery_log;

select HXFIL File_num,substr(HXFNM,1,40) File_name,FHTYP Type,

HXERR Validity,FHSCN SCN, FHTNM TABLESPACE_NAME,FHSTA status ,

FHRBA_SEQ Sequence

from X$KCVFH;

spool off