RMAN restore to a new server question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: RMAN restore to a new server question

Hybrid View

  1. #1
    Join Date
    Oct 2006
    Posts
    17

    RMAN restore to a new server question

    I have been tasked with cloning our prod db to a new server from an
    rman backup(with a catalog) on tape to a new server in another data
    center. I have installed oracle on the new server and have copied the
    init file and started up the db. I created a new catalog user in the
    new datacenter. I have no experience with rman but have been reading
    up and think I am on the right path. Can anyone confirm? This is coming from a backup that used a catalog. I have made an empty catalog in the repository in the new datacenter but was thinking that I should do the restore as nocatalog as the new catalog knows nothing of the backup. Here is what I have scripted. One more thing the new server has a different filesystem layout so I am using the newname command.

    STARTUP NOMOUNT

    rman TARGET / NOCATALOG

    RMAN> set DBID 2796110657

    {
    allocate channel t1 type "sbt_tape"
    parms="BLKSIZE=524288,SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so.
    1";
    restore controlfile to '/CCTPROD/oradata/control01.ctl';;
    ALTER DATABASE MOUNT;
    SET newname FOR DATAFILE 9 TO '/NEWPROD/oradata/statsdata1.dbf';
    SET newname FOR DATAFILE ...
    SET newname FOR DATAFILE ...
    SET newname FOR DATAFILE ...(renaming all of the datafiles to the new
    location)
    RESTORE DATABASE;
    RECOVER DATABASE;

    Regards,
    SMD

  2. #2
    Join Date
    Nov 2000
    Posts
    224
    I can't say that you are 100% in right direction as you may have to go through some more learning on this. But you are not way off either.
    If you have access to metalink, I will advise you to read the note "372996.1".

    Good Luck.

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Talking



    Here is the script I use which definitely works:
    Code:
    CONNECT CATALOG RMANCAT/ThePW@RCAT
    CONNECT TARGET /
    STARTUP NOMOUNT PFILE=init.ora;
    
    RUN {
     ALLOCATE CHANNEL CH1 TYPE DISK;
     SET UNTIL SCN={you need an scn (or thread/seq#);
     RESTORE CONTROLFILE;
    }
    SQL ĎALTER DATABASE MOUNTí;
    
    RUN {
    ALLOCATE CHANNEL CH0 TYPE DISK;
    ALLOCATE CHANNEL CH1 TYPE DISK;
    ALLOCATE CHANNEL CH2 TYPE DISK;
    ALLOCATE CHANNEL CH3 TYPE DISK;
    ###
    SET NEWNAME FOR DATAFILE  1 TO '{new data name 1)';
    SET NEWNAME FOR DATAFILE  2 TO '{new data name 2}';
    ### Etc ...
    SET UNTIL SCN={you need an scn (or thread/seq#);
    RESTORE DATABASE;
    SWITCH DATAFILE ALL;
    RECOVER DATABASE;
    }
    Good luck!

    PS: Change channels from disk to tape.
    Last edited by LKBrwn_DBA; 09-12-2007 at 08:40 PM.
    "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