Oracle Backup Error ORA-19624
I'm using Backup Exec 12.5 and have followed these steps to verify the media server and Oracle agent are configured correctly:
http://www.symantec.com/business/support/index?page=content&id=TECH49608
However when I attempt to backup an Oracle 8i database, I receive the following RMAN output:
Recovery Manager: Release 8.1.7.0.0 - Production
# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------
RUN {
ALLOCATE CHANNEL ch0
TYPE 'SBT_TAPE';
SEND 'BSA_SERVICE_HOST=131.167.81.7,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={CBCCB8D0-03EB-4E44-9DB5-5D1CAA038622},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\server\clean';
BACKUP
INCREMENTAL LEVEL=0
FORMAT 'BE_U'
DATABASE;
BACKUP
FORMAT 'BE_U'
ARCHIVELOG ALL;
sql "ALTER SYSTEM ARCHIVE LOG CURRENT";
BACKUP ARCHIVELOG FROM TIME "TO_DATE('1/28/2011 9:12:9', 'MM/DD/YYYY HH24:MI:SS')";
BACKUP CURRENT CONTROLFILE
FORMAT 'BE_U';
RELEASE CHANNEL ch0;
}
RMAN-06005: connected to target database: CLEAN (DBID=21337221)
RMAN-06009: using target database controlfile instead of recovery catalog
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch0
RMAN-08500: channel ch0: sid=17 devtype=SBT_TAPE
RMAN-08526: channel ch0: Symantec/BackupExec/1.1.0
RMAN-03022: compiling command: send
RMAN-06421: sent command to channel: ch0
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel ch0: starting incremental level 0 datafile backupset
RMAN-08502: set_count=7 set_stamp=741604331 creation_time=28-jan-2011 09:12
RMAN-08010: channel ch0: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00009 name=C:\ORACLE\ORADATA\CLEAN\LIMSINDEX.ORA
RMAN-08522: input datafile fno=00014 name=C:\ORACLE\ORADATA\CLEAN\LIMSAUDIT.ORA
RMAN-08522: input datafile fno=00001 name=C:\ORACLE\ORADATA\CLEAN\SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00004 name=C:\ORACLE\ORADATA\CLEAN\TEMP01.DBF
RMAN-08522: input datafile fno=00008 name=C:\ORACLE\ORADATA\CLEAN\LIMSTABLE.ORA
RMAN-08522: input datafile fno=00013 name=C:\ORACLE\ORADATA\CLEAN\LIMSRESULT.ORA
RMAN-08522: input datafile fno=00002 name=C:\ORACLE\ORADATA\CLEAN\RBS01.DBF
RMAN-08522: input datafile fno=00003 name=C:\ORACLE\ORADATA\CLEAN\USERS01.DBF
RMAN-08522: input datafile fno=00006 name=C:\ORACLE\ORADATA\CLEAN\INDX01.DBF
RMAN-08522: input datafile fno=00007 name=C:\ORACLE\ORADATA\CLEAN\DR01.DBF
RMAN-08522: input datafile fno=00015 name=C:\ORACLE\ORADATA\CLEAN\LIMSHISTORY.ORA
RMAN-08522: input datafile fno=00011 name=C:\ORACLE\ORADATA\CLEAN\LIMSALIQUOT.ORA
RMAN-08522: input datafile fno=00005 name=C:\ORACLE\ORADATA\CLEAN\TOOLS01.DBF
RMAN-08522: input datafile fno=00010 name=C:\ORACLE\ORADATA\CLEAN\LIMSSAMPLE.ORA
RMAN-08522: input datafile fno=00012 name=C:\ORACLE\ORADATA\CLEAN\LIMSTEST.ORA
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel ch0
RMAN-10032: unhandled exception during execution of job step 1:
RMAN-10035: exception raised in RPC: ORA-19624: operation f
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
Recovery Manager complete.
I'm able to backup directly to DISK using RMAN:
run {
allocate channel ch0 type DISK;
backup database;
}
When I run the SBT command, I receive the following error:
RMAN> run {
2> allocate channel ch0 type SBT;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "double-quoted-s
tring, disk, equal, single-quoted-string"
RMAN-01008: the bad identifier was: SBT
RMAN-01007: at line 2 column 27 file: standard input
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found ";": expecting one of: "allocate, alter, beginli
ne, catalog, change, connect, create, crosscheck, configure, debug, delete, drop
, exit, endinline, host, {, library, list, mount, open, print, register, release
, replace, report, renormalize, reset, resync, rman, rpct∙↕"
RMAN-01007: at line 2 column 30 file: standard input
Since the Backup Exec log cuts off the complete ORA-19624 error message, I'm unsure what the actual error is.
I've searched the forums and support site and am unable to locate a similar issue.
Any help would be greatly appreciated.
Thanks.
Hi
RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03007: retryable error occurred during execution of command: backupRMAN-07004: unhandled exception during command execution on channel ch0RMAN-10032: unhandled exception during execution of job step 1:RMAN-10035: exception raised in RPC: ORA-19624: operation fRMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATEPlease see the link below should fix the issuehttp://www.symantec.com/docs/TECH49608Please mark it solved if this resolve the issueThank You