CREATE CONTROLFILE

• • Reply

  14 years ago

  by lexian

  Alexis Méndez

  , Puerto Rico

  Joined 14 years ago

  Hi,

  I need to create a control file and this is my statement:

  SHUTDOWN ABORT;
  STARTUP NOMOUNT;
  CREATE CONTROLFILE REUSE DATABASE "OraDB" NORESETLOGS ARCHIVELOG
  MAXINSTANCES 8
  MAXLOGHISTORY 1
  MAXLOGFILES 16
  MAXLOGMEMBERS 3
  MAXDATAFILES 100
  LOGFILE
  GROUP 1 'C:\oracle\OraDB\OraDBdatabasefiles\OraDB\redo01.log' SIZE 51200K,
  GROUP 2 'C:\oracle\OraDB\OraDBdatabasefiles\OraDB\redo02.log' SIZE 51200K,
  GROUP 3 'C:\oracle\OraDB\OraDBdatabasefiles\OraDB\redo03.log' SIZE 51200K
  DATAFILE
  'C:\oracle\OraDB\OraDBdatabasefiles\OraDB\system01.dbf',
  'C:\oracle\OraDB\OraDBdatabasefiles\OraDB\sysaux01.dbf',
  'C:\oracle\OraDB\OraDBdatabasefiles\OraDB\undotbs01.dbf',
  'C:\oracle\OraDB\OraDB_databasefiles\OraDB\users01.dbf'
  CHARACTER SET WE8MSWIN1252
  ;
  SHUTDOWN ABORT;
  STARTUP MOUNT;
  

  Whend I execute the statement said that the control file is created but I can't find the control file no where. This is like that? I have to create the file manually and placed in the directory and then execute the statement? What I have to do or what I'm doing wrong?

  Report abuse
• • Reply

  14 years ago

  by DoctorMahdi

  DoctorMahdi

  , Somalia

  Joined 15 years ago

  Hi lexian

  Your code is nice and full working but the problem may the log files

  either they are corrupted or you are not using the all online available logs of the current version

  to be sure about this try creating other control file from different log files

  but my question is which version are you using because showdown abort will not work on oracle (8)

  Regards

  DoctorMahdi

  Report abuse
• • Reply

  14 years ago

  by lexian

  Alexis Méndez

  , Puerto Rico

  Joined 14 years ago

  Hi,

  Thanks DoctorMahdi, I'm using Oracle 10g Rel 2.

  Report abuse