Oracle CORRUPTING DATABASE OPEN FAILS WITH ORA-704, ORA-376 AND ORA-1092

full database restore from hot backup taken 03-SEPT.

There has never been a backup of the undo tablespace so
it was not restored. We updated the init.ora parameters
to offline and corrupt the rollback segments and to allow
corruption at resetlogs. After restore before recover the
undo datafile (3) files 2, 103, and 103 were offline dropped.
The recovery was started on the remaining datafiles, recovery
from log sequence# 2559 and cancel after applying 2576.
This recovers the database to 09-SEPT. The undo datafile
number 2 is still failing validation even after offline
drop and _offline and _corrupt for all undo listed in the
alert.log since before the database backup.
 
DIAGNOSTIC ANALYSIS:
--------------------
init.ora parameters changed or added:
 
 undo_management = manual
 _corrupted_rollback_segments = (_SYSSMU1$, thru _SYSSMU11$)
 _offline_rollback_segments = (_SYSSMU1$, thru _SYSSMU11$)
 _allow_resetlogs_corruption = true
 max_dump_file_size=unlimited
 event = "10013 trace name context forever, level 10"
 event = "376 trace name errorstack level 3"
 
 create the controlfile to mount
    
 sql trace your recovery session
    
 SQL> ALTER SESSION SET EVENTS '10046 trace name context forever, level 12';
 SQL> alter database datafile  
'/oracle/index03/oradata/medprod/undo_dat_01.dbf'
      offline drop;
 SQL> alter database datafile  
'/oracle/data04/oradata/medprod/undo_dat_02.dbf'
      offline drop;
 SQL> alter database datafile  
'/oracle/data01/oradata/medprod/undo_dat_02.dbf'
      offline drop;
 SQL> recover database until cancel using backup controlfile;
      cancel after 2576 is applied
 SQL> alter database open resetlogs;
 
Executed 10046 trace level 12 with event 376 set:
 
medprod_ora_52745.trc:

ksedmp: internal or fatal error
ORA-376: file 2 cannot be read at this time
ORA-1110: data file 2: '/oracle/index03/oradata/medprod/undo_dat_01.dbf'
Current SQL statement for this session:
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, 
spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner 
is null and linkname is null and subname is null
 

Oracle DUL (data unloader) may help this case :

Refer  http://parnassusdata.com/en/emergency-services  for more info.

If you cannot recover the data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help.

Parnassusdata Software Database Recovery Team

Service Hotline:  +86 13764045638

E-mail: service@parnassusdata.com