scn不一致oracle恢复,因为人工误操作导致resetlogs scn不一致恢复

有个朋友,数据库损坏有一段时间,前期找过我们,对其进行分析,判断强制打开库应该就可以了;后来不知道什么原因有几批人进行了恢复,把现场完全破坏,检查数据库发现,数据库文件有部分resetlogs scn不一致

通过工具(Oracle恢复小工具—Oracle Recovery Tools)对文件相关值进行修改,并尝试打开库

SQL> recover database until cancel;

ORA-00279: change 15764982275935 generated at 11/06/2020 00:27:23 needed for thread 1

ORA-00289: suggestion : /jiaoh/oradata/orcl/archlog/arch_1_5_995131008.log

ORA-00280: change 15764982275935 for thread 1 is in sequence #5

Specify log: {=suggested | filename | AUTO | CANCEL}

cancel

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 3 needs more recovery to be consistent

ORA-01110: data file 3: '/u01/oracle/oradata/orcl/undotbs01.dbf'

ORA-01112: media recovery not started

SQL> alter database open resetlogs;

Database altered.

数据库alert日志报ORA-600 4097错误

un Nov 08 12:17:06 2020

Errors in file /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_j006_135739.trc (incident=2604819):

ORA-00600: internal error code, arguments: [4097], [31], [2], [338312], [], [], [], [], [], [], [], []

Incident details in: /u01/oracle/diag/rdbms/orcl/orcl/incident/incdir_2604819/orcl_j006_135739_i2604819.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

对undo进行处理,数据库后台无明显报错,建议客户逻辑导出数据导入新库,恢复完成.