RMAN-06004 PLS-00306: wrong number or types of arguments in call to 'GETDCBACKUPHISTORY'
(Doc ID 2605129.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
Rman backup fails when connected through catalog. But when rman connects directly the jobs run OK.
DBGSQL: RCVCAT> declare first boolean := FALSE;
bhistoryRec dbms_rcvman.bhistoryRec_t;
atAnyScn boolean := FALSE; +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
begin if (:first > 0) THEN first := TRUE; end if;
if (:atAnyScn > 0) THEN atAnyScn := TRUE; end if;
dbms_rcvman.getDcBackupHistory( backedUpDev => :devtype:devtype_i, first => first, bhistoryRec => bhistoryRec, doingCmd => :backup, keepTag => :tag, toDest1 => :todest1, toDest2 => :tod est2, toDest3 => :todest3, toDest4 => :todest4, atAnyScn => atAnyScn );
:fileno := bhistoryRec.dfNumber; :crescn := bhistoryRec.create_scn; :rlgscn := bhistoryRec.reset_s cn;
:rlgtime := bhistoryRec.reset_time; :ckpscn := bhistoryRec.ckp_scn; :nbackups := bhistoryRec.nbackups;
:compTime := bhistoryRec.compTime; end;
DBGSQL: sqlcode = 6550
DBGSQL: B :fileno = NULL
DBGSQL: B :crescn = NULL
DBGSQL: B :rlgscn = NULL
DBGSQL: B :rlgtime = NULL
DBGSQL: B :ckpscn = NULL
DBGSQL: B :nbackups = NULL
DBGSQL: B :compTime = NULL
DBGSQL: B :first = 1
DBGSQL: B :devtype = SBT_TAPE
DBGSQL: B :backup = B
DBGSQL: B :tag = NULL
DBGSQL: B :todest1 = NULL
DBGSQL: B :todest2 = NULL
DBGSQL: B :todest3 = NULL
DBGSQL: B :todest4 = NULL
DBGSQL: B :atAnyScn = 0
released channel: T1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/09/2019 10:27:58
RMAN-06004: ORACLE error from recovery catalog database: ORA-06550: line 1, column 211:
PLS-00306: wrong number or types of arguments in call to 'GETDCBACKUPHISTORY'
ORA-06550: line 1, column 211:
PL/SQL: Statement ignored
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |