Creating Models › Target Servers for Physical Models › Database Property Editors › Oracle Physical Property Editors › Oracle Database Editor › Oracle Database Editor - Logging Tab

Oracle Database Editor - Logging Tab

The following describes the options for the Logging Tab in the Oracle Database Editor dialog:

Redo Log Groups

A list box that contains the log file group names. Log file group names must be unique and must be integers. The log file group name is not mandatory, however, and can have a system-generated number instead.

New

Select the New button to add a new log group ID.

Delete

Select a Redo Log Group from the list box and click Delete to delete that Redo Log Group.

FILE SIZE

REUSE

Redo Log Members

A list box that contains the FileName for the log members. Each log file group can have multiple FileNames, but all FileNames must have the same file size and REUSE characteristics. FileName does not have to be specified, since the default can be in the initialization file.

MAXLOGFILES

The value for this option must be numeric because MAXLOGFILES is an integer.

MAXLOGMEMBERS

The value for this option must be numeric because MAXLOGMEMBERS is an integer.

MAXLOGHISTORY

The value for this option must be numeric because MAXLOGHISTORY is an integer.

Archive Log

The Archive Log option includes these options:

NOARCHIVELOG

ARCHIVELOG

FORCE LOGGING

Note: For more information on these parameters, see your vendor's SQL documentation.