ORA- 01194: file needs more recovery to be consistent

Following are the steps after applying all the archived log files and encountering the error

ORA- 01194: file needs more recovery to be consistent


SQL> select group# from v$log where status='CURRENT'; -- Q(A)

SQL> select member from v$logfile where group#= "group identified in Q(A)"; -- Q(B)

SQL> recover database until cancel using backup controlfile;

Specify log: {=suggested | filename | AUTO | CANCEL}

[specify the redolog file name which identified in Q(B)"