Oracle Agent not working - RMAN script returns error

[Hans_Peter_Klau]

Hello,

is anybody using the Oracle Agent of BE 11d on Windows Server 2003 and Oracle 9.2?

Authentication etc is all right, error message says that the script returns an error.

Executing the script manually on the RMAN command prompt isn't working either.

Does anybody have the same problem?

Phoned three hours with Symantec Support and they don't know... The developers are looking for the mistake...

Any ideas??

[Simon_1976]

I tested RMAN backup and restore on oracle 9.2 and windows 2000. all jobs work well, so can you show us the RMAN script and the error message?

[Hans_Peter_Klau]

Simon,

here is the log - I'm sorry it's in German...
I hope you'll understand the error massage...


Das Datenbankskript gab einen Fehler zur�ck. Details finden Sie im Abschnitt f�r die Skriptausgabe in den Auftragsprotokollen.
RMAN-Ausgabe Recovery Manager: Version 9.2.0.5.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.


# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------

RUN {
ALLOCATE CHANNEL ch0
TYPE 'SBT_TAPE';
SEND 'BSA_SERVICE_HOST=,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={3D15934D-99EF-4671-9C2B-8BF862B8FB01},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\\';
BACKUP
INCREMENTAL LEVEL=0
FORMAT 'BE_U'
TABLESPACE
'TOOLS',
'UNDO' FORCE;
BACKUP CURRENT CONTROLFILE
FORMAT 'BE_U';

RELEASE CHANNEL ch0;
}

Mit Ziel-Datenbank verbunden: (DBID=3097229433)

Kontrolldatei der Zieldatenbank wird anstelle des Recovery-Katalogs verwendet
Zugewiesener Kanal: ch0
Kanal ch0: SID=10 Ger�tetyp=SBT_TAPE
Kanal ch0: Symantec/BackupExec/1.1.0

Befehl an Kanal gesandt: ch0

Starten backup um 01.12.06
Kanal ch0: Backup-Satz f�r Datendatei wird begonnen incremental level 0
Kanal ch0: Datendatei wird in Backup-Satz einbezogen
Eingabe-Datendatei fno=00002 Name=
Eingabe-Datendatei fno=00003 Name=
Kanal ch0: Piece 1 wird auf 01.12.06 begonnen
Freigegebener Kanal: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch0 channel at 12/01/2006 15:19:25
ORA-19506: Fehler beim Erstellen der sequentiellen Datei, Name="BE_07i3s8ns_1_1", Parameter=""
ORA-27028: skgfqcre: sbtbackup hat Fehler zur�ckgegeben
ORA-19511: Fehler von Media Manager-Ebene empfangen, Fehlertext:

Recovery Manager abgeschlossen.

Erreichte Ger�te: 1
Genutzte Datenstr�me: 0


Abschlussstatus: Fehlgeschlagen
Endg�ltiger Fehler: 0xe0000340 - Das Datenbankskript gab einen Fehler zur�ck. Details finden Sie im Abschnitt f�r die Skriptausgabe in den Auftragsprotokollen.
Endg�ltige Fehlerkategorie: Ressourcenfehler

Zus�tzliche Informationen zu diesem Fehler finden Sie unter der Verkn�pfung V-79-57344-832

[Simon_1976]

I guess the error message you got is �Failed to load media management library�.

To resolve this issue, you can:

1, try to reinstall the remote agent to update the MML of oracle.
2, check the credentials of the user account used to backup the oracle database, try in-build administrator if you can.

[Hans_Peter_Klau]

Hi,

yes - Failed to load...

1) Already re-installed the agent several times...

2) Credentials are correct

As I already mentiones phoned already with Symantec support and they don't know either.

[Asma_Tamboli]

Hallo,

Please ensure that you have entered the oracle servername and the account details in Tools> Options > Oracle > Modify List.

Is the automatic logging enabled in the database and is the database mode set to archived logging?

Also, could you try running the skript mentioned in the job log over Rman? (with help of an oracle Admin)

Also, are you using a RAC? Is oracle on a windows platform?

Thanks!

[Hans_Peter_Klau]

With Hot Fix 2 Oracle Agent is working except of the archive logs

same problem as posted in a newer thread...
any suggestions?

[Martin_Sitte]

I have about the same problem but Hotfix 2 did not resolve it.

Recovery Manager: Version 9.2.0.7.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.


# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------

RUN {
ALLOCATE CHANNEL ch0
TYPE 'SBT_TAPE';
SEND 'BSA_SERVICE_HOST=172.16.210.29,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={6C2113E9-2AA5-4354-B6D7-46F3AB935616},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\vctst02.tv.vkb.at\tstvzent';
BACKUP
INCREMENTAL LEVEL=0
FORMAT 'BE_U'
DATABASE FORCE PLUS ARCHIVELOG FORCE;
BACKUP CURRENT CONTROLFILE
FORMAT 'BE_U';

RELEASE CHANNEL ch0;
}

Mit Ziel-Datenbank verbunden: TSTVZENT (DBID=2197985747)

Kontrolldatei der Zieldatenbank wird anstelle des Recovery-Katalogs verwendet
Zugewiesener Kanal: ch0
Kanal ch0: SID=20 Ger�tetyp=SBT_TAPE
Kanal ch0: Symantec/BackupExec/1.1.0

Befehl an Kanal gesandt: ch0


Starten backup um 11.12.06
Aktuelles Log archiviert
Kanal ch0: Backup-Satz f�r archiviertes Log wird begonnen
Kanal ch0: Archivierte Logs in Backup-Satz werden angegeben
Eingabe-Archive-Log-Thread=1 Sequenz=75892 Recid=75871 Stempel=607430901
Eingabe-Archive-Log-Thread=1 Sequenz=75893 Recid=75872 Stempel=607438972
Eingabe-Archive-Log-Thread=1 Sequenz=75894 Recid=75873 Stempel=607447041
Eingabe-Archive-Log-Thread=1 Sequenz=75895 Recid=75874 Stempel=607455081
Eingabe-Archive-Log-Thread=1 Sequenz=75896 Recid=75875 Stempel=607463181
Eingabe-Archive-Log-Thread=1 Sequenz=75897 Recid=75876 Stempel=607471281
Eingabe-Archive-Log-Thread=1 Sequenz=75898 Recid=75877 Stempel=607479141
Eingabe-Archive-Log-Thread=1 Sequenz=75899 Recid=75878 Stempel=607479601
Eingabe-Archive-Log-Thread=1 Sequenz=75900 Recid=75879 Stempel=607479604
Eingabe-Archive-Log-Thread=1 Sequenz=75901 Recid=75880 Stempel=607479605
Eingabe-Archive-Log-Thread=1 Sequenz=75902 Recid=75881 Stempel=607479608
Eingabe-Archive-Log-Thread=1 Sequenz=75903 Recid=75882 Stempel=607479608
Eingabe-Archive-Log-Thread=1 Sequenz=75904 Recid=75883 Stempel=607479609
Eingabe-Archive-Log-Thread=1 Sequenz=75905 Recid=75884 Stempel=607482651
Eingabe-Archive-Log-Thread=1 Sequenz=75906 Recid=75885 Stempel=607490051
Eingabe-Archive-Log-Thread=1 Sequenz=75907 Recid=75886 Stempel=607490062
Eingabe-Archive-Log-Thread=1 Sequenz=75908 Recid=75887 Stempel=607491231
Eingabe-Archive-Log-Thread=1 Sequenz=75909 Recid=75888 Stempel=607494527
Eingabe-Archive-Log-Thread=1 Sequenz=75910 Recid=75889 Stempel=607500351
Eingabe-Archive-Log-Thread=1 Sequenz=75911 Recid=75890 Stempel=607508421
Eingabe-Archive-Log-Thread=1 Sequenz=75912 Recid=75891 Stempel=607516491
Eingabe-Archive-Log-Thread=1 Sequenz=75913 Recid=75892 Stempel=607524442
Eingabe-Archive-Log-Thread=1 Sequenz=75914 Recid=75893 Stempel=607532362
Eingabe-Archive-Log-Thread=1 Sequenz=75915 Recid=75894 Stempel=607540491
Eingabe-Archive-Log-Thread=1 Sequenz=75916 Recid=75895 Stempel=607548561
Eingabe-Archive-Log-Thread=1 Sequenz=75917 Recid=75896 Stempel=607555223
Eingabe-Archive-Log-Thread=1 Sequenz=75918 Recid=75897 Stempel=607555224
Eingabe-Archive-Log-Thread=1 Sequenz=75919 Recid=75898 Stempel=607555273
Eingabe-Archive-Log-Thread=1 Sequenz=75920 Recid=75899 Stempel=607559721
Eingabe-Archive-Log-Thread=1 Sequenz=75921 Recid=75900 Stempel=607566000
Eingabe-Archive-Log-Thread=1 Sequenz=75922 Recid=75901 Stempel=607566001
Eingabe-Archive-Log-Thread=1 Sequenz=75923 Recid=75902 Stempel=607566002
Eingabe-Archive-Log-Thread=1 Sequenz=75924 Recid=75903 Stempel=607566003
Eingabe-Archive-Log-Thread=1 Sequenz=75925 Recid=75904 Stempel=607566004
Eingabe-Archive-Log-Thread=1 Sequenz=75926 Recid=75905 Stempel=607566005
Eingabe-Archive-Log-Thread=1 Sequenz=75927 Recid=75906 Stempel=607566005
Eingabe-Archive-Log-Thread=1 Sequenz=75928 Recid=75907 Stempel=607571110
Eingabe-Archive-Log-Thread=1 Sequenz=75929 Recid=75908 Stempel=607578261
Eingabe-Archive-Log-Thread=1 Sequenz=75930 Recid=75909 Stempel=607580084
Eingabe-Archive-Log-Thread=1 Sequenz=75931 Recid=75910 Stempel=607580084
Eingabe-Archive-Log-Thread=1 Sequenz=75932 Recid=75911 Stempel=607581710
Eingabe-Archive-Log-Thread=1 Sequenz=75933 Recid=75912 Stempel=607589391
Eingabe-Archive-Log-Thread=1 Sequenz=75934 Recid=75913 Stempel=607596296
Eingabe-Archive-Log-Thread=1 Sequenz=75935 Recid=75914 Stempel=607596298
Eingabe-Archive-Log-Thread=1 Sequenz=75936 Recid=75915 Stempel=607596519
Eingabe-Archive-Log-Thread=1 Sequenz=75937 Recid=75916 Stempel=607601872
Eingabe-Archive-Log-Thread=1 Sequenz=75938 Recid=75917 Stempel=607609401
Eingabe-Archive-Log-Thread=1 Sequenz=75939 Recid=75918 Stempel=607616553
Eingabe-Archive-Log-Thread=1 Sequenz=75940 Recid=75919 Stempel=607623263
Eingabe-Archive-Log-Thread=1 Sequenz=75941 Recid=75920 Stempel=607628361
Eingabe-Archive-Log-Thread=1 Sequenz=75942 Recid=75921 Stempel=607634931
Eingabe-Archive-Log-Thread=1 Sequenz=75943 Recid=75922 Stempel=607676647
Eingabe-Archive-Log-Thread=1 Sequenz=75944 Recid=75923 Stempel=607679598
Eingabe-Archive-Log-Thread=1 Sequenz=75945 Recid=75924 Stempel=607681706
Eingabe-Archive-Log-Thread=1 Sequenz=75946 Recid=75925 Stempel=607684098
Eingabe-Archive-Log-Thread=1 Sequenz=75947 Recid=75926 Stempel=607688247
Eingabe-Archive-Log-Thread=1 Sequenz=75948 Recid=75927 Stempel=607695348
Eingabe-Archive-Log-Thread=1 Sequenz=75949 Recid=75928 Stempel=607702061
Eingabe-Archive-Log-Thread=1 Sequenz=75950 Recid=75929 Stempel=607708751
Eingabe-Archive-Log-Thread=1 Sequenz=75951 Recid=75930 Stempel=607716491
Eingabe-Archive-Log-Thread=1 Sequenz=75952 Recid=75931 Stempel=607724321
Eingabe-Archive-Log-Thread=1 Sequenz=75953 Recid=75932 Stempel=607732331
Kanal ch0: Piece 1 wird auf 11.12.06 begonnen
Freigegebener Kanal: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/11/2006 14:37:43
ORA-19506: Fehler beim Erstellen der sequentiellen Datei, Name="BE_06i4mi1m_1_1", Parameter=""
ORA-27028: skgfqcre: sbtbackup hat Fehler zur�ckgegeben
ORA-19511: Fehler von Media Manager-Ebene empfangen, Fehlertext:

Recovery Manager abgeschlossen.

Any suggestions?

[Alex_Cheung]

run {
allocate auxiliary channel ch1 device type sbt;
duplicate target database to nofilenamecheck;
}

restoring datafile 00054 to +DATA/fh2005.ora
restoring datafile 00055 to +DATA/fh2006.ora
restoring datafile 00056 to +DATA/fh2007.ora
restoring datafile 00057 to +DATA/fh2008.ora
restoring datafile 00058 to +DATA/fh2009.ora
restoring datafile 00059 to +DATA/fh2010.ora
restoring datafile 00060 to +DATA/fh_rest.ora
restoring datafile 00061 to +INDEX/datafile/arz8_ix1.275.607021069
channel ch1: reading from backup piece BE_1ui3kk7i_1_1
ORA-19870: error reading backup piece BE_1ui3kk7i_1_1
ORA-19507: failed to retrieve sequential file, handle="BE_1ui3kk7i_1_1", parms=
"
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001501) The specified backup object was not found in Backup Exec
catalogs.

failover to previous backup

released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/11/2006 09:41:59
RMAN-03015: error occurred in stored script Memory Script

It seems to me the errors come from the media manager layer. It is hard to get support from Symantec Support as I tried two days to contact them. Email first and phone is on hold.

Alex Cheung

[Stefan_Greder]

Hello

I have the same Products and the same Problem!

Does anybody have some interesting news to this problem?

thank you!

Stefan

[ockilee]

Hi there,

I have also this problem.

Has anybody a solution for the Problem ?

Thanks in advance!

Martin

[Marc_O1]

Hi there,

I have the same problem to.
The support suggest to try the sys-account of oracle. In some cases, it should be working. In my case it doesn't.
The problem is known by Symantec.

The article says: There are no plans to address this issue by way of a patch or hotfix in the current or previous versions of the software at the present time. However, the issue is currently scheduled to be addressed in the next major revision of the product.

This is not acceptable. We had bought an oracle agent of BE 11d. We want to use it, not to buy and use the agent of a later version, maybe version 12.
Symantec should give the coustumers the security, that a patch will come (very) soon.

Have a nice day
Marc'O