Starting a database – Oracle A423961 User Manual

Page 68

Advertising
background image

SQL Ref.

3 – 10

Oracle7 Server Getting Started for Windows NT

Parameter

Description

LOGFILE filespec

Specify the redo log filenames to be created and maintained. If you omit this
parameter, Oracle7 creates two log files (the minimum):

LOG1

sid.ORA

and

LOG2

sid.ORA

. The default size of each log file is 50K; there is no maximum

size.

MAXLOGFILES integer

Maximum number of redo log files the database will create (2 MAXLOGFILES
are created by default). The default value is 32; the range is 2 to 255 log files.

MAXLOGMEMBERS integer

Maximum number of copies for a redo log file group. Set this parameter if
you plan to use multiplexed redo log files as discussed in the Oracle7 Server
Administrator’s Guide
. The default value is 2; the range is 2 to 5 log file copies.

MAXLOGHISTORY integer

This parameter is not used with Oracle7 Server for Windows NT.

DATAFILE filespec

Specify one or more database files to be created and maintained. The default
database files (

DBS1sid.ORA

) of 6MB, are stored in \ORANT\DATABASE.

filespec

fi

lespec defines the name, size, and location of redo log files and database files

using the syntax

’d:\path\filename’ [SIZE integer [K|M]]

where d :\path\filename specifies the complete drive, path, and filename for
the file. (Always enclose the path and filename in single quotation marks.)
The SIZE parameter operates as described in the Oracle7 Server SQL Reference.

MAXDATAFILES integer

Specify the maximum number of data files that the database can create (1
MAXDATAFILE is created by default). The default value is 32; the range is 1
to 254 files.

MAXINSTANCES integer

This parameter is not relevant with Oracle7 Server for Windows NT.

NOARCHIVELOG

To avoid logging the commands used to create your database, you should
create the database in NOARCHIVELOG mode (the default). If you plan to
operate the database in ARCHIVELOG mode, see the section Enabling Auto-
matic Archiving
in Chapter 4 for instructions on changing this setting.

CHARACTER SET name

The character set Oracle7 Server for Windows NT uses to store data. The de-
fault is WE8ISO8859P1.

Additional Information:

For more detailed information, see

Oracle7 Server SQL Reference.

Starting a Database

Before starting the database, make sure that a database instance has
been created and that the services have been started. (See the section
Creating an Instance with Instance Manager earlier in this chapter.) Then,
use the Database Instance Manager or Server Manager to start the
database.

Advertising