CREATE CONTROLFILE

oracle Puerto Rico
  • 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?

  • 14 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

  • 14 years ago

    Hi,

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

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Debuggers don't remove bugs. They only show them in slow motion.”