Recovery

Why i asked u about list of redologs?

Steps:
1. startup database mount;
2. recreate ALL redologs files (groups):

alter database add logfile group X ('...','...') size XXXM;
alter database add logfile group Y ('...','...') size XXXM;
...
or
alter database add logfile member '...' to group X;
alter database add logfile member '...' to group Y;

3. drop ALL old logfiles that u lost:

alter database drop logfile member '...';
alter database drop logfile member '...';
or
alter database drop logfile group X_OLD;
alter database drop logfile group Y_OLD;

4. altrer database open reset logs (as posted Juriy).

Best regards.

Shestakov,

Why steps 1., 2. and 3., when step 4. alone is totaly sufficient?

Because i had this problem a couple years ago, and
alter database open resetlog;
didn't recreate 'in scratch' log files.
I had to recrteate all logs manually.

well that must be a bug because oracle actually mentions in the doc you dont need to backup redologs in cold backups