Results 1 to 8 of 8

Thread: database

  1. #1
    Join Date
    Jun 2003
    Posts
    294

    Lightbulb Unanswered: database

    Hello there !!
    I'm getting this error, when I trie to re start my database, and I have no backups, do you know how do I start it ???

    SQL> startup force
    ORACLE instance started.

    Total System Global Area 437020248 bytes
    Fixed Size 280152 bytes
    Variable Size 285212672 bytes
    Database Buffers 150994944 bytes
    Redo Buffers 532480 bytes
    Database mounted.
    ORA-01122: database file 1 failed verification check
    ORA-01110: data file 1: '/opt/oracle/ora9iASInfra/oradata/iasdb/system01.dbf'
    ORA-01207: file is more recent than controlfile - old controlfile

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    did you do an improper shutdown?
    shutdown abort or something?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    do you have mirrored controlfiles?
    if so, check the dates on these files to determine if any match the date of the SYSTEM datafile.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Jun 2003
    Posts
    294
    shutdown abort

  5. #5
    Join Date
    Jun 2003
    Posts
    294
    But I don't really know what ig going on, and I don't care if I loose all the information, what I wanna have, is the original database

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >what I wanna have, is the original database
    So restore from your most current backup.
    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.

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    if you don't care then just drop the database and recreate
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  8. #8
    Join Date
    Jun 2003
    Posts
    294
    Thanks !!!!

Posting Permissions

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