Transfer Databse between Two Oracle Servers
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Transfer Databse between Two Oracle Servers

  1. #1
    Join Date
    Nov 2009
    Posts
    2

    Transfer Databse between Two Oracle Servers

    Hi,

    I have been given asked to work on small project as a volunteer. I am a software developer and new to DBA site.

    There are two servers available in the company. One is the Live server and other one is recovery server. Company wants to move Database from Live server to Recovery Server in very short time span incase if live server goes down becuase of any failure.

    In the live server Tablespaces, Datafiles, and Control Files are being saved on external disk through scripts. At the moment Recovery server doesn't have oracle installed on it.

    I am planning to install oracle server on Recovery server with the same settings as in Live server.

    I like to know that how can i transfer all the data (Live server has number of tables in different schemas) from Live Server to Recovery Server and run the recovery server if anything does wrong with Live server?

    Do i just need to copy Tablespaces, Datafiles, and Control Files from live to recovery server on right paths? What other files and objects i need to look after?

    Thanks
    Last edited by momer79; 11-26-2009 at 10:36 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    this isnt true is it - a pen drive? sounds like a class project

  3. #3
    Join Date
    Nov 2009
    Posts
    2
    Not a pen drive, its actually external hard drive. Script runs few times in a week which copy the files to external drive.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Please start by researching "disaster recovery, business continuity"
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,445

    Talking Backup and Recovery Basics

    Quote Originally Posted by PAVB View Post
    Please start by researching "disaster recovery, business continuity"
    And also....you could begin by reading the fine OracleŽ Database Backup and Recovery Basics manual.
    "The person who says it cannot 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
  •  



Click Here to Expand Forum to Full Width