Restore RMAN full backup to different server with other name
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Restore RMAN full backup to different server with other name

  1. #1
    Join Date
    Dec 2007
    Posts
    2

    Restore RMAN full backup to different server with other name

    Hello ,

    I have production(PRODA) RMAN full backup taken by using catalog. I want to restore it on different server with different database name. On that server where I need to restore already other instance is running with same name as production(PRODA).

    I do not want to use RMAN duplicate command because I do not have network connectivity between prod server and new server.

    How I can acheive this?
    Please suggest.


    Thanks,
    Devendra

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,966
    Generally when you clone using rman the "target" is the database that you are cloning from and the auxiliary is what you are cloning to.

    I suppose you could restore it as the original name and then do an alter database backup controlfile to trace; and then rename and move everything to the new proper place and recreate the control file to point to the right database name and location for all the data files and online redo.

    Also make sure that you post to the right forum.
    this space intentionally left blank

  3. #3
    Join Date
    Feb 2009
    Location
    Kayseri, Turkey
    Posts
    15
    Quote Originally Posted by gandolf989 View Post
    I suppose you could restore it as the original name and then do an alter database backup controlfile to trace; and then rename and move everything to the new proper place and recreate the control file to point to the right database name and location for all the data files and online redo.
    Alternatively you may use the DBNEWID utility like following :

    Code:
    SQL> SHUTDOWN IMMEDIATE
    SQL> STARTUP MOUNT
    CMD> nid TARGET=/  DBNAME=NEWSID
    SQL> SHUTDOWN IMMEDIATE
    SQL> STARTUP
    Metin Ergöktaş
    10g OCP DBA

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

    Cool Cloneb

    1) Make sure all rman backup files from PRODA are in the same location(s) in the new server as the source server (same path names)
    2) Copy the initPRODA.ora file to the new ${Oracle Home}/dbs location and:
    a) change the name to initCLONEB.ora
    b) Add the db_file_name_convert and log_file_name_convert to translate the file locations to new locations.
    c) DO NOT yet change the db_name
    3) Set ORACLE_SID to CLONEB
    4) Statup RMAN and execute these commands
    Code:
    CONNECT TARGET /
    STARTUP NOMOUNT
    ### This is the PRODA db-id:
    SET DBID=123456789; 
    RESTORE CONTROLFILE FROM '/backup/PRODA/rman/c-nnnnn-mmmm-00';
    ALTER DATABASE MOUNT;
    RUN {
            ALLOCATE CHANNEL C1 DEVICE TYPE DISK;
            ALLOCATE CHANNEL C2 DEVICE TYPE DISK;
            ALLOCATE CHANNEL C3 DEVICE TYPE DISK;
            ALLOCATE CHANNEL C4 DEVICE TYPE DISK;
            ### You need to set the point in time recovery:
            SET UNTIL SEQUENCE 6215 THREAD 1; 
            ### 
            RESTORE DATABASE; 
            RECOVER DATABASE;
    }
    ALTER DATABASE OPEN RESETLOGS;
    5) Use sqlplus to create the temporary files.
    6) Use the nid (newid) utility to change the database name.
    7) Backup the clone immediately.
    "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