hi got close,

SQL> SELECT V1.GROUP#, MEMBER, SEQUENCE#, FIRST_CHANGE#
2 FROM V$LOG V1, V$LOGFILE V2
3 WHERE V1.GROUP# = V2.GROUP# ;

GROUP#
----------
MEMBER
--------------------------------------------------------------------------------

SEQUENCE# FIRST_CHANGE#
---------- -------------
1
E:\ORACLE\ORADATA\TRAIN1\REDO01.LOG
128 14471300

2
E:\ORACLE\ORADATA\TRAIN1\REDO02.LOG
129 14491303

GROUP#
----------
MEMBER
--------------------------------------------------------------------------------

SEQUENCE# FIRST_CHANGE#
---------- -------------

3
E:\ORACLE\ORADATA\TRAIN1\REDO03.LOG
130 14511306


SQL> SELECT FILE#, CHANGE# FROM V$RECOVER_FILE;

FILE# CHANGE#
---------- ----------
1 14511307
3 14511307
4 14511307
5 14511307
6 14511307
7 14511307
8 14511307
9 14511307
10 14511307
11 14511307
12 14511307

FILE# CHANGE#
---------- ----------
13 14511307

12 rows selected.

SQL> Recover datafile 'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF';
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 14511307 generated at 10/11/2004 06:19:41 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\ORA92\RDBMS\ARC00130.001
ORA-00280: change 14511307 for thread 1 is in sequence #130


Specify log: {=suggested | filename | AUTO | CANCEL}
E:\ORACLE\ORADATA\TRAIN1\REDO01.LOG
ORA-00310: archived log contains sequence 128; sequence 130 required
ORA-00334: archived log: 'E:\ORACLE\ORADATA\TRAIN1\REDO01.LOG'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF'


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 14511307 generated at 10/11/2004 06:19:41 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\ORA92\RDBMS\ARC00130.001
ORA-00280: change 14511307 for thread 1 is in sequence #130


Specify log: {=suggested | filename | AUTO | CANCEL}
E:\ORACLE\ORADATA\TRAIN1\REDO03.LOG
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

alert log:
ALTER DATABASE RECOVER LOGFILE 'E:\ORACLE\ORADATA\TRAIN1\REDO03.LOG'
Tue Oct 12 06:12:51 2004
Media Recovery Log E:\ORACLE\ORADATA\TRAIN1\REDO03.LOG
Incomplete recovery applied all redo ever generated.
Recovery completed through change 14511308
Media Recovery Complete
Completed: ALTER DATABASE RECOVER LOGFILE 'E:\ORACLE\ORADA
Tue Oct 12 06:14:00 2004
alter database open resetlogs
Tue Oct 12 06:14:01 2004
RESETLOGS after complete recovery through change 14511308
Resetting resetlogs activation ID 3709337036 (0xdd17fdcc)
Tue Oct 12 06:14:20 2004
Assigning activation ID 3724130951 (0xddf9ba87)
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: E:\ORACLE\ORADATA\TRAIN1\REDO03.LOG
Successful open of redo thread 1.
Tue Oct 12 06:14:21 2004
SMON: enabling cache recovery
Tue Oct 12 06:14:23 2004
Errors in file c:\oracle\admin\train1\udump\train1_ora_2432.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-08103: object no longer exists

Tue Oct 12 06:14:23 2004
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 2432
ORA-1092 signalled during: alter database open resetlogs...