Oracle Database Discussions

Hi,

I am running oracle 10.2.0.1.

The database crash hard. And I can't save it. But I have a old fun backup. So here are the step I told to get my database.

1. RMAN> list backup of controlfile;

- Note absolute path to the backup piece -
- Note SCN from your old controlfile backup -

2. SQL>Shutdown immediate;

3. RMAN> startup force nomount;

4. RMAN> restore controlfile from '/path/to/old_backup_piece.bkp';

5. RMAN> alter database mount;

6. RMAN> run {
set until scn <noted SCN#>;
restore database force;
recover database noredo;
alter database open resetlogs;
}

I restore database fine and then it saying

Starting recover at 13-Nov-08
using channel ORA_DISK_1
Finished recover at 13-Nov-08

RMAN-00571: ===================================================
RMAN-00569: =========== Error Message stack follows ======================
RMAN-00571: ===================================================
RMAN-03003: failure of alter db command at 11/13/2008 11:00:00
ORA-01153: an incompatible media recovery is active

Is this mean that my alter database open resetlogs is not working?

How to resolved this? Please help.

Thank you,