recover 时需要检查的信息

recover database前看看

set lin 200 pages 1000
col NEXT_CHANGE# for 999999999999999
col checkpoint_change# for 999999999999999
col member for a55
col name for a65
col file_name for a65
col error for a20
set markup html on
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
spool /tmp/recover_info.html

select dbid,name,open_mode,created,log_mode,checkpoint_change#,CONTROLFILE_TYPE ctl_type,CONTROLFILE_CREATED ctl_created,CONTROLFILE_TIME ctl_time,resetlogs_change#,resetlogs_time from v$database;

select TS#,FILE# ,CREATION_CHANGE# ,CREATION_TIME,STATUS, ENABLED, CHECKPOINT_CHANGE#, CHECKPOINT_TIME LAST_TIME ,
OFFLINE_CHANGE#, ONLINE_CHANGE#, ONLINE_TIME, round(bytes/1024/1024) bytes_m, BLOCKS, CREATE_BYTES, BLOCK_SIZE, NAME file_name from v$datafile order by ts#,file#;

select TS#,FILE#,STATUS,ERROR,FORMAT,RECOVER,FUZZY,CREATION_CHANGE#,CREATION_TIME,TABLESPACE_NAME,RESETLOGS_CHANGE#,RESETLOGS_TIME,CHECKPOINT_CHANGE#,CHECKPOINT_TIME,
CHECKPOINT_COUNT,BYTES,BLOCKS,NAME,SPACE_HEADER,LAST_DEALLOC_CHANGE#,UNDO_OPT_CURRENT_CHANGE# from v$datafile_header order by ts#,file#;

select * from v$recover_file order by 1;

select a.*,b.* from v$log a ,v$logfile b where a.group#=b.group#;
spool off

好大喜功
 

set pagesize 20000
set linesize 180
set pause off
set serveroutput on
set trims on on
set feedback on
set echo on
set numformat 999999999999999
Spool recovery_info.txt
col fn for a60
col status for a15
select substr(name, 1, 50) fn, status from v$datafile;
select substr(name,1,40) fn, recover, fuzzy, checkpoint_change# from v$datafile_header;
select GROUP#,substr(member,1,60) fn from v$logfile;
col error for a30
select * from v$recover_file;
select distinct status from v$backup;
select hxfil FILENUMBER,fhsta STAT,fhscn SCN,fhrba_Seq SEQUENCE from x$kcvfh;
select distinct (fuzzy) from v$datafile_header;
spool off
exit