This discussion is archived
3 Replies Latest reply: Apr 26, 2013 7:41 AM by 864103 RSS

restore to different server

864103 Newbie
Currently Being Moderated
HI guys ,

oracle 11.2.2 g ASM RAC under OL 5.6

every one month i do a sanity backup take the backup from the prod and then do a restore to a test
and check everything no. of users , tbs ,...etc and the target just to check is the backup is recoverable or not
i know that rman backup have able to check the block corruption in logical and physical level but this request is came from my manger
we use for a backup HP Data Protector 6.11 , always i just edit the script of backup to write the backup on disk
and then copy this file to test sever and then i do a restore and it get successful , but today he request me to do a restore
from a backup in tape drive and this test server is not connected to HP Data Protector ,

can i restore the backup from HP Data Protector to diff server ?
do i need to install agent to test server ?
can you please help me in this ?


thanks
  • 1. Re: restore to different server
    Fran Guru
    Currently Being Moderated
    you can restore/recover/duplicate in different platforms/servers.

    check:
    RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support [ID 1079563.1]


    to restore, follow this steps:

    1) copy backup in the new server (backup+controlfile+redo logs)
    2) rman> catalog start with '/../../backup';
    3) shutdown immedaite --> startup nomount
    4)RESTORE CONTROLFILE FROM '/../../../controlfile';
    ALTER DATABASE MOUNT;
    RUN {
    ALLOCATE CHANNEL C1 DEVICE TYPE DISK;
    SET UNTIL SEQUENCE xxxx; --or until scn or until time ....
    RESTORE DATABASE;
    RECOVER DATABASE;
    }
    ALTER DATABASE OPEN RESETLOGS;

    5) the end!! :)
  • 2. Re: restore to different server
    SalmanQureshi Expert
    Currently Being Moderated
    Hi,
    can i restore the backup from HP Data Protector to diff server ?
    I have not worked on data protector, but, I have worked on veritas net backup and I believe that data protector must also have capability to do what you are asking here. You need to connect your restoration server to the data protector and then you should read data protector documentation about how to restore backup on a different server.
    do i need to install agent to test server ?
    Are you talking about some agent of data protector which communicates with the server during backup and restore? If yes, then certainly you need to install that so that it can talk with data protector server.

    Salman
  • 3. Re: restore to different server
    864103 Newbie
    Currently Being Moderated
    thanks man .

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points