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

Thread: datafile recovery

  1. #1
    Join Date
    Nov 2000
    Posts
    14

    Exclamation

    i have a user datafile of size 145mb in personal oracle. i have changed my system and loaded personal oracle once again.
    now from my backup drive i want to add this datafile to the new database. how can i do this??
    how to change the controlfile to have an entry for the new datafile??


  2. #2
    Join Date
    Sep 2000
    Posts
    128
    It doesn't quite work like that unfortunately...

    What you'll need to do is either restore the whole database from your backup copy.

    or

    Export the tables who's data is in the datafile, import into your new database.

  3. #3
    Join Date
    Nov 2000
    Posts
    14
    thanx for answering, i want ask can i copy even my system tablespace datafiles because they will have an entry in my controlfile??

    [QUOTE][i]Originally posted by TerryD [/i]
    [B]It doesn't quite work like that unfortunately...

    What you'll need to do is either restore the whole database from your backup copy.

    or

    Export the tables who's data is in the datafile, import into your new database. [/B][/QUOTE]

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you need to restore everything from your old database, not just one or two or even more but imcomplete number of files

  5. #5
    Join Date
    Nov 2000
    Posts
    9

    If u're using oracle 8i personal edition, it can be done via export
    with transportable tablespace option, then copy the datafile to ur
    source database and then import it dump file into the database.
    while importing, it wil make an entry into the data dictionary.
    This works fine, only if the former database has the same
    configuration of the later database.
    (OCP)

  6. #6
    Join Date
    Jun 2000
    Posts
    104
    HELLO,
    AS PANDO SAID U NEED TO RESTORE ALL SYSTEM DATAFILES,USER,TEMP,RBS ,INDX I.E,ALL DATAFILES
    WHICH IS IN DATABASE FOLDER IN ORACLE HOME.
    THEN YOUR CONTROLFILES OF THAT TIME,REDOLOGFILES ALL HAS TO BE RESTORED ALSO.TRY IT AND SEE.

  7. #7
    Join Date
    Nov 2000
    Posts
    14

    thanx all of u!!!!!

    thanx for datafile recovery solution....my database has been restored completely.
    this is the first time i have accessed such a forum and ur responses were overwhelming.
    thanx again.

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