Oracle SQL: the Essential Reference

CREATE CONTROLFILE

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

Recreates a control file, allowing changes to some parameters.

Keywords

REUSE

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

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 command, this must be the current name of the database.

LOGFILE

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

RESETLOGS

Specifies that the contents of the log files listed in the LOGFILE clause should 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) should 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. This value ...