Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Unhappy Unanswered: HELP to create a controlfile-AIX5.1/Oracle8.1

    I am doing cold copy from one database to the other. Have created control file from the source and copied all the datasfiles and undo files to new target place. Checked initfile for block size etc to make sure both databases have same. Could bring up database ( new ) in nomount mode. When try to run the sql script as below it generates error

    SQL> connect / as sysdba;
    Connected to an idle instance.
    SQL> startup nomount
    ORACLE instance started.

    Total System Global Area 1038012308 bytes
    Fixed Size 73620 bytes
    Variable Size 407736320 bytes
    Database Buffers 629145600 bytes
    Redo Buffers 1056768 bytes
    SQL> @a
    CREATE CONTROLFILE SET DATABASE "MMTRAIN" RESETLOGS ARCHIVELOG
    *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-00600: internal error code, arguments: [17585], [33554444], [538009492],
    [], [], [], [], []
    ORA-00600: internal error code, arguments: [17585], [33554444], [538009492],
    [], [], [], [], []


    SQL>

    The script cftrain.sql is as below. What can I do to fix this?
    CREATE CONTROLFILE SET DATABASE "MMTRAIN" RESETLOGS ARCHIVELOG

    MAXLOGFILES 20

    MAXLOGMEMBERS 4

    MAXDATAFILES 512

    MAXINSTANCES 1

    MAXLOGHISTORY 453

    LOGFILE

    GROUP 1 (

    '/ora01/mmtrain/log/redo1a.rdo',

    '/ora02/mmtrain/log/redo1b.rdo'

    ) SIZE 100M,

    GROUP 2 (

    '/ora03/mmtrain/log/redo2a.rdo',

    '/ora04/mmtrain/log/redo2b.rdo'

    ) SIZE 100M,

    GROUP 3 (

    '/ora02/mmtrain/log/redo3a.rdo',

    '/ora01/mmtrain/log/redo3b.rdo'

    ) SIZE 100M,

    GROUP 4 (

    '/ora04/mmtrain/log/redo4a.rdo',

    '/ora03/mmtrain/log/redo4b.rdo'

    ) SIZE 100M



    DATAFILE

    '/ora00/mmtrain/system01.dbf',

    '/ora_undo00/mmtrain/rollback01_01.dbf',

    '/ora_undo00/mmtrain/rollback01_02.dbf',

    '/ora01/mmtrain/medslg01.dbf',

    '/ora02/mmtrain/medslg02.dbf',

    '/ora03/mmtrain/medslg_indx01.dbf',

    '/ora04/mmtrain/medslg_indx02.dbf',

    '/ora00/mmtrain/medssm01.dbf',

    '/ora04/mmtrain/medssm_indx01.dbf',

    '/ora02/mmtrain/fdb01.dbf',

    '/ora03/mmtrain/fdb_indx01.dbf',

    '/ora04/mmtrain/tools_01.dbf',

    '/ora00/mmtrain/users_01.dbf',

    '/ora01/mmtrain/logmnr_01.dbf',

    '/ora01/mmtrain/medslg03.dbf',

    '/ora03/mmtrain/medslg_indx03.dbf'

    CHARACTER SET WE8ISO8859P1

    ;

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Metalink Note:138621.1

    How is it that you did not find this yourself?
    Last edited by anacedent; 10-19-07 at 14:59.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •