recovery from 'ora-01194: file 1 needs more recovery to be consistent' may depend if your database is or is not in archivelog mode. When I talked about online redo log required to get out of this error, I was talking about scenariou when database was in NOARCHIVELOG. In such case the only logs one can use for recovery are online logs...