Results 1 to 11 of 11
  1. #1
    Join Date
    Jan 2003
    Location
    The Netherlands
    Posts
    149

    Unhappy Unanswered: restore oracle 7 db to oracle 9i

    I have the *.dbf, *.ctl and *.log files. How can i create a working instance on my oracle 9i server? I don't have RMAN.

    beforehand thanx!

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    do you still have the oracle 7 db open?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jan 2003
    Location
    The Netherlands
    Posts
    149

    no oracle 7 server

    I got the oracle 7 database files from another company. They want me to make it a oracle 9 database. So I do not have an oracle 7 or 8 databaseserver.

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    too bad you can't just export the Ora 7 db using the 9i export
    utility. That would have been simple.

    In this situation I think you are really talking apples-to-oranges
    if you want to somehow recover Oracle 7 db/files and also upgrade
    them to a 9i db all at the same time.

    Have you tried to recover the DB using those files?
    Try and see what happens
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Jan 2003
    Location
    The Netherlands
    Posts
    149

    Unhappy restore?

    How can I restore the datafiles if I don't have an oracle 7 databaseserver and only an oracle 9i databaseserver? You just said it was not possible. If i'm right. Or do you mean something else.

    greetings Coen

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    where did I say it was impossible?

    I said: TRY IT

    Pretend these are a cold backup from a 9i db and you want
    to recreate it on another server. SEE WHAT HAPPENS.

    Worse case scenario you find out it doesn't work.
    I am interested in finding out what happens myself.


    If you want to save time, suggest to the people with the Ora 7 db
    that you want them to EXPORT the Ora 7 db using an ORACLE 9i
    export client.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  7. #7
    Join Date
    Apr 2004
    Posts
    246
    I don't think you can export v7 with a v9 client. However, if they export v7 with the v7 export utility, you should be able to import it to v9 with the v9 import utility. I've never had a problem using Exp/imp to go up a version - the dmp file is fine going up versions, but you must use the client utility that came with the db. (I've done exp v5/imp v7; exp 7/imp 8; exp 8/imp 9).
    Give a man a fish, you feed him for a day. Club him over the head with a fish, he'll leave you alone.

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I don't think you can export v7 with a v9 client. However, if they export v7 with the v7 export utility
    HUH?
    The EXPORT utility REQUIRES the database to be up & online.
    If the OP can open the database, his problems are solved.
    The V9 DBUA requires the source database to be up & online; as the previous version.
    The OP should keep backup copies of the datafiles before trying any experiment.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Apr 2004
    Posts
    246
    "HUH?"
    a previous reply stated "EXPORT the Ora 7 db using an ORACLE 9i
    export client".
    I saying that this won't work. you cannot use the exp.exe the came with oracle 9 to export a v7 database. to exp v7, you must use a exp.exe that came with v7. however, an export file from a v7 exe can be imported to a v9 database using the imp.exe that cam with v9.


    "If the OP can open the database, his problems are solved."
    what's "OP"? (I'm not up on all these acronyms that get thrown around)
    Give a man a fish, you feed him for a day. Club him over the head with a fish, he'll leave you alone.

  10. #10
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    OP - Original Poster
    The EXPORT utility REQUIRES the database to be up & online; regardless of version of DB or export client.
    How do you propose to open the V7 database WITHOUT v7 s/w to use any EXPORT client?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  11. #11
    Join Date
    Apr 2004
    Posts
    246
    I'm not arguing that the db needs to be up - I considered that one to be self evident.

    Duck wrote "suggest to the people with the Ora 7 db that you want them to EXPORT the Ora 7 db using an ORACLE 9i export client."
    I'm simply saying that the other company that supplied the OP with the db files would need to use the exp.exe that came with v7 is they actually have a v7 db up and running. Maybe they ditched v7 years ago, and want something off a backup tape, in which case their most likey screwed. Beats me.

    So, if the company with the v7 database files has a v7 oracle install up and running, then they should use the export utility that came with the v7 database to export said database. Then the OP can import that export file into his owner v9 database using the imp.exe that came with the v9 database.

    clear enough yet?
    Give a man a fish, you feed him for a day. Club him over the head with a fish, he'll leave you alone.

Posting Permissions

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