cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Backup Error ORA-19624

mmaitland
Level 2

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.

1 ACCEPTED SOLUTION

Accepted Solutions

itsmeaffinity
Level 6

Hi

 

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
 
 
Please see the link below should fix the issue
 
http://www.symantec.com/docs/TECH49608
 
Please mark it solved if this resolve the issue
 
Thank You

View solution in original post

3 REPLIES 3

itsmeaffinity
Level 6

Hi

 

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
 
 
Please see the link below should fix the issue
 
http://www.symantec.com/docs/TECH49608
 
Please mark it solved if this resolve the issue
 
Thank You

mmaitland
Level 2

Thanks for the quick response. I had thought I had configured the server and agent correctly using the doc you have linked, but the instructions aren't very explicit. After changing a few of the values in the agent utility, it backed up successfully.

For example when I added the media server IP address, I received an error. However when I used the media server name, it connected successfully. I believe the agent utility says either IP or server name can be used.

itsmeaffinity
Level 6

Hi

 

Yes with agent utility you have option to enter ip or name

 

Thanks your for your response on same

 

Cheers