Rescue 8i Database from Files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Rescue 8i Database from Files

  1. #1
    Join Date
    May 2001
    Location
    Sydney Australia
    Posts
    44

    Rescue 8i Database from Files

    Is there a way to access an 8i database (version 8.1.7) from the files themselves? I backed up the *.dbf, *.ctl and *.log files from an internet database server shortly before it crashed.

    I can't get back into the server itself, and I need to provide the data to the client in some way that their database team can import into their own Oracle databases. But they say they can't recreate the database from these files?

    The DBA that set up the original database has long gone, and I have only minor experience with Oracle.

    MTIA
    Max
    Australia
    Max Hugen
    Hugen Enterprises Pty Ltd
    www.hugen.com.au

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You might have to resort to a tool such as DUDE.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    May 2001
    Location
    Sydney Australia
    Posts
    44
    Thanks David... would DUDE also provide them (the client) with some sort of schema, so that they can recreate the tables, triggers etc?

    Cheers, Max
    Max Hugen
    Hugen Enterprises Pty Ltd
    www.hugen.com.au

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I'm no expert, but I believe that the complete schema would be recoverable. You'd have to check with those in the know though.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    were the files taken when the database was shutdown or when it was still running?

  6. #6
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    The last post makes sence. Maybe you'll be able to open the database as usual.
    About the rescue, I belive Oracle Consulting has a tool, to do that. It can generate dmp file or flat file. However, the only option to get that tool is to pay several consulting days to Oracle so it's a bit expencive

    Regards
    Boris

  7. #7
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Metalink Note 135651.1 might help ... no?
    Last edited by JMac; 11-07-2006 at 06:08 AM.

  8. #8
    Join Date
    Feb 2004
    Location
    India
    Posts
    18
    Let me ask u couple of questions

    1. How did u back up the control file...
    Did u use alter database backup controlfile to trace
    If that is the case u can set it up.....

    2. Hope Init.ora and pwd.ora has also been backed up.

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