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.
Comment