At a client site with a development Oracle 22.214.171.124/linux DB
power outage and crash - no archivelog mode - no backups - Don't know how this was even running
select file#,substr(name,1,70) name, recover, status, fuzzy, checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time from v$datafile_header;
FILE# NAME REC STATUS FUZ
CHECKPOINT_CHANGE# CHECKPOINT_TIME RESETLOGS_CHANGE# RESETLOGS_TIME
1 /oracle/oradata/orcl/system01.dbf NO ONLINE YES 4663440487 08-MAR-2018 02:57:17 945184 04-APR-2012 12:07:59
2 /oracle/oradata/orcl/sysaux01.dbf YES ONLINE YES 3759618229 21-DEC-2016 22:19:41 945184 04-APR-2012 12:07:59
11 /oracle/oradata/orcl/rmdata01.dbf YES ONLINE YES 3759618229 21-DEC-2016 22:19:41 945184 04-APR-2012 12:07:59
alter database datafile 2 offline drop;
alter database datafile 11 offline drop;
recover database ;
Don't care about sysaux, however, I hope to keep whatever is in datafile 11.
I was hoping to force the DB open even with datafile 11 in a bad state.
Oracle says any hidden parameters will not help due to very old SCNs.
Have you faced this situation and successfully recovered the data?