Shulou(Shulou.com)06/01 Report--

[preface] the default parameters for Oracle database creation are generally enough for most databases, but in some cases there are write parameters that need to be changed.

[problem background] the company has an Oracle database warehouse with a database size of 5TB, but the whole space is almost full. An error in ORA-59 was reported while adding tablespaces.

[problem Analysis]

1. Error analysis

1, alert log display control file Expanded operation Expanded controlfile section 4 from 10 to 40 records Requested to grow by 30 records; added 1 blocks of records 2, alter database backup controlfile to trace resetlogs; view the parameters of the control file STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "WZQ" RESETLOGS NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 40 MAXINSTANCES 8 MAXLOGHISTORY 292 shows that the MAXDATAFILES file has been modified to 40.

[summary] A simple tablespace problem has been figured out after testing and verification.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.