my database is not opening
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: my database is not opening

  1. #1
    Join Date
    Aug 2006
    Posts
    6

    my database is not opening

    hi all

    i dont have any backup how i can open my database


    thanks in advance

    nawaz

    -------------here is story----------

    SVRMGR> startup mount
    ORACLE instance started.
    Total System Global Area 84121628 bytes
    Fixed Size 75804 bytes
    Variable Size 57024512 bytes
    Database Buffers 26943488 bytes
    Redo Buffers 77824 bytes
    Database mounted.
    SVRMGR> alter database open
    2> ;
    alter database open
    *
    ORA-01122: database file 8 failed verification check
    ORA-01110: data file 8: 'D:\DATA\MAINMTR01.DBF'
    ORA-01207: file is more recent than controlfile - old controlfile

  2. #2
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    you can try...
    sql> startup mount
    sql> recover database
    Behind The Success And Failure Of A Man Is A Woman

  3. #3
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Did you restore your controlfile?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by yxez
    you can try...
    sql> startup mount
    sql> recover database
    that wont help

  5. #5
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Hi,

    svrmgrl> startup mount;
    svrmgrl> alter database backup controlfile to trace;

    ----Check udump location---- for latest Trace which has the script of your current controlfile.

    Remove the entry 'D:\DATA\MAINMTR01.DBF'.

    svrmgrl> shutdown immediate
    svrmgrl> startup nomount
    svrmgrl> (Backup your old controlfile before your fire this)
    svrmgrl> alter database open;

    Your will lose all the data in 'D:\DATA\MAINMTR01.DBF'.


    Else apply archives, if you have ARCHIVELOG mode On.

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