暂无图片
返回数说广场
龙镇君
2022-06-21
curren redo损坏一般步骤: 1.----pfile里面增加 _allow_error_simulation=TRUE _allow_resetlogs_corruption=true 尝试alter database open resetlogs; 报错继续 2.重建控制文件 alter database backup controlfile to trace as '/tmp/ctl'; recover database until cancel using backup controlfile; alter database open resetlogs; alter tablespace temp add tempfile '/temp01.dbf' reuse; 3.可能需推进scn 11g:alter session set events '10015 trace name adjust_scn level 10'; 12c以后:event="21307096 trace name context forever, level 3" undo损坏一般步骤: 1.重建UNDO表空间 alter system set undo_tablespace=undotbs2 scope=both; 2.undo_management修改为manual undo_management='MANUAL' undo_tablespace='UNDOTBS2' drop tablespace UNDOTBS1 including contents and datafiles; 3.设置_corrupted_rollback_segments参数
#每日打卡#
0
暂无图片 0
227
分享

评论

热门数说