Hey Jeff

Thanks a lot. It worked. I modified the create controlfile code on trace file with RESETLOGS in it and controlfile ws created successfully.

However the next command 'RECOVER DATABASE' failed as it wanted the option 'USING BACKUP CONTROLFILE' . So I used the same option in following way

'RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE'

But this also didnt work and I got the following error

ORA-00279: change 7174247 generated at 08/12/2002 22:56:36 needed for thread 1
ORA-00289: suggestion : /usr/local/localamol/oradata/archivelog/_20.arc
ORA-00280: change 7174247 for thread 1 is in sequence #20

I did give the file name but it didnt work and again gave the same error with new file name. So Again I shutdown the database completely and just started in normal mode. It asked for the NORESETLOGS or RESETLOGS. And then I opened using RESETLOGS and it worked.

The DB is working fine now. But I would like to know why the problem occurred while RECOVER DATABASE command was used.

Amol