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

Thread: too much urgent

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    hi friends

    i m getting an error while restoring datafile that
    file is more recent then control file --- older control file
    pls. help me to sort out this problem as soon as possible
    this is too urgent
    thanks in advance

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    startup nomount

    recreate the controlfile

    recover database using backup controlfile;

    I hope your current redo logs arent lost?

  3. #3
    Join Date
    Sep 2000
    Posts
    305

    hi

    but that control file contain all information
    about my datafiles
    can i create a new control file and add into my database
    i will tell u the exact problem
    actually we forgot the password of nt
    so we install it again
    at that time i was not able to take hot backup
    that's why i acess that mechine from its clients
    and copy al the files
    but when I m going to restore it agian
    after installing oracle
    but it is giving error that i mentioned earlier
    so pls. resolved my problem
    bye



  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    when you say you copy all the files you mean the datafiles of database without shutting it down???
    Do you have any backup of your controlfile at all, if you have then you dont need to recreate one simply copy it to the directory where the controlfiles are then using the command recover database using backup controlfile.

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