DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    May 2001



    I've a big problem

    I use 8i 8.1.5. (unix) (with no archivelog)

    I've do this :

    1.shutdown db
    2. copy all control, datafile, redo files (command : cp -p ....)
    to a backup directory.
    3. restore all control, datafile, redo files (command : cp -p ....)
    from that backup directory to the original directory (=>all my files are overwrited)
    3.startup (but my db is mounted only!)

    but , for a reason i don't know, one of a datafile is different :

    my datafile MI_idx_1.dbf ( = the copy , in fact) has not the same size of the original...

    => my copy (MI_idx_1.dbf ) has overwrited my original MI_idx_1.dbf !!

    => my original MI_idx_1.dbf !! is lost!

    How can I startup correctly my db ??

    ORACLE instance started.
    Total System Global Area 28818832 bytes
    Fixed Size 64912 bytes
    Variable Size 11456512 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 520192 bytes
    Database mounted.
    ORA-01122: database file 8 failed verification check
    ORA-01110: data file 8: '/home2/oracle/oradata/mi/MI_idx_1.dbf'
    ORA-01200: actual file size of 420607 is smaller than correct size of 430592

    I think i have to create a new control file but i don't know how... :((

    What can i do ?

    help... help...

    Thanks a lot , Thanks a lot

  2. #2
    Join Date
    Feb 2002
    Do u have a sample script of Creating Control File? Do u know the database name? Take the sample script, substitute the database name in the script with the name of your database, Substitute/Add the name of all the files e.g. redo log files, datafiles, in the script so as to match with the ones you have, except the one which is creating the problem. (dont give that one. This file u have already lost). Now rebuild the control file. Resetlogs while opening the database.
    Hope this may solve some of ur problem.

  3. #3
    Join Date
    May 2001
    I've tried this... except ' open with resetlogs' (because it seems it doesn't change anything ) )

    I've create the script of new control file (without the line where the bad tbsp name was)

    so, when I open my db )) (aaahhhh) I've drop +recreate the bad tbsp + import

    thanks for your help )

    have a nice day

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.