Hi All,
I am using Oracle Version 11.2.0.3.0 and I have taken FULL backup of one of my database. Database is in OPEN state when backup taken so added archive files also.
now the question is, I have all the required files and archives to restore backup and I restored also but when run recover database command it started but failed with below error...
no backup of archived log for thread 1 with sequence 1604 and starting SCN of 242321322 found to restore
from above error I want to make sure require recovery is done ...so verify it through x$kcvfh as below.
SQL> select fhrba_seq, count(*) from x$kcvfh group by fhrba_seq order by fhrba_seq;
FHRBA_SEQ COUNT(*)
---------- ----------
1604 50
1608 15
I used to check x$kcvfh to make sure how much recovery is required but here I get two sequence ...1604 for 50 files and 1608 for rest 15 files..
Not able to understand why and how two sequences required to restore backup?
Please guide me.
Thanks in advance.