数据库库数据文件个数超过200添加新的数据文件时报ora-59

最新推荐文章于 2024-07-30 08:30:00 发布

wangwei

最新推荐文章于 2024-07-30 08:30:00 发布

阅读量1.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle

本文链接：https://blog.youkuaiyun.com/weiwangsisoftstone/article/details/39895829

oracle 专栏收录该内容

150 篇文章

订阅专栏

本文介绍了解决Oracle数据库中ORA-00059错误的方法，该错误通常发生在达到最大数据文件限制时。文章提供了详细的步骤来增加数据文件的数量限制。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

In this Document
Symptoms
Cause
Solution

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.2.0.2 and later
Information in this document applies to any platform.
SYMPTOMS

ERROR
------------------------------
ORA-00059: maximum number of DB_FILES exceeded

STEPS
------------------------------
While trying to add a datafile

CAUSE

Maximum number of datafiles specified via parameter db_files has been reached

Limits set by DB_FILES parameter

SOLUTION

You do not have to recreate the CONTROL FILE from 10g onwards to change/modify MAXLOGFILE, MAXLOGMEMBERS,MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES

For MAXDATAFILES, follow the steps below:

1] Determine the value of db_files

SQL> show parameter db_files

2] Check the number of Datafiles
SQL> select count(*) from dba_data_files;

4] Set the db_files parameter to a new high value
SQL> alter system set db_files=x scope=spfile;

4] Shutdown the database with immediate option and restart so that the new value for db_files can be read.
SQL> shutdown immediate
SQL> startup

5] Check the new value for db_files parameter
SQL> show parameter db_files

6] Now add the datafile and this time, the error ORA-00059 will not occur
SQL> alter tablespace <tablespace_name> add datafile '<Datafile_location>' size <size>;