Recovery Script

Recovery Script

spool recovery_details.txt
set pagesize 20000
set linesize 180
set pause off
set serveroutput on
set feedback on
set echo on
set numwidth 30
alter session set nls_date_format = 'dd-mon-yyyy hh24:mi:ss';
archive log list;
select name,db_unique_name,dbid,controlfile_type,controlfile_time,open_mode,database_role,checkpoint_change#,archive_change# from v$database;
select * from v$database_incarnation;
select INCARNATION#, RESETLOGS_TIME from V$DATABASE_INCARNATION order by RESETLOGS_TIME ;
col name for a75
select file#,name,status,enabled from v$datafile;
select * from v$recovery_file_dest ;
select * from v$recover_file ;
select * from v$recovery_log ;
select file#,name,recover,fuzzy,checkpoint_change#,creation_change#,creation_time from v$datafile_header;
col error for a15
select FILE#,STATUS,ERROR,RECOVER,FUZZY,CREATION_CHANGE#,CREATION_TIME, RESETLOGS_CHANGE#,RESETLOGS_TIME from v$datafile_header;
select status,checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time, count(*), fuzzy from v$datafile_header group by status,checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time, fuzzy;
select status, checkpoint_change#, fuzzy,
to_char(checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time,
count(*)
from v$datafile_header
group by status, checkpoint_change#, fuzzy, checkpoint_time
order by status, checkpoint_change#, fuzzy, checkpoint_time;
select file#,substr(name,1,70) name, error, status,recover, fuzzy, resetlogs_change#, resetlogs_time,checkpoint_change#,checkpoint_time from v$datafile_header where fuzzy='YES';
select file#,ts#,substr(name, 1, 70), status,checkpoint_change# from v$datafile where status not in ('SYSTEM','ONLINE');
select checkpoint_change#,controlfile_time 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 min(fhscn) from x$kcvfh;
select min(fhrba_Seq), max(fhrba_Seq) from X$KCVFH;
select count(*),fhsta from x$kcvfh group by fhsta;
select count(*),fhrba_seq from x$kcvfh group by fhrba_seq;
select count(*),fhscn from x$kcvfh group by fhscn;
select count(*),fhafs from x$kcvfh group by fhafs;
select hxfil FileNo,FHSTA status from x$kcvfhall;
select fhdbn,fhdbi,hxfil,fhsta,fhscn,fhafs,fhrba_seq,fhtnm tbs_name from x$kcvfh;
spool off
exit

-+-