Oracle A423961 Manual Do Utilizador
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):
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.
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.
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 (
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.
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.
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.
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.
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.
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.