Results 1 to 7 of 7
  1. #1
    Join Date
    May 2008
    Posts
    2

    Unanswered: restoring from os files

    I have an oracle9 database that I only have the OS files for (everything in /u01/oradata/mydatabase. So the control files, dbfs, etc.. I have all of this. But I can't seem to find a guide on how to bring this database up on another system.

    Any help would be appreciated.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    If the copies of the database files were made after a clean shutdown, then do


    sqlplus
    / as sysdba
    startup
    exit


    Oracle won't know or care that these files now reside on a different system.
    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.

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking

    Quote Originally Posted by anacedent
    Oracle won't know or care that these files now reside on a different system.
    What about that "endian"ess thing (cr@p)?
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >What about that "endian"ess thing (cr@p)?
    I was "assuming" similar hardware & identical OS versions.
    Anything else is doomed to failure.
    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.

  5. #5
    Join Date
    May 2008
    Posts
    2
    Yes, identical systems

    so say my database is named "TEST" just copy that test folder containing all of the ctl, dbf folders etc.. onto the new oracle system in the oradata folder and start up sqlplus and oracle will do the rest?

    How does sqlplus know about the database I just copied over? What if this system already has one database on it?

    thanks for the replies.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    all the normal Oracle 'rules' apply

    ORACLE_SID=test
    export ORACLE_SID

    Also this presumes EXACT same version of Oracle s/w is installed on both systems.
    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.

  7. #7
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking

    And.... You may need the spfile or pfile, listener.ora and tnsnames.ora
    .
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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