SYS@orcl1> alter tablespace TS_IDS add datafile '+DATA' size 200M autoextend on next 200M maxsize unlimited;
alter tablespace TS_IDS add datafile '+DATA' size 200M autoextend on next 200M maxsize unlimited
*
ERROR at line 1:
ORA-00059: ³¬³_FILES µŗֵ
查看日志
Mon Jul 10 09:48:15 2023
alter tablespace TS_IDS add datafile '+DATA' size 200M autoextend on next 100M maxsize unlimited
ORA-59 signalled during: alter tablespace TS_IDS add datafile '+DATA' size 200M autoextend on next 100M maxsize unlimited...
查询发现DB_FILES到了最大值
SYS@orcl1> show parameter DB_FILES
NAME TYPE VALUE
--------------- ---------------------- ------------------------------
db_files integer 200
平时维护的都是相对小的环境,处理办法修改DB_FILES,重启后生效
SYS@orcl1> alter system set db_files=20000 scope=spfile;
环境若为rac环境,则需要按修改参数后对两节点同时重启。
建议在新建时对此参数进行调整。