4 Replies Latest reply: Aug 30, 2013 5:41 AM by user2664321 RSS

    RMAN restore auxiliary db error...

    730422
      Dear all,

      Got the following error while creating RMAN auxiliary database using DATA PROTECTOR to restore from tape.

      RMAN> CONNECT TARGET *
      2> CONNECT CATALOG *
      3> CONNECT AUXILIARY *
      4>
      5> run {
      6> allocate auxiliary channel 'dev_0' type 'sbt_tape'
      7> parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2APPNAME=UAT,OB2BARLIST=1270532070,OB2BARHOSTNAME=xxx.xxx.com)';
      8>
      9>
      10> duplicate target database to 'TST';
      11>
      12> }
      13>
      14> EXIT
      connected to target database: UAT (DBID=2738990626)

      connected to recovery catalog database

      connected to auxiliary database: TST (not mounted)
      .
      .

      contents of Memory Script:
      {
      set until scn 269185447;
      set newname for datafile 1 to
      "/backup/oratst/db/apps_st/data/system01.dbf";
      set newname for datafile 2 to
      "/backup/oratst/db/apps_st/data/system02.dbf";
      .
      .
      "/backup/oratst/db/apps_st/data/appstssummary011.dbf";
      restore
      check readonly
      clone database
      ;
      }
      executing Memory Script

      executing command: SET until clause

      executing command: SET NEWNAME

      .
      .

      executing command: SET NEWNAME

      Starting restore at 06-APR-10

      channel dev_0: starting datafile backupset restore
      channel dev_0: specifying datafile(s) to restore from backup set
      restoring datafile 00001 to /backup/oratst/db/apps_st/data/system01.dbf
      .
      . ORA-19870: error reading backup piece rman_full_online_104_uat<UAT_14:715603353:1>.dbf
      ORA-19507: failed to retrieve sequential file, handle="rman_full_online_104_uat<UAT_14:715603353:1>.dbf", parms=""
      ORA-27029: skgfrtrv: sbtrestore returned error
      ORA-19511: Error received from media manager layer, error text:
      Vendor specific error: OB2_StartObjectRestoreFullName() failed ERR(-2)
      failover to previous backup

      .
      .

           COMPLETED Media Agent "HP:Ultrium 4-SCSI_1"

      Oracle Error:
      ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
      ORA-01194: file 1 needs more recovery to be consistent
      ORA-01110: data file 1: '/backup/oratst/db/apps_st/data/system01.dbf'

      released channel: dev_0
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 04/06/2010 11:16:00
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-20506: no backup of archivelog found
      RMAN-06053: unable to perform media recovery because of missing log
      RMAN-06025: no backup of log thread 1 seq 62 lowscn 269177994 found to restore

      Recovery Manager complete.
      [Major] From: ob2rman@reeldev.ramky.com "UAT" Time: 04/06/10 11:18:43
           The database reported error while performing requested operation.

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 04/06/2010 11:16:00
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-20506: no backup of archivelog found
      RMAN-06053: unable to perform media recovery because of missing log
      RMAN-06025: no backup of log thread 1 seq 62 lowscn 269177994 found to restore

      Recovery Manager complete.


      please suggest me what i miss or how to solve?


      thanks
      sandeep.

      Edited by: user2584435 on Apr 6, 2010 2:37 PM
        • 1. Re: RMAN restore auxiliary db error...
          19426
          ORA-19511: Error received from media manager layer, error text:
          Vendor specific error: OB2_StartObjectRestoreFullName() failed ERR(-2)
          You have a problem in your media management layer, RMAN is the victim,not the culprit. So consult the staff responsible for data protector , they have to check their logfiles and should know what this 'vendor specific error' means.

          Werner
          • 2. Re: RMAN restore auxiliary db error...
            730422
            hi,

            released channel: dev_0
            RMAN-00571: ===========================================================
            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
            RMAN-00571: ===========================================================
            RMAN-03002: failure of Duplicate Db command at 04/06/2010 11:16:00
            RMAN-03015: error occurred in stored script Memory Script
            RMAN-20506: no backup of archivelog found
            RMAN-06053: unable to perform media recovery because of missing log
            RMAN-06025: no backup of log thread 1 seq 62 lowscn 269177994 found to restore

            Recovery Manager complete.
            [Major] From: ob2rman@reeldev.ramky.com "UAT" Time: 04/06/10 11:18:43
                 The database reported error while performing requested operation.

            RMAN-00571: ===========================================================
            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
            RMAN-00571: ===========================================================
            RMAN-03002: failure of Duplicate Db command at 04/06/2010 11:16:00
            RMAN-03015: error occurred in stored script Memory Script
            RMAN-20506: no backup of archivelog found
            RMAN-06053: unable to perform media recovery because of missing log
            RMAN-06025: no backup of log thread 1 seq 62 lowscn 269177994 found to restore


            is any issue with above error? coz i already have made one clone from this backup set.

            regards,
            sandeep
            • 3. Re: RMAN restore auxiliary db error...
              Rajesh Lathwal
              I hope it will not cause any issue because it is looking to restore logfile which are not backed..

              please read this

              Restore Archivelog All Validate Fails RMAN-06025 for Non-exsistent Backups [ID 235973.1]


              Regards
              Rajesh
              • 4. Re: RMAN restore auxiliary db error...
                user2664321

                Hi Sandeep. We had the exact same problem when we were trying to restore an older live backup into a test system. Did you or whoever manage to sort out the problem on the Data Protector side of things?