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

Thread: rman copy live to test different servers

  1. 01-20-2009, 07:52 AM #1
    philthee
    philthee is offline Junior Member
    Join Date
    Oct 2008
    Posts
    69

    rman copy live to test different servers

    Hi There, i've seen a couple of similar threads but not with my exact requirements (which i find odd as i thought would be very common)
    Anyway, we have a live database backed up by RMAN every day.

    I want to perform a weekly copy of the live database to a test database on a different server (unix to unix) with a different SID (eg LIVE SID = 'LIVE', TEST SID = 'TEST')
    I want this to run automatically with a script.

    Really i just want to know if this is possible as everything i have read i have not seen anything about copying to a database with a different SID.

    The Test database isn't registered with the RMAN catalog so i presume i would have to do that before anything else.

    Cheers
    P
    Reply With Quote Reply With Quote
  2. 01-20-2009, 08:03 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    yes you can

    any specific problem you have? (also dont need the catalog as long as you know the DBID)
    Reply With Quote Reply With Quote
  3. 01-20-2009, 08:06 AM #3
    philthee
    philthee is offline Junior Member
    Join Date
    Oct 2008
    Posts
    69
    Quote Originally Posted by davey23uk View Post
    yes you can

    any specific problem you have? (also dont need the catalog as long as you know the DBID)
    Excellent, not yet as i didn't want to start and then find out i couldn't do it.
    I will look further and formulate a plan, see if it sounds reasonable.
    Cheers
    Reply With Quote Reply With Quote
  4. 01-20-2009, 08:34 AM #4
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking Duplicate

    Check out the DUPLICATE command.
    "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