3 Replies Latest reply: Apr 26, 2013 9:41 AM by 864103 RSS

    restore to different server

    864103
      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
          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
            Salman Qureshi
            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
              thanks man .