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. ...