10/21/2019 · select distinct (fhscn) from x$kcvfh just one value select distinct(fhsta) from x$kcvfh only the value of 0 select distinct status from v$backup not active Also we looked at the create controlfile script, it has resetlogs in the creation. The recovery command he was using was: recover database using backup controlfile, FHSCN SCN, FHTNM TABLESPACE_NAME,FHSTA status ,FHRBA_SEQ Sequence from X$KCVFH The FHSTA column of X$KCVFH shows the file-header status of the datafile. It always helps to take a look at this column immediately after the recovery and before OPENing the DB. The distinct FHSTA column values could be 0,1,4,8192,8196 etc.
SQL> select distinct fhsta STATUS from x$kcvfh STATUS—–4 8196 You can see that this is the SYSTEM datafile (filenumber =1): SQL> select hxfil FILENUMBER, fhsta STATUS, fhscn SCN, fhrba_seq SEQUENCE from x$kcvfh where fhsta = 8196 FILENUMBER STATUS SCN SEQUENCE—– .
6/13/2013 · SQL> select distinct fhscn SCN from x$kcvfh SCN—–5996813573990. Again, for checking purposes, you can see that one of the datafiles has a status of != 4. (4= consistent): SQL> select distinct fhsta STATUS from x$kcvfh STATUS—–4 8196. You can see that this is the SYSTEM datafile (filenumber =1):, select distinct FHSTA from X $ KCVFH select df . file #, to_char(df.checkpoint_change#, ‘9999999999999999’) controlfile_change, to_char ( dh . checkpoint_change # ,.
SQL> select distinct (fhscn) from x$kcvfh FHSCN —– 0 300260474884 300260535694 SQL> select distinct(fhsta) from x$kcvfh FHSTA —– 0 4 8196 SQL> select distinct status from v$backup …
