ORA-01139: RESETLOGS option only valid after an incomplete database recovery

Error :

sql statement: alter database open resetlogs
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 05/13/2004 09:18:54
RMAN-11003: failure during parse/execution of SQL statement: alter database open
resetlogs
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

RMAN> exit



SOLUTION

Two solutions for this problem
=======================
1.Restore the old controlfile from rman , mount the database with old controlfile
and run following script.

RMAN> run {
restore database;
recover database noredo;
alter database open resetlogs;
}

2.Do the incomplete recovery using sqlplus

SQL>connect / as sysdba
SQL>recover database until cancel using backup controlfile;

Type 'cancel' here.

Then open the database with resetlogs

SQL>alter database open resetlogs;