Document Type | Technical Information
Category | Administration
Applicable Product Versions | 6FS06, 6FS07, 7PS02, 7PS03, 7PS04, 7PS05
Document Number | TADTI240
Overview
This document describes how to modify the maximum number of data files that can be used in the database.
Method
1. Check Current Settings
Check the current number of created data files and the setting for the maximum number of data files that can be created.
SQL> select record_used,record_max from _vt_controlfile_record_section where name='data file';
RECORD_USED RECORD_MAX
----------- ----------
4 10240 Note
The default value of MAXDATAFILES is 100, the minimum is 10, and the maximum is 65,533.
2. Backup the Control File
SQL> alter database backup controlfile to trace as '/home/tibero7/ctl_bak.sql';
3. Edit the Control File
Check whether the resetlogs mode in the backed-up control file is noresetlogs, then modify it accordingly.
-- MAXDATAFILES [Specify the desired number] MAXDATAFILES 40960
4. Recreate the Control File
Use the modified control file to recreate it in nomount mode.
$ tbdown immediate $ tbboot nomount $ tbsql sys/tibero SQL> @ctl_bak.sql $ tbdown immediate
5. Perform Media Recovery
Start the database in mount mode and perform media recovery.
$ tbboot mount $ tbsql sys/tibero SQL> alter database recover automatic database; $ tbdown immediate
6. Normal Startup and Verification
$ tbboot
$ tbsql sys/tibero
-- Manually execute the commented section at the end of the backed-up control file
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/home/tibero7/tbdata/temp001'
SIZE 512M REUSE AUTOEXTEND ON NEXT 8M MAXSIZE 32G;
SQL> select record_used,record_max from _vt_controlfile_record_section where name='data file';
RECORD_USED RECORD_MAX
----------- ----------
4 40960