ORA-01122: database file 1001 failed verification check
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: ORA-01122: database file 1001 failed verification check

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    ORA-01122: database file 1001 failed verification check

    Hi Gurus
    Could you please help solve this issue?

    Errors in file /opt/app/oracle/admin/HMPROD/bdump/hmprod_dbw0_28567

    .trc:

    ORA-01186: file 1001 failed verification tests

    ORA-01122: database file 1001 failed verification check

    ORA-01110: data file 1001: '/opt/app/oradata01/HMPROD/dbf/temp_01.dbf

    '

    ORA-01203: wrong incarnation of this file - wrong creation SCN

    Wed Oct 7 16:05:53 2009

    File 1001 not verified due to error ORA-01122

    Wed Oct 7 16:05:53 2009

    Dictionary check complete

    Wed Oct 7 16:05:53 2009

    SMON: enabling tx recovery

    Wed Oct 7 16:05:53 2009

    Cannot re-create tempfile /opt/app/oradata01/HMPROD/dbf/temp_01.dbf,

    the same name file exists

    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Aug 2009
    Posts
    21
    Offline the file 1001 ,open database and Drop and recreate the temp tablespace ,if its is true temporary tablespace just drop the tempfile..

  3. #3
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    thanks will try and advise
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    Did you just clone that database? If so you need to delete the temp files in the database clone before you clone. Otherwise you need to drop and recreate the temp tablespaces after you clone. In my testing of cloning via RMAN, I found that I does not take much more time to just delete all of the datafiles before I do the clone.
    this space intentionally left blank

  5. #5
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Thanks for the advise
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  6. #6
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    are cloning and database transportation the same things?
    lucky

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by mahajanakhil198 View Post
    are cloning and database transportation the same things?
    of course not

  8. #8
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    except that we have to make the source database read only, what are the other differences? In essence, i have not found any.
    lucky

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