2022-01-15T17:37:25.255+08:00 org_id=oracle comp_id=rdbms
type=UNKNOWN level=16 host_id=localhost.localdomain
host_addr=::1 pid=53213>
ORACLE Instance xxxxx (pid = 25) - Error 607 encountered while recovering transaction (37, 8) on object 5341044.


2022-01-15T17:37:25.255+08:00 org_id=oracle comp_id=rdbms
type=UNKNOWN level=16 host_id=localhost.localdomain
host_addr=::1 pid=53213>
Errors in file /u01/app/oracle/diag/rdbms/xxxxx/xxxxx/trace/xxxxx_smon_53213.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [6856], [0], [0], [], [], [], [], [], [], [], [], []


……
2022-01-15T17:37:34.483+08:00 org_id=oracle comp_id=rdbms
type=UNKNOWN level=16 host_id=localhost.localdomain
host_addr=::1 pid=53165>
Instance Critical Process (pid: 25, ospid: 53213, SMON) died unexpectedly


2022-01-15T17:37:34.526+08:00 org_id=oracle comp_id=rdbms
type=UNKNOWN level=16 host_id=localhost.localdomain
host_addr=::1 pid=53165>
PMON (ospid: 53165): terminating the instance due to error 474


……

ORA-600 [6006] ORA-600 [6856] During Startup Instance, Followed by Termination by SMON (Doc ID 549000.1)

create pfile=’/tmp/pfile01.ora’ from spfile;
echo *.event="10513 trace name context forever, level 2" >> /tmp/pfile01.ora

startup pfile=’/tmp/pfile01.ora’;
select object_id, data_object_id, owner, object_name from 
dba_objects where object_id = 5341044 or data_object_id=5341044 ;

drop table xxxxx;
purge dba_recyclebin;

#關閉數據庫
shutdown immediate;
pfile01.ora文件中去掉10513 event

# 起動數據庫
startup pfile=’/tmp/pfile01.ora’;

# 檢查數據庫
select open_mode from v$database;
select * from v$recover_file;

#切換日志，查看預警日志中是否有報錯信息
alter system switch logfile;

#重建刪除的對象