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  




Back to the Top

Simon Sheppard
SS64.com