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

Thread: missing DBF file

  1. #1
    Join Date
    Oct 2002
    Posts
    109

    missing DBF file

    Hi ,
    I was clonning my DB.
    I did the following steps:
    1.Shutdown the source DB
    2.take the backup of all the DBF files.
    3.alter database backup control file to trace , of Source DB.

    Now While creating the control file I missed one dbf file anyhow.

    Control files are created and destination(clonned)
    startup mount.
    I gave alter database openresetlogs
    DB is up.

    But while working on the clonned DB, got an error , because one of the dbf file is missed.
    By default oracle made a dbf file named like missing1000000, in the respective tablespace.

    Now my problem is :
    How can I take the DBF file which I left?I mean how can i include the reaminning dbf in my clonned DB


    Regards,

    Praveen

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    tricky but if you have all archive logs since that file was created you can try alter database create datafile

  3. #3
    Join Date
    Oct 2002
    Posts
    109
    Quote Originally Posted by pando
    tricky but if you have all archive logs since that file was created you can try alter database create datafile
    Hi ,
    Pando, thanks for yr reply.
    I am having the dbf file in the source DB.
    How can I include that DB file from Source DB to the Clonned DB?
    I have already applied the resetlogs command to all the DBF files in the Clonned DB.
    Is it possible that I copied this file from Source to clonned in the respectice tablespace, and then start the clonned DB in mount stage , and then again issue the cooomand:
    alter database open resetlogs?
    Please do help me.

    regards,

    Praveen

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    is there a reason you cant just start again and re-copy the files and create the control file again

  5. #5
    Join Date
    Oct 2002
    Posts
    109
    Quote Originally Posted by davey23uk
    is there a reason you cant just start again and re-copy the files and create the control file again
    Hi Davey,
    Thanks for yr reply.
    Yes , I cannot shut down and recreate the DB , because I have applied around 5 patches on it and regress testing is going on from last 5 days.I am using this DB for Oracle 11i5.10.2 E-business suite.
    Can be some other work around possible ?

    regards,

    Praveen

  6. #6
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    You can try out the following
    1) Backup the control file to trace (of standby)
    2) shutdown the db and copy the missing datafile to its destination
    3)Open the controlfile trace and you will find that one the datafile name is given as missing100....
    4) Change that name to the name of the datafile you juct copied(with path of course)
    5) Recreate the controlfile (backup the original one first )
    6) mount the database, do recovery (if needed), open the database.

    HTH
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  7. #7
    Join Date
    Oct 2002
    Posts
    109
    Quote Originally Posted by simply_dba
    You can try out the following
    1) Backup the control file to trace (of standby)
    2) shutdown the db and copy the missing datafile to its destination
    3)Open the controlfile trace and you will find that one the datafile name is given as missing100....
    4) Change that name to the name of the datafile you juct copied(with path of course)
    5) Recreate the controlfile (backup the original one first )
    6) mount the database, do recovery (if needed), open the database.

    HTH
    Hi,
    Thanks to all, the above solution works.

    regards,

    praveen

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