This discussion is archived
2 Replies Latest reply: Feb 28, 2013 1:34 AM by 993635 RSS

Backup with Data Protector is not working

993635 Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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...

Legend

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