Document Type | Technical Information
Category | Administration
Applicable Product Versions | T6, T7.
Document Number | TADTI163
Overview
This document describes how to modify the archive log information stored in v$archive_log.
Method
By default, if the user does not explicitly specify the MAXARCHIVELOG clause in the DDL when creating the database or control file, it is created with the default value of 500.
<How to Set>
You can create the database by specifying the value of MAXARCHIVELOG in the CREATE DATABASE statement.
MAXARCHIVELOG can be set up to a maximum of 2048.
Example Usage
create database "tibero" user sys identified by tibero maxinstances 8 maxdatafiles 100 character set MSWIN949 national character set UTF16 logfile group 1 '/home/tibero/tibero5/database/tibero/log001.log' size 100M, group 2 '/home/tibero/tibero5/database/tibero/log002.log' size 100M, group 3 '/home/tibero/tibero5/database/tibero/log003.log' size 100M maxloggroups 255 maxlogmembers 8 maxarchivelog 2048 archivelog datafile '/home/tibero/tibero5/database/tibero/system001.dtf' size 100M autoextend on next 100M maxsize unlimited default temporary tablespace TEMP tempfile '/home/tibero/tibero5/database/tiberotemp001.dtf' size 100M autoextend on next 100M maxsize unlimited extent management local autoallocate undo tablespace UNDO datafile '/home/tibero/tibero5/database/tiberodata/undo001.dtf' size 100M autoextend on next 100M maxsize unlimited extent management local autoallocate;