Check status recovery (database able open resetlogs)

terkadang kalau kita melakukan restore dan incomplete recovery
misal recovery until cancel bagaimana cara check nya bahwa hasil recover nya itu
dapat diopen resetlogs, bagaimana caranya ngecheck ... ya begindang :

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), status from v$datafile;
select substr(name,1,40), recover, fuzzy, checkpoint_change# from v$datafile_header; select GROUP#,substr(member,1,60) from v$logfile;
select * from v$recover_file;

select distinct status from v$backup; (NO)
select hxfil FILENUMBER,fhsta STATUS,fhscn SCN,fhrba_Seq SEQUENCE
from x$kcvfh; ( harus 1 row )
select distinct (fuzzy) from v$datafile_header; (fuzzy harus NO)

spool off
exit


select distinct status from v$backup; (NO)
select hxfil FILENUMBER,fhsta STATUS,fhscn SCN,fhrba_Seq SEQUENCE from x$kcvfh; ( harus 1 row )
select distinct (fuzzy) from v$datafile_header; (fuzzy harus NO)