Check the recover datafile header

ORACLE_RMAN_Check the recover datafile header

set pagesize 20000

set linesize 180

set pause off

set serveroutput on

set feedback on

set echo on

set numformat 999999999999999

Spool recovery_info.txt

select substr(name,1, 50), statusfrom v$datafile;

select substr(name,1,40) name, status, recover, fuzzy,to_char(checkpoint_change#) datafile_SCNfrom v$datafile_header;

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

select * from v$recover_file;

select distinct statusfrom v$backup;

select hxfil FILENUMBER,fhstaSTATUS,fhscnSCN,fhrba_Seq SEQUENCE from x$kcvfh;

select distinct (fuzzy)from v$datafile_header;

spool off

exit

 

The V$BACKUP will change the valuesin the columns STATUS, CHANGE#AND record the start TIMEfor the FILE# thatis currently setto be backed up.

The STATUS column willchangetoNOT ACTIVEwhenthefileto be backed upis completed.

The V$DATAFILE_HEADERview will changethe statusinthe FUZZYcolumnTO "YES"whenthe "ALTER TABLESPACE <file_name> BEGINBACKUP" command has been issued.

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$LOGWHERE STATUS = 'CURRENT';