Ora-01194:file 1 needs more recovery to be consistent

Today the company's Oracle database suddenly dropped, this is our core database, very nervous. First try shutdown, you can normal shutdown, but the implementation of startup error, the error message is as follows: Errors in File/opt/oracle9/oracle/admin/ora9/udump/ora9_ora_ 29602.trc:ora-00314:log 1 of Thread 1, expected sequence# 1394 doesn ' t match 1018 ora-00312:online log 1 thread 1: '/va R/oracle/redolog/redo01a.log ' Sun Nov  3 01:21:43 2013 Errors in file/opt/oracle9/oracle/admin/ora9/udump/ Ora9_ora_29602.trc:ora-00600:internal error code, arguments: [KSFDCHKFOBRERR1], [0x000000000], [0x000000000], [], [], [ ], [], [] ORA-600 signalled During:alter DATABASE OPEN ... Sun Nov  3 10:48:35 2013 Errors in file/opt/oracle9/oracle/admin/ora9/udump/ora9_ora_1561.trc:ora-27037:unable to Obtain file status HP-UX error:2: No such file or directory is just beginning to feel that the problem is redo logs, just want to clear the redo log, the result is the current log out of the problem, no archive can not clear out, and then try Sta Rtup force, or there is a problem, if you enable the recover database until cancel, waiting for input because did not understand what is the problem of the choice of auto, the results of the same error, and then consulted the company responsible for Oracle database technology Support engineers, The engineer asked me to send the error files to him, he said very serious, let me put the database, and then the database, control files, redo log files and configuration files back up, and then perform Rman recovery (do the night before yesterdayAn Rman full backup, and the backup was successful. ) more than 200 g of data files, copy a day, wait until the evening finally copy finished, I always feel wrong, feel that the archive file is missing, just want to see how the archive log lost recovery, and then find the following method, tried a bit really recovered, and knew so do not have to stop business for a day.
From: http://space.itpub.net/22021749/viewspace-614544 opened the database today when I do not know how to do, can not open, first prompted the database is not properly closed, using shutdown immediate, Wait for a while not to end, so directly ended the process, and then came out with a problem
sql> ALTER DATABASE open resetlogs;
ALTER DATABASE open Resetlogs
*
ERROR at line 1:
Ora-01194:file 1 needs more recovery to be consistent
Ora-01110:data file 1: '/U01/APP/ORACLE/ORADATA/ORCL/SYSTEM01.DBF '

Estimate should be the problem of the log, and try again:
sql> Recover database using Backup controlfile until cancel;
Ora-00279:change 669109 generated at 09/12/2009 18:47:00 for thread 1
Ora-00289:suggestion:
/u01/app/oracle/flash_recovery_area/orcl/archivelog/2009_09_13/o1_mf_1_10_%u_.ar
C
Ora-00280:change 669109 for thread 1 was in sequence #10


Specify log: {=suggested | AUTO | CANCEL}

Note the ' Change 669109 ' and ' sequence #10 ' according to the contents of the above hints
See a statement from the Internet, you can find redo logs, note to use SYS:
Sql> Conn Sys/oracle as Sysdba
Connected.
Sql> Select v1.group#, member, sequence#, first_change#
2 from V$log v1, V$logfile v2
3 where v1.group# = v2.group#;

Found the log file name to use from the results according to sequence# and first_change#:
/u01/app/oracle/oradata/orcl/redo03.log

In Specify log: {=suggested | AUTO | CANCEL} Enter the following:
/u01/app/oracle/oradata/orcl/redo03.log
Tips:
Log applied.
Media recovery complete.

Then:
sql> ALTER DATABASE open resetlogs;

Database altered.

In this way, the problem is solved.