cancel
Showing results for 
Search instead for 
Did you mean: 

oracle backup always fail with this error

sjm
Level 2
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=10.100.10.10,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={A90BB09D-14E9-4FE1-A5CB-4165FED7A3F7},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\STYKKI\ORCL'; 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('9/20/2007 22:5:20', 'MM/DD/YYYY HH24:MI:SS')"; BACKUP CURRENT CONTROLFILE      FORMAT 'BE_U';  RELEASE CHANNEL ch0; } RMAN-06005: connected to target database: ORCL (DBID=1034228659)RMAN-06009: using target database controlfile instead of recovery catalogRMAN-03022: compiling command: allocateRMAN-03023: executing command: allocateRMAN-08030: allocated channel: ch0RMAN-08500: channel ch0: sid=26 devtype=SBT_TAPERMAN-08526: channel ch0: Symantec/BackupExec/1.1.0RMAN-03022: compiling command: sendRMAN-06421: sent command to channel: ch0RMAN-03022: compiling command: backupRMAN-03023: executing command: backupRMAN-08008: channel ch0: starting incremental level 0 datafile backupsetRMAN-08502: set_count=12 set_stamp=633823525 creation_time=20.09.2007RMAN-08010: channel ch0: specifying datafile(s) in backupsetRMAN-08522: input datafile fno=00008 name=G:\ORACLE\ORADATA\ORCL\GL_SAGA_DATA01.ORARMAN-08522: input datafile fno=00009 name=G:\ORACLE\ORADATA\ORCL\GL_SAGA_DATA02.ORARMAN-08522: input datafile fno=00010 name=G:\ORACLE\ORADATA\ORCL\GL_SAGA_DATA03.ORARMAN-08522: input datafile fno=00018 name=G:\ORACLE\ORADATA\ORCL\EMR_BLOB01.ORARMAN-08522: input datafile fno=00002 name=G:\ORACLE\ORADATA\ORCL\RBS01.DBFRMAN-08522: input datafile fno=00011 name=F:\ORACLE\ORADATA\ORCL\GL_SAGA_INDEX01.ORARMAN-08522: input datafile fno=00012 name=F:\ORACLE\ORADATA\ORCL\GL_SAGA_INDEX02.ORARMAN-08522: input datafile fno=00013 name=F:\ORACLE\ORADATA\ORCL\GL_SAGA_INDEX03.ORARMAN-08522: input datafile fno=00001 name=G:\ORACLE\ORADATA\ORCL\SYSTEM01.DBFRMAN-08011: including current controlfile in backupsetRMAN-08522: input datafile fno=00014 name=G:\ORACLE\ORADATA\ORCL\GL_SAGA_STATIC01.ORARMAN-08522: input datafile fno=00015 name=G:\ORACLE\ORADATA\ORCL\TEMPORARY_DATA01.ORARMAN-08522: input datafile fno=00016 name=F:\ORACLE\ORADATA\ORCL\GL_MONSTER01.ORARMAN-08522: input datafile fno=00019 name=G:\ORACLE\ORADATA\ORCL\TH_MORE_LOB01.DBFRMAN-08522: input datafile fno=00017 name=G:\ORACLE\ORADATA\ORCL\EMR_DAX01.ORARMAN-08522: input datafile fno=00003 name=G:\ORACLE\ORADATA\ORCL\USERS01.DBFRMAN-08522: input datafile fno=00004 name=G:\ORACLE\ORADATA\ORCL\TEMP01.DBFRMAN-08522: input datafile fno=00006 name=G:\ORACLE\ORADATA\ORCL\INDX01.DBFRMAN-08522: input datafile fno=00007 name=G:\ORACLE\ORADATA\ORCL\DR01.DBFRMAN-08522: input datafile fno=00005 name=G:\ORACLE\ORADATA\ORCL\TOOLS01.DBFRMAN-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.BACKUPPIECECREATERecovery Manager complete.


Devices acquired: 1
Data streams used: 0
3 REPLIES 3

Ben_L_
Level 6
Employee
sjm,

Can you run both of these commands from rman and let me know the results?

Command one:
RMAN> run {
2> allocate channel ch0 type SBT;
3> backup database;
4> }

Command two:

RMAN> run {
2> allocate channel ch0 type DISK;
3> backup database;
4> }

sjm
Level 2
Hi Ben
 
Here are the results from these commands you send me
 
RMAN> {
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
 

RMAN> {
2> allocate channel ch0 type disk;
3> backup database
4> }
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: "archivelog, backup, back
upset, channel, controlfilecopy, current, database, datafile, datafilecopy, dele
te, diskratio, filesperset, format, include, (, parms, pool, ;, skip, setsize, t
ablespace, tag"
RMAN-01007: at line 4 column 1 file: standard input
 
regards
Sigurjon Magnusson

Ben_L_
Level 6
Employee
sjm,

Since both of these failed your issue is going to be on the Oracle server not in BE.  If the first command did not run, and the second one did that would of told me it is just a problem with the AgentConfig. Since neither of them will run you will need to contact Oracle or your person that handles Oracle to get that resolved. 

Just to explain those commands if you did not know what they did.  The first one trys to run a backup and send it to Backup Exec. Then the second command tells Oracle to just run a backup to disk, without any interaction to Backup Exec.