【Oracle问题处理】minact-scn: useg scan erroring out with error e:12751

minact-scn: useg scan erroring out with error e:12751

Oracle11.2.0.4表空间新增数据文件：

SYS@>alter tablespace TS_DATA_MDMDATA add datafile '/u01/oradata/mdmdata/data_mdmdata02.dbf' size 10G autoextend on;

新增数据文件，alter日志报错minact-scn: useg scan erroring out with error e:12751

redolog信息：

SYS@>select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_RECOVE
---------- --------------- --------------------- ------------------------------------------------------------ ---------
1 ONLINE /u01/oradata/mdmdata/redo01a.log NO
2 ONLINE /u01/oradata/mdmdata/redo02a.log NO
3 ONLINE /u01/oradata/mdmdata/redo03a.log NO
3 ONLINE /u01/oradata/mdmdata/redo03b.log NO
1 ONLINE /u01/oradata/mdmdata/redo01b.log NO
2 ONLINE /u01/oradata/mdmdata/redo02b.log NO
7 rows selected.

SYS@>select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --------- --------------- ------------- ------------------- ------------ -------------------
1 1 4734 536870912 512 2 NO CURRENT 120327820 2022/04/28 11:03:11 2.8147E+14
2 1 4733 536870912 512 2 YES INACTIVE 120257243 2022/04/27 23:44:16 120327820 2022/04/28 11:03:11
3 1 4732 536870912 512 2 YES INACTIVE 120257234 2022/04/27 23:44:16 120257243 2022/04/27 23:44:16

 redo log：512MB ，3组2成员

DBWR 进程个数：

SYS@>show parameter db_write

NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
db_writer_processes integer 1

增加DBWR 

SYS@>ALTER SYSTEM SET db_writer_processes=8 SCOPE=SPFILE;

需重启实例生效。

https://blog.csdn.net/weixin_39801991/article/details/116419533