Creating a Controlfile in Oracle: Example

Goal:

Creating a Controlfile: Example This statement re-creates a control file. In this statement, database demo was created with the WE8DEC character set.

Statement:

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "itbl" NORESETLOGS NOARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 32
    MAXINSTANCES 1
    MAXLOGHISTORY 449
LOGFILE
  GROUP 1 '/oracledb/oradata/itbl/t_log1.f'  SIZE 500K,
  GROUP 2 '/oracledb/oradata/itbl/t_log2.f'  SIZE 500K
# STANDBY LOGFILE
DATAFILE
  '/oracledb/oradata/itbl/t_db1.f',
  '/oracledb/oradata/itbl/dbu19i.dbf',
  '/oracledb/oradata/itbl/tbs_11.f',
  '/oracledb/oradata/itbl/smundo.dbf',
  '/oracledb/oradata/itbl/demo.dbf'
CHARACTER SET WE8DEC
;