alter system set "_allow_resetlogs_corruption"=truescope=spfile;
_corrupted_rollback_segments=(_SYSSMU1$,_SYSSMU2$,_SYSSMU3$,_SYSSMU4$,_SYSSMU5$,_SYSSMU6$,_SYSSMU7$,_SYSSMU8$,
_SYSSMU9$,_SYSSMU10$,_SYSSMU11$,_SYSSMU12$)
select name,ts#,status$ from undo$;
select file#,type# fromseg$ where ts#=6;
delete from seg$ where ts#=6;
commit;
_allow_read_only_corruption
_allow_resetlogs_corruption
_allow_terminal_recovery_corruption
_corrupted_rollback_segments
_log_buffers_corrupt
_allow_error_simulation
_allow_read_only_corruption
_allow_resetlogs_corruption
_allow_terminal_recovery_corruption
_gs_anti_semi_join_allowed
_tts_allow_nchar_mismatch
_discrete_transactions_enabled
_DISABLE_LOGGING
--查看参数的值
set linesize 132
column name format a42
column value format a12
select
x.ksppinmname,
y.ksppstvlvalue,
y.ksppstdfisdefault,
decode(bitand(y.ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE')ismod,
decode(bitand(y.ksppstvf,2),2,'TRUE','FALSE')isadj
from
sys.x_$ksppi x,
sys.x$ksppcv y
where
x.inst_id = userenv('Instance') and
y.inst_id = userenv('Instance') and
x.indx = y.indx and x.ksppinm like '%transa%'
order by
translate(x.ksppinm, ' _', ' ')
/
OPEN下
alter session set events 'IMMEDIATE trace name ADJUST_SCN level 1';
mount下
alter session set events '10015 trace name adjust_scn level 1';
如果SCN相差比较多,可以设置level 2,。。。level 10等
(level 1是每次打开时将将scn推进1百万) |