Oracle Oracle7 Server 7.3, Руководство по началу работы

Страница: 68 / 202

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.