URGENT ! my restore procedure doesn't work
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: URGENT ! my restore procedure doesn't work

  1. #1
    Join Date
    May 2001
    Posts
    22

    Unhappy


    Hi,

    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.
    roblem
    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
    blocks

    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
    Location
    http://db-migration.co.in
    Posts
    50
    Hi,
    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
    Posts
    22
    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