Results 1 to 13 of 13

Thread: Restoring a database

  1. #1
    Join Date
    May 2003
    Posts
    33

    Restoring a database

    I have a .dbf file. How can i load it and then restore the Schema of the dbase?

  2. #2
    Join Date
    Jun 2003
    Posts
    6
    If this is the only thing that you have, maybe it's impossible to be done.

  3. #3
    Join Date
    May 2003
    Posts
    33
    Why? What type of file is this?

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Is this oracle database file?. To restore a complete oracle database you need a backup of all user and system tablespaces, control file and configuration files.

    You can't simply attach a .dbf file to an instance.

  5. #5
    Join Date
    May 2003
    Posts
    33
    Well, what kind of information may contain that file and how can i use it?

  6. #6
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can't read it because it is not a plain text. Without the complete set of files it is useless.

  7. #7
    Join Date
    May 2003
    Posts
    33
    and what is the complete set of files. Any relevant reference?

  8. #8
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    There is no standard sets of files, the number of files depend on how database was created in the first place.

    Anyways you need database files for at least

    system tablespaces
    user tablespaces
    control files (or create control file script)
    initSID.ora file

    This site guides you step by step for revcovery

    http://www.infomaxweb.com/Oracle8i/CompleteRecovery.htm

  9. #9
    Join Date
    May 2003
    Posts
    33
    What about Oracle 9i?

  10. #10
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    The basic recovery mechanism has not changed much from 8i to 9i, so you should still be able to use the instructions for 8i.

    You can always go to otn.oracle.com and register to get all the oracle manuals.

  11. #11
    Join Date
    May 2003
    Posts
    33
    now i want to connect with Oracle through a php script. What is the right configurations? I use Oracle 9i r2

  12. #12
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932

  13. #13
    Join Date
    May 2003
    Posts
    33
    The link was right, but what about the settings?, in php.ini or whatever?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •