DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Transfer Databse between Two Oracle Servers

  1. 11-26-2009, 11:16 AM #1
    momer79
    momer79 is offline Junior Member
    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 11:36 AM.
    Reply With Quote Reply With Quote
  2. 11-26-2009, 11:19 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    this isnt true is it - a pen drive? sounds like a class project
    Reply With Quote Reply With Quote
  3. 11-26-2009, 11:33 AM #3
    momer79
    momer79 is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  4. 11-30-2009, 01:45 PM #4
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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.
    Reply With Quote Reply With Quote
  5. 12-02-2009, 03:51 PM #5
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width