Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Name

CREATE CONTROLFILE

Synopsis

CREATE CONTROLFILE [REUSE] [SET] DATABASE dbname
LOGFILE [GROUP integer] filename[,[GROUP integer] filename ...] 
{RESETLOGS | NORESETLOGS}
[MAXLOGFILES integer]
[MAXLOGMEMBERS integer]
[MAXLOGHISTORY integer]
[MAXDATAFILES integer]
[MAXINSTANCES integer]
[ARCHIVELOG | NOARCHIVELOG]
DATAFILE (filename[,filename ...]) 
CHARACTER SET character_set

Re-creates a control file, allowing changes to some parameters.

Keywords

REUSE

Specifies that one or more existing control files specified in the initialization file can be reused and overwritten. If this keyword is omitted and if any of the control files named in INIT.ORA or SPFILE exists, an error results.

SET

Specifies that the supplied dbname will be a new name for the database. Valid names are one to eight characters long.

DATABASE

Specifies the name of the database. Unless you use the SET statement, this must be the current name of the database.

LOGFILE

Specifies members of all redo log file groups, all of which must exist.

RESETLOGS

Specifies that the contents of the log files listed in the LOGFILE clause be ignored. Each file listed in the LOGFILE clause must have a SIZE specified.

NORESETLOGS

Specifies that all files listed in the LOGFILE clause (which must be current redo log files and not restored from backups) be reused with their original sizes.

MAXLOGFILES

Specifies the maximum number of redo log file groups that can ever be created for the database. The default and maximum values are operating system dependent. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page