ORA-10646: Too many recursive extensions during SYSTEM tablespace migration ORACLE 报错 故障修复 远程处理

文档解释

ORA-10646: Too many recursive extensions during SYSTEM tablespace migration

Cause: When SYSTEM tablespace is being migrated, dictionary tables tried to extend recursively more than 1000 times.

Action: If SYSTEM tablespace is very large, then simply reissue the tablespace migration command.

？

ORA-10646是ORACLE数据库错误代码。它表明在系统表空间迁移期间，递归扩展了太多的次数。

官方解释

常见案例

正常处理方法及步骤

1. 增加系统在表空间迁移时可以处理的最大递归扩展次数：

ALTER SYSTEM SET Max_recursive_extents=4096;

2. 增加表空间小块厚度：

ALTER DATABASE DATAFILE ‘/tmp1/system01.dbf’ RESIZE 128M;

3. 检查表空间的可用空间，如果可用空间足够的话，可以把表空间重新换算一下：

ALTER TABLESPACE SYSTEM RESIZE 32768M;

4. 针对报错语句，添加reuse模式：

ALTER TABLESPACE SYSTEM ADD DATAFILE ”REUSE size M;

5. 重启数据库：

SHUTDOWN IMMEDIATE;

STARTUP;