2 Replies Latest reply: Feb 28, 2013 3:34 AM by 993635 RSS

    Backup with Data Protector is not working

    993635
      Hello,

      [US]We have an Oracle DB which is saved by HP Data Protector
      [FR]Nous avons une BDD Oracle qui est sauvegardée via HP DataProtector.

      [US]During our last backup, the Data Protector Server has crashed which has stopped the backup during the process.
      [FR]Lors de la dernière sauvegarde, le serveur de backup a planté, arrêtant de ce fait la sauvegarde en cours de la BDD Oracle.

      [US]Now, when we are trying to relaunch the backup, it doesn't work at all.
      The Data Protector agent is starting, it sends the RMAN command to the DB and then stop.

      [FR]Maintenant, lorsque nous voulons relancer la sauvegarde, elle ne fonctionne plus.
      L'agent démarre bien, il envoie bien la commande à RMAN qui démarre puis s'arrête.

      [US] Of we launch the backup manually thru RMAN, it works
      [FR]Lorsqu'on lance cette même sauvegarde manuellement via RMAN, elle fonctionne !

      [US]Lors are not really explicit !
      [FR]Les logs ne sont pas très parlant:

      LOGS of DATA PROTECTOR (in french but I've translated (in bold) which I think, is important)

      Citation:
      [Normal] De : BSM@xxxxxxxx.domain.com "Base10G_DBName_1_Archivelogs_rman_delete" Heure : 26/02/2013 12:10:31
      La session de sauvegarde 2013/02/26-31 a démarré.
      [Normal] De : BSM@xxxxxxxx.domain.com "Base10G_DBName_1_Archivelogs_rman_delete" Heure : 26/02/2013 12:10:33
      Lancement de l'application OB2BAR sur "clientxxx.domain.com" réalisé avec succès.
      [Normal] De : ob2rman@clientxxx.domain.com "DBNameq" Heure : 26/02/2013 12:10:34
      D?marrage de la sauvegarde de la base de donn?es cible.
      Nom du service r?seau : DBNameq.
      Etat de l'instance : OPEN.
      Nom d'instance : DBNameq.
      DBID de la base de donn?es = 3864252955.
      Type de fichier de contr?le de BDD : CURRENT.
      Mode journalisation BDD : ARCHIVELOG.
      Logging mode: ARCHIVELOG.

      [Normal] De : ob2rman@clientxxx.domain.com "DBNameq" Heure : 26/02/2013 12:10:35
      D?marrage de Oracle Recovery Manager.

      Recovery Manager: Release 10.2.0.4.0 - Production on Mar. F?vr. 26 12:10:35 2013
      Copyright (c) 1982, 2007, Oracle. All rights reserved.
      RMAN> CONNECT TARGET *
      2> CONNECT CATALOG *
      3> HOST 'exit';
      4> run {
      5> allocate channel 'dev_0' type 'sbt_tape'
      6> parms 'SBT_LIBRARY=C:/PROGRA~1/OmniBack/bin/orasbt.dll,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DBNameq,OB2BARLIST=Base10G_DBName_1_Archivelogs_rman_delete)'
      7> ;
      8> allocate channel 'dev_1' type 'sbt_tape'
      9> parms 'SBT_LIBRARY=C:/PROGRA~1/OmniBack/bin/orasbt.dll,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DBNameq,OB2BARLIST=Base10G_DBName_1_Archivelogs_rman_delete)'
      10> ;
      11> allocate channel 'dev_2' type 'sbt_tape'
      12> parms 'SBT_LIBRARY=C:/PROGRA~1/OmniBack/bin/orasbt.dll,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DBNameq,OB2BARLIST=Base10G_DBName_1_Archivelogs_rman_delete)'
      13> ;
      14> allocate channel 'dev_3' type 'sbt_tape'
      15> parms 'SBT_LIBRARY=C:/PROGRA~1/OmniBack/bin/orasbt.dll,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DBNameq,OB2BARLIST=Base10G_DBName_1_Archivelogs_rman_delete)'
      16> ;
      17> allocate channel 'dev_4' type 'sbt_tape'
      18> parms 'SBT_LIBRARY=C:/PROGRA~1/OmniBack/bin/orasbt.dll,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DBNameq,OB2BARLIST=Base10G_DBName_1_Archivelogs_rman_delete)'
      19> ;
      20> allocate channel 'dev_5' type 'sbt_tape'
      21> parms 'SBT_LIBRARY=C:/PROGRA~1/OmniBack/bin/orasbt.dll,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DBNameq,OB2BARLIST=Base10G_DBName_1_Archivelogs_rman_delete)'
      22> ;
      23>
      24> send device type 'sbt_tape' 'OB2BARHOSTNAME=clientxxx.domain.com';
      25> sql 'alter system archive log current';
      26> backup
      27> format 'Base10G_DBName_1_Archivelogs_rman_delete<DBNameq_%s:%t:%p>.dbf'
      28> archivelog all
      29> delete input;
      30> backup
      31> format 'Base10G_DBName_1_Archivelogs_rman_delete<DBNameq_%s:%t:%p>.dbf'
      32> current controlfile;
      33> }
      34> EXIT
      RMAN-06005: connect? ? la base de donn?es cible : DBNameQ (DBID=3864252955)
      RMAN-06005: connected to targeted database : DBNameQ (DBID=3864252955)
      RMAN-06008: connect? ? la base de donn?es du catalogue de r?cup?ration
      RMAN-06008: connected to recovery database

      RMAN-08030: canal affect? : dev_0
      RMAN-08030: allocated chanel : dev_0
      RMAN-08500: canal dev_0 : sid=422 typedev=SBT_TAPE
      RMAN-08500: dev_0 channel : sid=422 typedev=SBT_TAPE
      RMAN-08526: canal dev_0 : Data Protector A.06.20/DPWIN_00536(b621)
      RMAN-08526: dev_0 channel : Data Protector A.06.20/DPWIN_00536(b621)
      RMAN-08030: canal affect? : dev_1
      RMAN-08500: canal dev_1 : sid=888 typedev=SBT_TAPE
      RMAN-08526: canal dev_1 : Data Protector A.06.20/DPWIN_00536(b621)
      RMAN-08500: canal dev_2 : sid=681 typedev=SBT_TAPE
      RMAN-08526: canal dev_2 : Data Protector A.06.20/DPWIN_00536(b621)
      RMAN-08030: canal affect? : dev_3
      RMAN-08500: canal dev_3 : sid=717 typedev=SBT_TAPE
      RMAN-08526: canal dev_3 : Data Protector A.06.20/DPWIN_00536(b621)
      RMAN-08030: canal affect? : dev_4
      RMAN-08500: canal dev_4 : sid=223 typedev=SBT_TAPE
      RMAN-08526: canal dev_4 : Data Protector A.06.20/DPWIN_00536(b621)
      RMAN-08030: canal affect? : dev_5
      RMAN-08500: canal dev_5 : sid=212 typedev=SBT_TAPE
      RMAN-08526: canal dev_5 : Data Protector A.06.20/DPWIN_00536(b621)
      RMAN-06421: commande envoy?e au canal : dev_0
      RMAN-06421: command send to channel : dev_0
      RMAN-06421: commande envoy?e au canal : dev_1
      RMAN-06421: commande envoy?e au canal : dev_2
      RMAN-06421: commande envoy?e au canal : dev_3
      RMAN-06421: commande envoy?e au canal : dev_4
      RMAN-06421: commande envoy?e au canal : dev_5
      RMAN-06162: instruction SQL : alter system archive log current
      RMAN-06162: SQL query : alter system archive log current
      RMAN-03090: D?marrage de backup dans 26/02/13
      RMAN-03090: BAckup is starting in 26/02/13
      RMAN-08031: canal lib?r? : dev_0
      RMAN-08031: released channel : dev_0
      RMAN-08031: canal lib?r? : dev_1
      RMAN-08031: canal lib?r? : dev_2
      RMAN-08031: canal lib?r? : dev_3
      RMAN-08031: canal lib?r? : dev_4
      RMAN-08031: canal lib?r? : dev_5
      [Normal] De : BSM@xxxxxxxx.domain.com "Base10G_DBName_1_Archivelogs_rman_delete" Heure : 26/02/2013 12:10:46
      Application OB2BAR sur "clientxxx.domain.com" déconnectée.
      Application OB2BAR on"xxx" disconnected.
      [Critique] De : BSM@xxxxxxxx.domain.com "Base10G_DBName_1_Archivelogs_rman_delete" Heure : 26/02/2013 12:10:46
      Aucun Agent de disque ne s'est effectué correctement.
      La session a échoué.
      None of the Disk Agents completed successfully.
      Session has failed.
      [Normal] De : BSM@xxxxxxxx.domain.com "Base10G_DBName_1_Archivelogs_rman_delete" Heure : 26/02/2013 12:10:46
      Statistiques de la sauvegarde :

      Temps de file d'attente de la session (en heures) 0,00
      -------------------------------------------
      Agents de disque terminés ........ 0
      Agents de disque ayant échoué ........... 0
      Agents de disque abandonnés .......... 0
      -------------------------------------------
      Total des Agents de disque ........... 0
      ========================================
      Agents de support terminés ....... 0
      Agents de support ayant échoué .......... 0
      Abandon des Agents de support ......... 0
      -------------------------------------------
      Total des Agents de support .......... 0
      ===========================================
      Total Méga-octets ................. 0 Mo
      Total des supports utilisés ............. 0
      Total d'erreurs d'Agent de disque ...... 0
        • 1. Re: Backup with Data Protector is not working
          brunors
          The application disconnected with the database in this stage "Application OB2BAR on"xxx" disconnected.
          [Critique] De : BSM@xxxxxxxx.domain.com "Base10G_DBName_1_Archivelogs_rman_delete" Heure : 26/02/2013 12:10:46
          Aucun Agent de disque ne s'est effectué correctement.
          La session a échoué." . Did you check the connection with the Database? Did you have any time out during this step?

          Regards,
          Bruno Reis.
          www.brunors.com
          • 2. Re: Backup with Data Protector is not working
            993635
            Hello,

            No disconnection at all.

            It doesn't work since a crash of the DP server during the DB backup.

            When we move the catalog on the same server as the DB, the backup works but if we set the catalog to an other server (like the original setting) it doesn't work and we don't know why.

            It seems that when a backup is launched thru Data Protector, RMAN can't find the DB catalog. But if we run (manually) the RMAN command that DP used to do a backup, it works...