CREATE CONTROLFILE [REUSE] [SET] DATABASE database
[logfile_clause] { RESETL0GS | NORESETL0GS } [DATAFILE filespec [, filespec]...]
[{ MAXLOGFILES integer
| MAXLOGMEMBERS integer
| MAXLOGHISTORY integer
| MAXDATAFILES integer
| MAXINSTANCES integer
| { ARCHIVELOG | NOARCHIVELOG }
}
[ MAXLOGFILES integer
| MAXLOGMEMBERS integer
| MAXLOGHISTORY integer
| MAXDATAFILES integer
| MAXINSTANCES integer
| { ARCHIVELOG | NOARCHIVELOG }
]...
]
[character_set_clause];For information on the symbols and conventions of Backus-Naur Form (BNF) syntax, see Appendix A.