Partial clone on a remote server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Partial clone on a remote server

  1. #1
    Join Date
    Sep 2006
    Posts
    2

    Partial clone on a remote server

    I have the following task to achieve. My client needs to move part of their database to a new data center. There is no proprietary good network between two centers which are 1,000 miles apart, and downtime can be allowed only for few hours. I wanted to prepare backup level 0 from site A, send it over to site B , restore there, and at the switchover hours, send differential backups over network to site B and apply it by recovering on site B. I know I can do it with full database. The problem is it is too big and client needs just 3 tablespaces to be moved from site A to B, around 70G of data. What is the right solution?

    thanks in advance

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Cool


    Use RMAN to backup/restore tablespaces and rman incrementals by tablespace also.

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Sep 2006
    Posts
    2
    Thanks a lot for reply. The database B will be a new database. Is that going to be fine when only part of tablespaces from A restored and then recovered on a totally new database?

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Cool


    Why don't you check out the manual for an answer?
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    RMAN backs up the consistent data always.
    "What is past is PROLOGUE"

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    setup a standby db in location b, ship logs. When they declare "switchover", stop shipping logs. open standby database, drop tablespaces you don't need.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    What about setting up replication such that only that subset of data gets sent over to another database?

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