Problema
BR0280I BRSPACE time stamp: 2015-06-01 11:15:55
BR1088I Extending tablespace PSAPBTABI ...
BR0280I BRSPACE time stamp: 2015-06-01 11:16:34
BR0301E SQL error -59 at location BrSqlExecute-1, SQL statement:
'/* BRSPACE */ alter tablespace PSAPBTABI add datafile '/oracle/TST/sapdata4/btabi_28/btabi.data28' size 5000M autoextend on next 20M maxsize 6000M'
ORA-00059: maximum number of DB_FILES exceeded
BR1017E Execution of SQL statement '/* BRSPACE */ alter tablespace PSAPBTABI add datafile '/oracle/TST/sapdata4/btabi_28/btabi.data28' size 5000M autoextend on next 20M maxsize 6000M' failed
BR0280I BRSPACE time stamp: 2015-06-01 11:16:34
BR0669I Cannot continue due to previous warnings or errors - you can go back and repeat the last action
BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:
Referencia
Solução
You do not need to recreate control file. See below:
SQL> sho user
SYS
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL> sho parameter db_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 200
SQL> alter system set db_files = 512 scope = spfile;
SQL> shutdown immediate
SQL> startup
SQL> sho parameter db_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 512
Postagens
