EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

Defining additional settings


Use this step to define additional database settings.

 

Note: This step is skipped if the RadioButton Standby database template is specified at the Specifying memory parameters step of the wizard.

 

Create Database Wizard - Defining additional settings

 

Archive

RadioButton Noarchivelog mode

If this mode is used, the contents of a redo log file group is not archived before the group can be reused. This mode does not allow the possibility of media recovery, i.e. the database can be completely recovered after an instance failure, but not after a disk failure. Also, the database can be backed up only while it is completely closed.

 

RadioButton Archivelog mode

If this mode is used, the contents of a redo log file group is archived before the group can be reused. This mode prepares for the possibility of media recovery, i.e. the database can be completely recovered after both an instance failure and a disk failure. Also, the database can be backed up while it is open and available for use.

 

If the Archivelog mode is specified, you also need to define archivelog filename format size, archivelog destination using the corresponding controls, or use the default values.

Note: The specified paths and file names must comply with specifications of the operating system selected at the first step of the wizard.

 

Character set

Use the drop-down list to specify the character set the database will use to store data. The supported character sets depend on your operating system.

 

National character set

Use the drop-down list to specify the national character set to be used to store data in columns specifically defined as NCHAR, NCLOB, or NVARCHAR2.

 

You also need to define log buffer size, CPU count using the corresponding controls, or use the default values.

 

Click the Next button to proceed to the Defining special directories and filenames step of the wizard.