Skip to main content

Search

Welcome to Tibero GTS!

How to Modify the MAX DATAFILE Count

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

 

 

 

Related to