DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Create Controlfile fails

  1. #1
    Join Date
    Feb 2002
    Posts
    41
    Executing the following sql:

    CREATE CONTROLFILE REUSE DATABASE "ORACLE" NORESETLOGS NOARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 5
    MAXDATAFILES 600
    MAXINSTANCES 10
    MAXLOGHISTORY 1000
    LOGFILE
    '/u01/app/oracle/oradata/oracle/redo01.log',
    '/u01/app/oracle/oradata/oracle/redo02.log',
    '/u01/app/oracle/oradata/oracle/redo03.log'
    DATAFILE
    '/u01/app/oracle/oradata/oracle/tools01.dbf',
    '/u01/app/oracle/oradata/oracle/drsys01.dbf',
    '/u01/app/oracle/oradata/oracle/users01.dbf',
    '/u01/app/oracle/oradata/oracle/indx01.dbf',
    '/u01/app/oracle/oradata/oracle/rbs01.dbf',
    '/u01/app/oracle/oradata/oracle/temp01.dbf',
    '/u01/app/oracle/oradata/oracle/system01.dbf'
    ;

    Results in the following error:

    ORA-01503: CREATE CONTROLFILE failed
    ORA-01160: file is not a data file
    ORA-01110: data file : '/u01/app/oracle/oradata/oracle/drsys01.dbf'

    Does this mean that the dbf is corrupted? ie: Is the database toasted????

    Thanks

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Was it a raw disk backup, on such cases you have to skip the raw device's header bytes. You might want to use dd. It also could be a reason that your DB_BLOCK had been set low. Remember that your DB_BLOCK should be the same as the imported DB.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Feb 2002
    Posts
    41
    Sam,
    Actually, there are no backups involved. Yestedray Network admins' had to shut down the server, I was not here when they did, but when I got back oracle server was down. They told me they had not been able to do a normal shutdown nor a startup. The error by then was the following:

    SVRMGR> startup
    ORACLE instance started.
    Total System Global Area 72708256 bytes
    Fixed Size 73888 bytes
    Variable Size 55685120 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 172032 bytes
    ORA-00201: controlfile version incompatible with ORACLE version
    ORA-00202: controlfile: '/u01/app/oracle/oradata/oracle/control01.ctl'

    Hence I decided to drop the control files and recreate them using the sql script posted on my first thread, but now I'm getting the datafile error. Fortunately is just a test database, and therefore I have no backup at all. I was just trying to see trough it but not the easy way.... So if you happen to have any advice please drop it here !

    Thanks and Regards.

Posting Permissions

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


Click Here to Expand Forum to Full Width