返回数说广场 #每日打卡#
0
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
分享
评论
热门数说


