11 Replies Latest reply on Jun 22, 2010 1:47 PM by HungryMind

    Restoring RMAN backup to a different host

    Fadai Ganjaliyev
      Brothers and sisters,

      I am trying to restore an RMAN backup taken onto a tape to a different server.
      I have googled this process and also searched this forum also. There is a lot of material there about this.
      But the problem is that the restoration gives me errors which Oracle doc says there should be additional messages.
      The matter is in my case there is not.

      Here how it goes in my case:
      I have two different servers and a separate Tivoli storage server.
      On each of the servers I have a DB and I can successfully backup and restore each of them
      individually on the tape using an RMAN catalog which is a different DB on the primary server.
      This meas that the tape system can connect to each of the servers.

      My restoration code is very simple and a general one
      ./rman target/
      connect catalog ....
      connect auxiliary sys/oracle@TestDB
      [sql]
      run{
      set newname for datafile 1 ..... to ...
      ....................................................
      DUPICATE TARGET DATABASE TO TestDB

      LOGFILE GROUP 1 ('/u02/sys/redo01.log') SIZE 100M REUSE,
      GROUP 2 ('/u02/sys/redo02.log') SIZE 100M REUSE,
      GROUP 3 ('/u02/sys/redo03.log') SIZE 100M REUSE,
      GROUP 4 ('/u02/sys/redo04.log') SIZE 100M REUSE,
      GROUP 5 ('/u02/sys/redo05.log') SIZE 100M REUSE;
      [sql]

      and here is the output
      ...............................
      [error]
      Starting restore at 15-MAY-10
      allocated channel: ORA_AUX_DISK_1
      channel ORA_AUX_DISK_1: SID=150 device type=DISK
      using channel ORA_AUX_SBT_TAPE_1

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 05/15/2010 15:19:43
      RMAN-03015: error occurred in stored script Memory Script
      ORA-27191: sbtinfo2 returned error
      Additional information: 3402
      [error]

      I have seen a lot of cases in google, people trying to restore and each having some messages like datafile not found, no backup found or smth of this kind i.e. they have some additionale messages, but in my case it says error in memory script but no additional messages are there execpt for "Additional information: 3402" which i dont have any idea what means and which didnt give any google results either.


      Oracle version is 11g, release 1.

      Friends, if anyone of you can suggest smth it is really very appreciated.
      Please give some hints.

      Thanks.
        • 1. Re: Restoring RMAN backup to a different host
          558383
          There is likely a issue with the Media Manager Layer (MML). Try to see what 3402 error code could mean for your MML.
           oerr ora 27191
          27191, 00000, "sbtinfo2 returned error"
          // *Cause:  sbtinfo2 returned an error.  This happens while retrieving
          //          backup file information from the media manager's catalog.
          // *Action: This error is returned from the media management software which is
          //          linked with Oracle.  There should be additional messages which
          //          explain the cause of the error.  This error usually requires
          //          contacting the media management vendor.
          Edited by: P. Forstmann on 17 mai 2010 08:53
          • 2. Re: Restoring RMAN backup to a different host
            Chinar
            There main error is ORA-27191: sbtinfo2 returned error

            Cause: sbtinfo2 returned an error. This happens while retrieving backup file information from the media manager's catalog.
            Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.

            investigate that,why can not retrie backup information from MMC?
            • 3. Re: Restoring RMAN backup to a different host
              722368
              Hi,

              When you want to restore from an old backup taken on to tape media, in your script you have allocate channel of type SBT_TAPE. currently it is allocating a default channel of type DISK where as it is trying to access tape.

              from 11g onwards, you have the option of duplicating from the live database. you can use option Duplicate from Active database. And in this case no need of a backup of TARGET database.

              As you have not mentioned any set until time, I guess you want to create duplicate from live database.

              Thanks,
              Siva
              • 4. Re: Restoring RMAN backup to a different host
                Fadai Ganjaliyev
                Hi,

                Even this
                "DUPICATE TARGET DATABASE TO TestDB" results the same error.
                So i guess thats not the reason.
                • 5. Re: Restoring RMAN backup to a different host
                  Fadai Ganjaliyev
                  Excuse me,
                  This
                  "DUPICATE TARGET DATABASE TO TestDB device type sbt"
                  results the same error.
                  • 6. Re: Restoring RMAN backup to a different host
                    Fadai Ganjaliyev
                    But in case of logging onto the destiantion server, backup and restoration is successful.
                    • 7. Re: Restoring RMAN backup to a different host
                      Hemant K Chitale
                      Additional information: 3402
                      3402 is the error number returned by your MML -- Tivoli.

                      Oracle requested Tivoli for the backuppieces it needed. Tivoli returned an error 3402.


                      Hemant K Chitale
                      • 8. Re: Restoring RMAN backup to a different host
                        722368
                        Hi,

                        please post the complete script. Also post the contents of file sbtio.out/sbtio.log located in udump at the time of the error.

                        Thanks,
                        Siva
                        • 9. Re: Restoring RMAN backup to a different host
                          Fadai Ganjaliyev
                          show all from RMAN for PRIMDB
                          ------------------------------------------------------------------------------------------------------------
                          RMAN configuration parameters for database with db_unique_name PRIMDB are:
                          CONFIGURE RETENTION POLICY TO NONE;
                          CONFIGURE BACKUP OPTIMIZATION ON;
                          CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
                          CONFIGURE CONTROLFILE AUTOBACKUP ON;
                          CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
                          CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
                          CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
                          CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
                          CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
                          CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
                          CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
                          CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
                          CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
                          CONFIGURE AUXILIARY CHANNEL DEVICE TYPE DISK FORMAT '%t';
                          CONFIGURE MAXSETSIZE TO UNLIMITED;
                          CONFIGURE ENCRYPTION FOR DATABASE OFF;
                          CONFIGURE ENCRYPTION ALGORITHM 'AES128';
                          CONFIGURE COMPRESSION ALGORITHM 'BZIP2';
                          CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
                          CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.1.0/db_2/dbs/snapcf_PRIMDB.f';
                          ------------------------------------------------------------------------------------------------------------

                          Here is the duplication code
                          ------------------------------------------------------------------------------------------------------------
                          RUN{

                          SET NEWNAME FOR DATAFILE 1 TO '/u02/sys/system01.dbf';
                          ..........................................................
                          SET NEWNAME FOR DATAFILE 54 TO '/u02/index/FCCDFLT_04.dbf';
                          SET NEWNAME FOR TEMPFILE 1 to '/u02/sys/temp.dbf';
                          SET NEWNAME FOR TEMPFILE 2 to '/u02/archlogs/temp3.dbf';
                          DUPLICATE TARGET DATABASE TO TestDB device type sbt
                          LOGFILE GROUP 1 ('/u02/sys/redo01.log') SIZE 100M REUSE,
                          GROUP 2 ('/u02/sys/redo02.log') SIZE 100M REUSE,
                          GROUP 3 ('/u02/sys/redo03.log') SIZE 100M REUSE,
                          GROUP 4 ('/u02/sys/redo04.log') SIZE 100M REUSE,
                          GROUP 5 ('/u02/sys/redo05.log') SIZE 100M REUSE;

                          }
                          ------------------------------------------------------------------------------------------------------------

                          sbtio.log file

                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-2830422 11/14/2009 18:49:28 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-2891788 11/14/2009 18:49:28 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          SBT-2830422 11/14/2009 18:49:28 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-2891788 11/14/2009 18:49:28 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-2830422 11/14/2009 18:49:28 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-2830422 11/14/2009 18:49:28 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-2338942 11/14/2009 18:49:28 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          SBT-2338942 11/14/2009 18:49:28 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-2338942 11/14/2009 18:49:28 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-2924676 11/14/2009 18:53:45 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          SBT-2924676 11/14/2009 18:53:45 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-2924676 11/14/2009 18:53:45 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-2924676 11/14/2009 18:53:45 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-2924676 11/14/2009 20:29:02 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          SBT-2924676 11/14/2009 20:29:02 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-2924676 11/14/2009 20:29:02 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-2924676 11/14/2009 20:29:02 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-2924676 11/14/2009 20:36:34 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-2068532 11/23/2009 22:19:54 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-1777690 11/23/2009 22:19:54 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          SBT-2068532 11/23/2009 22:19:54 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-1777690 11/23/2009 22:19:54 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-1777690 11/23/2009 22:19:54 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-2068532 11/23/2009 22:19:54 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-2568364 11/25/2009 14:49:42 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-3715162 11/25/2009 14:49:42 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          SBT-2568364 11/25/2009 14:49:42 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-3715162 11/25/2009 14:49:42 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-589920 11/25/2009 17:02:05 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-3715162 11/25/2009 17:02:05 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          SBT-589920 11/25/2009 17:02:05 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-589920 11/25/2009 17:02:05 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-1286152 12/25/2009 17:28:38 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-1257650 12/25/2009 17:28:38 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          SBT-1257650 12/25/2009 17:28:38 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-1286152 12/25/2009 17:28:38 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-2457714 12/25/2009 17:29:58 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-1257650 12/25/2009 17:29:58 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          SBT-1257650 12/25/2009 17:29:58 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-2457714 12/25/2009 17:29:58 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-1257650 12/25/2009 17:29:58 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-1536060 12/26/2009 15:00:16 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          SBT-1536060 12/26/2009 15:00:16 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          SBT-1536060 12/26/2009 15:00:16 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API
                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-3899576 04/16/2010 19:48:01 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          ===========================================================
                          Tracing started for:
                          -----------------------------------------------------------
                          Application Client : TDP Oracle AIX
                          Version : 5.5.1.0
                          ===========================================================
                          SBT-725240 04/16/2010 20:37:30 send2.cpp(505): sbtwrite2(): Exit - DSMSENDDATA() failed. dsmHandle = 1

                          SBT-725240 04/16/2010 20:37:30 send2.cpp(325): : Exit - Error from previous call detected no data sent to TSM API


                          sbtio.out file is not there in the udump directory.
                          • 10. Re: Restoring RMAN backup to a different host
                            780784
                            I had this exact same issue. I checked the tdpoerror.log and it contained the following error:

                            ANS1245E (RC122) The file has an unknown format.

                            I checked and sure enough, my backup was done with TDP agent version 5.5.2 and my auxiliary database had 5.5.1. The older version could not read the newer version backup.
                            • 11. Re: Restoring RMAN backup to a different host
                              HungryMind
                              Can you try restoring using the below method:

                              connect auxiliary /
                              connect target sys/password@PRD
                              duplicate target database to TestDB
                              db_file_name_convert=
                              ( '/u02/locationPRD/oradata/PRD','/u02/locationTEST/oradata/TestDB'
                              )
                              logfile group 1
                              ( '/u02/location/redo01a.log'
                              , '/u02/location/redo01b.log'
                              ) size 51m
                              , group 2
                              ( '/u02/location/redo02a.log'
                              , '/u02/location/redo02b.log'
                              ) size 51m
                              , group 3
                              ( '/u02/location/redo03a.log'
                              , '/u02/location/redo03b.log'
                              ) size 51m
                              # uncomment and change following line
                              # for NOT restoring until the last available archive
                              #until time="to_date('20102123003700','yyyymmddhh24miss')"
                              ;
                              exit