|
|
CREATE CONTROLFILE
Create a control file.
Syntax:
CREATE CONTROLFILE [REUSE] [SET] DATABASE database LOGFILE [GROUP int] filespec [RESETLOGS | NORESETLOGS] DATAFILE filespec options options MAXDATAFILES int MAXLOGFILES int MAXLOGMEMBERS int MAXLOGHISTORY int MAXINSTANCES int ARCHIVELOG | NOARCHIVELOG
Several LOGFILE or DATAFILEs can be specified at once if
separated with commas.
Related Commands:
ALTER SYSTEM BACKUP CONTROLFILE TO TRACE
Related Views:
GLOBAL_NAME DBA_DATA_FILES V$CONTROLFILE V$DATABASE V$DATAFILE V$LOG V$LOGFILE