pando, this is your response for "lost all control file, all redo logs"
=========================
1. shutdown the database
2. Recover latest backup
3. startup nomount
4. create control file
5. recover database until cancel using backup controlfile;
this will recover using the archived logs until you stop it
6. alter database open resetlogs;

database should open successfully

You dont need to drop/recreate redo logs sicne resetlogs will create the log groups
==========================

could you please give some idea why need step 4, "recreate controlfile", since there is a backup controlfile and "resetlogs" will resync controlfile there is no need to recreate it. In face, I tried, without step 4, db can be openned but will complain password file, why?


thanks in advance

Jim