Oracle KBRSI_ICD
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose This package provides in-database support for the Oracle ZFS Backup Appliance. It is not installed by default.

The phrase "Container Group" as used in this package refers to Backup Appliance Container Groups not to the Oracle 12c Container Database.
AUTHID CURRENT_USER
Data Types TYPE names$_t ...
Dependencies
ALL_USERS DBMS_STANDARD KBRSLIB
DBMS_ASSERT DBMS_UTILITY  
Dependencies Only STANDARD
Documented No
Exceptions
Error Code Reason
ORA-00439 Feature not enabled: recovery appliance is not enabled
ORA-19569 No device is allocated to this session
ORA-45155 The Recovery Appliance has not been installed
ORA-45279 Container group <container_group_name> not exist
First Available 12.1
Installation SQL> @?/rdbms/admin/dbmsrsicd.plb

SP2-0808: Package created with compilation warnings

Library created.

SQL> sho err
No errors.

SQL> @?/rdbms/admin/prvtrsicd.plb

SP2-0810: Package Body created with compilation warnings

SQL> sho err
Errors for PACKAGE BODY KBRSI_ICD:

LINE/COL ERROR
-------- -----------------------------------------------------------------
212/3 PLW-06006: uncalled procedure "PRINT" is removed.
365/27 PLW-06010: keyword "TYPE" used as a defined name
383/20 PLW-06010: keyword "TYPE" used as a defined name
526/24 PLW-07203: parameter 'USERNAME' may benefit from use of the NOCOPY compiler hint
527/24 PLW-07203: parameter 'PASSWORD' may benefit from use of the NOCOPYcompiler hint
528/24 PLW-07203: parameter 'URL' may benefit from use of the NOCOPY compiler hint
560/28 PLW-07203: parameter 'HOSTLST' may benefit from use of the NOCOPY compiler hint
638/27 PLW-07203: parameter 'FINCARN' may benefit from use of the NOCOPY compiler hint
664/23 PLW-07203: parameter 'OFNAME' may benefit from use of the NOCOPY compiler hint
690/25 PLW-07203: parameter 'OFNAME' may benefit from use of the NOCOPY compiler hint
761/32 PLW-06010: keyword "CONVERT" used as a defined name
770/28 PLW-06010: keyword "CONVERT" used as a defined name
903/28 PLW-06010: keyword "KEY" used as a defined name
916/24 PLW-06010: keyword "KEY" used as a defined name
932/27 PLW-06010: keyword "KEY" used as a defined name
1141/28 PLW-06010: keyword "VALUE" used as a defined name
1160/32 PLW-07203: parameter 'FNAME' may benefit from use of the NOCOPY compiler hint
1527/33 PLW-06010: keyword "FORCE" used as a defined name
1540/35 PLW-06010: keyword "FORCE" used as a defined name
1617/43 PLW-07203: parameter 'GNAME' may benefit from use of the NOCOPY compiler hint
1631/37 PLW-07203: parameter 'GNAME' may benefit from use of the NOCOPY compiler hint
1827/35 PLW-06010: keyword "NAME" used as a defined name
1828/35 PLW-06010: keyword "VALUE" used as a defined name
2027/21 PLW-06010: keyword "VALUE" used as a defined name
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/dbmsrsicd.plb
{ORACLE_HOME}/rdbms/admin/prvtrsicd.plb

See also dbmsrspreq.plb and recover.bsq
Subprograms
 
BA_ENABLED
Returns an exception if a Backup (Recovery) Appliance is not enabled kbrsi_icd.ba_enabled;
exec kbrsi_icd.ba_enabled
BEGIN kbrsi_icd.ba_enabled; END;
*
ERROR at line 1:
ORA-00439: feature not enabled: recovery appliance is not enabled
ORA-06512: at "SYS.KBRSI_ICD", line 1966
ORA-06512: at line 1
 
BSTAT (new 21c)
Undocumented kbrsi_icd.bstat(
indx IN  NUMBER,
cpu  OUT NUMBER,
ela  OUT NUMBER);
DECLARE
 ocpu NUMBER;
 oela NUMBER;
BEGIN
  kbrsi_icd.bstat(1, ocpu, oela);
  dbms_output.put_line(ocpu);
  dbms_output.put_line(oela);
END;
/
2067885
3141368347845

PL/SQL procedure successfully completed.
 
CONTAINER_BDAPI_CONFIG
Undocumented kbrsi_icd.container_bdapi_config(
name         IN VARCHAR2,
value        IN VARCHAR2,
delete_entry IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
 
CONTAINER_BDAPI_GTFB
Undocumented kbrsi_icd.container_bdapi_gtfb(
fbyte  IN  NUMBER,
ausize IN  NUMBER,
tbytes OUT NUMBER)
RETURN BINARY_INTEGER;
TBD
 
CONTAINER_BDAPI_RELOAD_CONFIG
Undocumented kbrsi_icd.container_bdapi_reload_config RETURN BINARY_INTEGER;
SELECT kbrsi_icd.container_bdapi_reload_config
FROM dual;
SELECT kbrsi_icd.container_bdapi_reload_config
*
ERROR at line 1:
ORA-45275: container: 'ZDLRA metadata is not installed/initialized'
ORA-06512: at "SYS.KBRSI_ICD", line 1814
 
CONTAINER_BDAPI_SETTRACE
Undocumented kbrsi_icd.container_bdapi_settrace(
trclvldsk IN BINARY_INTEGER,
trclvlmem IN BINARY_INTEGER,
scope     IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
SELECT kbrsi_icd.container_bdapi_settrace(1, 1, 1)
FROM dual;
SELECT kbrsi_icd.container_bdapi_settrace(1, 1, 1)
*
ERROR at line 1:
ORA-45275: container: 'ZDLRA metadata is not installed/initialized'
ORA-06512: at "SYS.KBRSI_ICD", line 1795
ORA-06512: at line 1
 
CONTAINER_BDAPI_TEST
Undocumented kbrsi_icd.container_bdapi_test(
testcode  IN  BINARY_INTEGER,
tstvalin  IN  BINARY_INTEGER,
ti_ub4_1  IN  BINARY_INTEGER,
ti_ub4_2  IN  BINARY_INTEGER,
ti_ub4_3  IN  BINARY_INTEGER,
ti_ub4_4  IN  BINARY_INTEGER,
tstvalout OUT BINARY_INTEGER,
apiver    OUT BINARY_INTEGER,
to_ub4_1  OUT BINARY_INTEGER,
to_ub4_2  OUT BINARY_INTEGER,
to_ub4_3  OUT BINARY_INTEGER,
to_ub4_4  OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
 
CONTAINER_SYSTEM_INIT
Undocumented

This init procedure performed the reported disconnect.
kbrsi_icd.container_system_init;
exec kbrsi_icd.container_system_init;
ERROR:
ORA-03114: not connected to ORACLE
BEGIN kbrsi_icd.container_system_init; END;
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 42937
Session ID: 214 Serial number: 50951
 
CREATE_CONTAINER
Create a Backup Appliance Container kbrsi_icd.create_container(
gname IN VARCHAR2,
bytes IN VARCHAR2,
dest  IN VARCHAR2);
TBD
 
CREATE_CONTAINER_GROUP
Create a Backup Appliance Container Group kbrsi_icd.create_container_group(gname IN VARCHAR2);
ALTER SESSION SET tracefile_identifier = 'test_plan1';

Session altered.

ALTER SESSION SET EVENTS '1004trace name context forever, level 12';

Session altered.

exec kbrsi_icd.create_container_group('UWCONTGRP');
BEGIN kbrsi_icd.create_container_group('UWCONTGRP'); END;
*
ERROR at line 1:
ORA-45285: Cannot create more than 0 container groups.
ORA-06512: at "SYS.KBRSI_ICD", line 1492
ORA-06512: at "SYS.KBRSI_ICD", line 1503
ORA-06512: at line 1


ALTER SESSION SET EVENTS '1004trace name context OFF';

-- here is the relevant trace output giving an indicatiuon of what may be coming in a future release.
-- reformated to make the output eaier to read.

SELECT obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2, spare3, signature, spare7, spare8, spare9, NVL(dflcollid,16382), creappid, creverid, modappid, modverid, crepatchid, modpatchid
FROM obj$
WHERE owner#=:1
AND name=:2
AND namespace=:3
AND remoteowner IS NULL
AND linkname IS NULL
AND subname IS NULL;

SELECT t.ts#, t.file#, t.block#, NVL(t.bobj#,0), NVL(t.tab#,0), t.intcols, NVL(t.clucols,0), t.flags,t.pctfree$, t.pctused$,t.initrans, t.maxtrans,
t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols,t.property, NVL(t.degree,1), NVL(t.instances,1),
t.avgspc_flb, t.flbcnt, t.kernelcols, NVL(t.trigflag,0), NVL(t.spare1,0), NVL(t.spare2,0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread, ts.im_imcu_count, ts.im_block_count, ts.im_sys_incarnation, ts.im_stat_update_time, ts.scanrate, NVL(t.acdrflags,0), NVL(t.acdrtsobj#,0), t.acdrdefaulttime, NVL(t.acdrrowtsintcol#,0)
FROM tab$ t, tab_stats$ ts
WHERE t.obj#= :1
AND t.obj# = ts.obj#(+);

SELECT NVL(MAX(amrv_key),0)
FROM amrv$;
WHERE gname = :bv_gname
AND doneid=0;
-- amrv$ is defined in $ORACLE_HOME/rdbms/admin/catcont.sql and referenced in recover.bsq

SELECT NVL(max(1),0)
FROM amgrp$
WHERE gname = :bv_gname;
--this table is also defined in catcont.sql


SELECT MIN(nextkey)
FROM (
  SELECT gid, gid+1 nextkey, LEAD(gid,1,0) OVER (ORDER BY gid) nextval
  FROM (
    SELECT gid
    FROM amgrp$
    UNION
    SELECT 0
    FROM dual)
     )
WHERE nextkey <> nextval;
 
DELETEBPSBT
Undocumented kbrsi_icd.deleteBpsbt(handle IN VARCHAR2);
exec kbrsi_icd.deleteBpsbt('TEST');
BEGIN kbrsi_icd.deleteBpsbt('TEST'); END;
*
ERROR at line 1:
ORA-19569: no device is allocated to this session
ORA-06512: at "SYS.KBRSI_ICD", line 1209
ORA-06512: at line 1
 
DELETE_KRBPD
Undocumented kbrsi_icd.delete_krbpd(
dbid    IN NUMBER,
fno     IN NUMBER,
fname   IN VARCHAR2,
ilevel  IN NUMBER,
blksize IN NUMBER);
TBD
 
DG_BACKEDUP
Undocumented but may relate to Data Guard kbrsi_icd.dg_backedup(
dbid      IN NUMBER,
fname     IN VARCHAR2,
complete  IN NUMBER,
krsp_code IN NUMBER);
TBD
 
DG_BACKUP_LOG (new 21c)
Undocumented kbrsi_icd.dg_backup_log(
P_CTKEY     IN NUMBER,
P_FINAL_SCN IN NUMBER,
P_COMPLETE  IN BOOLEAN,
P_RETRY     IN BOOLEAN);
TBD
 
DG_FIND_CT_KEY (new 21c)
Undocumented kbrsi_icd.dg_find_ct_key(
P_DBID       IN NUMBER,
P_TKEY       IN NUMBER,
P_RESET_SCN  IN NUMBER,
P_RESET_TIME IN NUMBER,
P_THREAD     IN NUMBER,
P_SEQUENCE   IN NUMBER)
RETURN NUMBER;
TBD
 
DG_GET_PLATFORM_ID (new 21c)
Undocumented kbrsi_icd.dg_get_platform_id(
p_dbid IN NUMBER,
p_tkey IN NUMBER)
RETURN BINARY_INTEGER;
SELECT kbrsi_icd.dg_get_platform_id(2140826538, 1)
FROM dual;
SELECT kbrsi_icd.dg_get_platform_id(2140826538, 1)
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kbrsosqlerr-program-error], [], [], [], [], [], [], [], [], [], [], []
ORA-45199: Error ORA-06550: line 1, column 23:
PLS-00201: identifier 'DBMS_RA_MISC.DG_GET_PLATFORM_ID' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
encountered when executing BEGIN :platform_id := dbms_ra_misc.dg_get_platform_id(:dbid, :tkey); END;.
ORA-06512: at "SYS.KBRSI_ICD", line 2151
 
DG_IS_DB_OK (new 21c)
Undocumented kbrsi_icd.dg_is_db_ok(
P_DBID IN NUMBER,
P_TKEY IN NUMBER)
RETURN BINARY_INTEGER;
SELECT kbrsi_icd.dg_is_db_ok(2140826538, 1)
FROM dual;
SELECT kbrsi_icd.dg_is_db_ok(2140826538, 1)
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kbrsosqlerr-program-error], [], [], [], [], [], [], [], [], [], [], []
ORA-45199: Error ORA-06550: line 1, column 18:
PLS-00201: identifier 'DBMS_RA_MISC.DG_IS_DB_OK' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
encountered when executing BEGIN :status := dbms_ra_misc.dg_is_db_ok(:dbid, :tkey); END;.
ORA-06512: at "SYS.KBRSI_ICD", line 2136
 
DG_NAME_LOG (new 21c)
Undocumented kbrsi_icd.dg_name_log(
P_CTKEY IN NUMBER,
P_FNAME IN VARCHAR2);
TBD
 
DG_NEW_LOG (new 21c)
Undocumented kbrsi_icd.dg_new_log(
P_DBID       IN  NUMBER,
P_TKEY       IN  NUMBER,
P_RESET_SCN  IN  NUMBER,
P_RESET_TIME IN  NUMBER,
P_THREAD     IN  NUMBER,
P_SEQUENCE   IN  NUMBER,
P_SIZE       IN  NUMBER,
P_LIVE_REDO  IN  BOOLEAN,
P_CTKEY      OUT NUMBER,
P_SLKEY      OUT NUMBER)
RETURN BINARY_INTEGER;
TBD
 
DG_PROCESS_PARTIAL (new 21c)
Undocumented kbrsi_icd.dg_process_partial(fname IN VARCHAR2);
exec kbrsi_icd.dg_process_partial('TestFileName');

PL/SQL procedure successfully completed.
 
DG_UPGRADE (new 21c)
Undocumented kbrsi_icd.dg_upgrade;
exec kbrsi_icd.dg_upgrade;

PL/SQL procedure successfully completed.
 
DROP_CONTAINER_GROUP
Drops a Backup Appliance Container kbrsi_icd.drop_container_group(
gname          IN VARCHAR2,
force          IN NUMBER,
keep_container IN NUMBER);
-- intentionally chose a container group name that could not possibly exist
exec kbrsi_icd.drop_container_group('ZZYZX', 0, 1);
BEGIN kbrsi_icd.drop_container_group('ZZYZX', 0, 1); END;
*
ERROR at line 1:
ORA-45275: container: 'ZDLRA metadata is not installed/initialized'
ORA-06512: at "SYS.KBRSI_ICD", line 1525
ORA-06512: at "SYS.KBRSI_ICD", line 1543
ORA-06512: at line 1
 
ENC_MKKEY (new 21c)
Undocumented kbrsi_icd.enc_mkkey(
ALIAS_FOR_TDE_PW IN VARCHAR2,
TAG              IN VARCHAR2,
BACKUP_FNAME     IN VARCHAR2);
TBD
 
ESTAT (new 21c)
Undocumented kbrsi_icd.estat(
ALIAS_FOR_TDE_PW IN VARCHAR2,
TAG              IN VARCHAR2,
BACKUP_FNAME     IN VARCHAR2);
TBD
 
FILEEXISTS
Returns 1 if a file exists: Otherwise 0 kbrsi_icd.fileExists(fname IN VARCHAR2)
RETURN BINARY_INTEGER;
SELECT kbrsi_icd.fileExists('ZZYZX')
FROM dual;

KBRSI_ICD.FILEEXISTS('ZZYZX')
-----------------------------
                            0
 
FIXUP_KBRSCB (new 21c)
Undocumented kbrsi_icd.fixup_kbrscb(
fname   IN VARCHAR2,
fsize   IN NUMBER,
blksize IN NUMBER,
dfkey   IN NUMBER,
chunkno IN NUMBER);
TBD
 
GETVERIFIER
Undocumented kbrsi_icd.getVerifier RETURN VARCHAR2;
SELECT kbrsi_icd.getverifier
FROM dual;

GETVERIFIER
-------------------------------------------------------------------------------------
UzpGMUJEOEZCNUExOTBDRUJDOTVGMTdDQzk2OEYxN0Y4QUQ2MTgwNzhBRUJGQkZCNjc0NzYzQzJFN0JGRUU=
 
INIT_MATCH (new 21c)
Undocumented kbrsi_icd.init_match(
DFKEY   IN NUMBER,
CKPID   IN NUMBER,
BLKSIZE IN NUMBER);
TBD
 
ISORSALIVE
Appears to raise an exception if an Oracle Recovery Appliance is not configured and available kbrsi_icd.isOrsaLive RETURN BOOLEAN;
BEGIN
  IF kbrsi_icd.isOrsaLive THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
BEGIN
*
ERROR at line 1:
ORA-45155: The Recovery Appliance has not been installed.
ORA-06512: at "SYS.KBRSI_ICD", line 247
ORA-06512: at "SYS.KBRSI_ICD", line 1453
ORA-06512: at line 2
 
READIO_TEST
Tests read I/O performance to a Oracle Backup Appliance kbrsi_icd.readIO_test(
filename      IN  VARCHAR2,
filesize      IN  VARCHAR2,
chunksize     IN  VARCHAR2,
containerread IN  BOOLEAN,
cputime       OUT NUMBER)
RETURN NUMBER;
TBD
 
REBUILD_CONTAINER_GROUP
Rebuilds a Backup Appliance Container Group kbrsi_icd.rebuild_container_group(
pathlist IN  VARCHAR2,
gname    OUT VARCHAR2,
amrvkey  OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
 
REMOVE_CONTAINERS
Remove Backup Appliance Containers kbrsi_icd.remove_containers(
pathlist IN  VARCHAR2
gname    IN  VARCHAR2
amrvkey  OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
 
REPAIR_CHUNKS
Undocumented kbrsi_icd.repair_chunks(dbkey IN NUMBER);
TBD
 
REPAIR_CONTAINER_GROUP
Undocumented kbrsi_icd.repair_container_group(
gname   IN  VARCHAR2
amrvkey OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
 
REPAIR_VBDF
Undocumented kbrsi_icd.repair_vbdf(
dfkey IN NUMBER,
cno   IN NUMBER);
TBD
 
RESTORESBTTASK
Undocumented kbrsi_icd.restoreBTTask(
reqid  IN NUMBER,
handle IN VARCHAR2);
TBD
 
RESTORESTOPTASK
Undocumented kbrsi_icd.restoreOpTask(requid IN NUMBER);
TBD
 
RESTOREVBTASK
Undocumented kbrsi_icd.restoreVBTask(
reqid IN NUMBER,
bpkey IN NUMBER);
TBD
 
RSADDTOSBTCATALOG
Undocumented kbrsi_icd.rsAddToSBTCatalog(
bpkey        IN NUMBER,
dbver        IN NUMBER,
dbname       IN VARCHAR2,
dbid         IN NUMBER,
handle       IN VARCHAR2,
setstamp     IN NUMBER,
setcount     IN NUMBER,
pieceno      IN NUMBER,
pieceblksize IN NUMBER,
tag          IN VARCHAR2,
bstyp        IN NUMBER);
TBD
 
RSAPILOCK
Undocumented kbrsi_icd.rsapiLock RETURN BOOLEAN;
BEGIN
  IF kbrsi_icd.rsapiLock THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F
 
RSAPIUNLOCK
Undocumented kbrsi_icd.rsapiUnlock;
exec kbrsi_icd.rsapiUnlock;

PL/SQL procedure successfully completed.
 
RSBEGINRUNEVENT
Undocumented kbrsi_icd.rsBeginRunEvent(
event_nm IN VARCHAR2,
param1   IN VARCHAR2);
TBD
 
RSBEGINWAITEVENT
Undocumented kbrsi_icd.rsBeginWaitEvent(
event_nm IN VARCHAR2,
param1   IN VARCHAR2);
TBD
 
RSCLEARERR
Undocumented kbrsi_icd.rsClearErr;
exec kbrsi_icd.rsClearErr;

PL/SQL procedure successfully completed.
 
RSCOPYFILE
Undocumented kbrsi_icd.rsCopyFile(
ifname         IN     VARCHAR2,
ofname         IN OUT VARCHAR2,
fize              OUT NUMBER,
sldir          IN     VARCHAR2,
action         IN     BINARY_INTEGER,
alg_over_alloc IN     BINARY_INTEGER);
TBD
 
RSDBLOCK
Undocumented kbrsi_icd.rsdBlock(db_key IN NUMBER);
TBD
 
RSDBUNLOCK
Undocumented kbrsi_icd.rsdbUnlock(db_key IN NUMBER);
TBD
 
RSDELETEFILE
Undocumented kbrsi_icd.rsDeleteFile(filename IN VARCHAR2);
TBD
 
RSENDEVENT
Undocumented kbrsi_icd.rsEndEvent(
event_nm IN VARCHAR2,
param1   IN VARCHAR2);
TBD
 
RSFPEEK (new 21c)
Undocumented kbrsi_icd.rsfpeek(filename IN VARCHAR2);
exec kbrsi_icd.rsfpeek('TestFileName');
BEGIN kbrsi_icd.rsfpeek('TestFileName'); END;
*
ERROR at line 1:
ORA-19625: error identifying file TestFileName
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ORA-06512: at "SYS.KBRSI_ICD", line 1977
ORA-06512: at line 1
 
RSGENFINCARN
Undocumented kbrsi_icd.rsGenFincarn(fincarn OUT VARCHAR2);
DECLARE
 outVal VARCHAR2(128);
BEGIN
  kbrsi_icd.rsGenFincarn(outVal);
  dbms_output.put_line(outVal);
END;
/
RQ58QVp4O2IB

PL/SQL procedure successfully completed.
 
RSGETDEBUGFLAGS
Returns the RS debug flags if a Recovery Appliance is installed kbrsi_icd.rsGetDebugFlags RETURN NUMBER;
SELECT kbrsi_icd.rsGetDebugFlags
FROM dual;
SELECT kbrsi_icd.rsGetDebugFlags
*
ERROR at line 1:
ORA-45155: The Recovery Appliance has not been installed.
ORA-06512: at "SYS.KBRSI_ICD", line 247
ORA-06512: at "SYS.KBRSI_ICD", line 1500
 
RSGROUPARCHSBT (new 21c)
Undocumented kbrsi_icd.rsGroupArchSBT(
PIECENAME IN  VARCHAR2,
DB_KEY    IN  NUMBER,
LIB_KEY   IN  NUMBER,
TASK_ID   IN  NUMBER,
COMP_ALGO IN  VARCHAR2,
ENC_ALGO  IN  NUMBER,
KEYID     IN  VARCHAR2,
KEYID_LEN IN  NUMBER,
BP_COUNT  IN  NUMBER,
TEMPL_KEY IN  NUMBER,
BKP_BYTES OUT NUMBER);
TBD
 
RSINSPECTBACKUPPIECE
Undocumented kbrsi_icd.rsInspectBackupPiece(
handle       IN  VARCHAR2,
vbkey        IN  NUMBER,
bpsize       IN  NUMBER,
chktype      IN  NUMBER,
fno          IN  NUMBER,
lib_key      IN  NUMBER,
ct_key       IN  NUMBER,
bpkey        OUT NUMBER,
TEMPLATE_KEY IN  NUMBER);
TBD
 
RSISCOMPLETE
Undocumented kbrsi_icd.rsIsComplete(
fname       IN  VARCHAR2,
filesize    OUT NUMBER,
complete    OUT BOOLEAN,
ftype       OUT NUMBER,
same_endian OUT NUMBER,
dbid        OUT NUMBER);
TBD
 
RSKEYREADLOCK
Undocumented kbrsi_icd.rsKeyReadLock(
keyid    IN NUMBER,
waitflag IN BOOLEAN)
RETURN BOOLEAN;
TBD
 
RSKEYUNLOCK
Undocumented kbrsi_icd.rsKeyUnlock(keyid IN NUMBER);
TBD
 
RSKEYWRITELOCK
Undocumented kbrsi_icd.rsKeyWriteLock(
keyid    IN NUMBER,
waitflag IN BOOLEAN)
RETURN BOOLEAN;
TBD
 
RSKRSPDELETEDB (new 21c parameter)
Undocumented kbrsi_icd.rsKrspDeleteDB(
dbid   IN NUMBER,
p_tkey IN NUMBER)
RETURN BINARY_INTEGER;
SELECT dbid FROM v$database;

     DBID
----------
2140826538


SELECT kbrsi_icd.rsKrspDeleteDB(2140826538, 1)
FROM dual;

KBRSI_ICD.RSKRSPDELETEDB(2140826538,1)
--------------------------------------
                                 53910
 
RSOAMDUMP
Undocumented kbrsi_icd.rsOAMDump;
exec kbrsi_icd.rsOAMDump;
BEGIN kbrsi_icd.rsOAMDump; END;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [dbgtbBucketReset:invalid_bucket], [0x000000001], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.KBRSI_ICD", line 1855
ORA-06512: at line 1
 
RSOAMTESTTRACE
Undocumented kbrsi_icd.rsOAMTestTrace;
exec kbrsi_icd.rsOAMTestTrace;

PL/SQL procedure successfully completed.
 
RSPLAN
Undocumented kbrsi_icd.rsPlan(
DBKEY    IN NUMBER,
VBKEY    IN NUMBER,
DFKEY    IN NUMBER,
TYPE     IN BINARY_INTEGER,
RESERVED IN BINARY_INTEGER);
TBD
 
RSPOOLCHUNKNAME
Undocumented kbrsi_icd.rsPoolChunkName(
slparams IN VARCHAR2,
db_id    IN NUMBER,
df_key   IN NUMBER,
chunk    IN NUMBER)
RETURN VARCHAR2;
TBD
 
RSPURGELOCK
Undocumented kbrsi_icd.rsPurgeLock(key IN NUMBER)
RETURN BOOLEAN;
TBD
 
RSPURGEPREP
Undocumented kbrsi_icd.rsPurgePrep(
ptype IN NUMBER,
dbkey IN NUMBER,
vbkey IN NUMBER,
dfkey IN NUMBER);
TBD
 
RSPURGERECLAIM
Undocumented kbrsi_icd.rsPurgeReclaim(
dbkey IN NUMBER,
dfkey IN NUMBER);
TBD
 
RSPURGEUNLOCK
Undocumented kbrsi_icd.rsPurgeUnlock(key IN NUMBER);
TBD
 
RSQUIESCECHECK
Undocumented kbrsi_icd.rsQuiesceCheck(wait IN BOOLEAN)
RETURN BOOLEAN;
BEGIN
  IF kbrsi_icd.rsQuiesceCheck(TRUE) THEN
    dbms_output.put_line('TRUE');
  ELSE
    dbms_output.put_line('FALSE');
  END IF;
END;
/
TRUE

PL/SQL procedure successfully completed.
 
RSQUIESCELOCK
Undocumented kbrsi_icd.rsQuiesceLock;
-- an exception was generated because a Backup Appliance was not configured and attached
exec kbrsi_icd.rsQuiesceLock;

PL/SQL procedure successfully completed.
 
RSQUIESCEUNLOCK
Undocumented kbrsi_icd.rsQuiesceUnlock;
exec kbrsi_icd.rsQuiesceUnlock;

PL/SQL procedure successfully completed.
 
RSRFSALLOW (new 21c)
Undocumented kbrsi_icd.rsrfsAllow;
exec kbrsi_icd.rsrfsAllow;
BEGIN kbrsi_icd.rsrfsAllow; END;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [krsr_rfs_allow.already_allowed], [0], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.KBRSI_ICD", line 2066
ORA-06512: at line 1
 
RSRFSALLOWED (new 21c)
Undocumented kbrsi_icd.rsrfsAllowed RETURN BOOLEAN;
BEGIN
  IF kbrsi_icd.rsrfsAllowed THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
T

PL/SQL procedure successfully completed.
 
RSRFSDISALLOW (new 21c)
Undocumented kbrsi_icd.rsrfsDisallow(m_track_process IN BOOLEAN);
exec kbrsi_icd.rsrfsDisallow(TRUE);
<hangs>

exec kbrsi_icd.rsrfsDisallow(FALSE);
<hangs>
 
RSRFSRESTART (new 21c)
Undocumented kbrsi_icd.rsrfsRestart;
exec kbrsi_icd.rsrfsRestart;

PL/SQL procedure successfully completed.
 
RSSCHEDLOCK
Undocumented kbrsi_icd.rsSchedLock(waitforwork IN BINARY_INTEGER);
SQL> exec kbrsi_icd.rsSchedLock(1);
BEGIN kbrsi_icd.rsSchedLock(1); END;
*
ERROR at line 1:
ORA-00904: "SYS"."RAI_SCHEMA": invalid identifier
ORA-06512: at "SYS.KBRSI_ICD", line 163
ORA-06512: at "SYS.KBRSI_ICD", line 773
ORA-06512: at line 1
 
RSSCHEDUNLOCK
Undocumented kbrsi_icd.rsSchedUnlock(convert IN BOOLEAN);
exec kbrsi_icd.rsSchedUnlock(FALSE);

PL/SQL procedure successfully completed.
 
RSSETDEBUGFLAGS
Undocumented kbrsi_icd.rsSetDebugFlags(dbgn IN NUMBER);
exec kbrsi_icd.rsSetDebugFlags(1);
BEGIN kbrsi_icd.rsSetDebugFlags(1); END;
*
ERROR at line 1:
ORA-45155: The Recovery Appliance has not been installed.
ORA-06512: at "SYS.KBRSI_ICD", line 247
ORA-06512: at "SYS.KBRSI_ICD", line 1482
ORA-06512: at line 1
 
RSSETEVENTATTR
Undocumented kbrsi_icd.rsSetEventAttr(
event_nm  IN VARCHAR2,
param1    IN VARCHAR2,
attr_type IN NUMBER,
value     IN VARCHAR2);
TBD
 
RSSETTRACE
Undocumented kbrsi_icd.rsSetTrace(
newsession IN NUMBER,
errsession IN NUMBER);
exec kbrsi_icd.rsSetTrace(100, 101);
BEGIN kbrsi_icd.rsSetTrace(100, 101); END;
*
ERROR at line 1:
ORA-45155: The Recovery Appliance has not been installed.
ORA-06512: at "SYS.KBRSI_ICD", line 247
ORA-06512: at "SYS.KBRSI_ICD", line 1046
ORA-06512: at line 1
 
RSSLLOCK
Undocumented kbrsi_icd.rsSLLock(sl_key IN NUMBER);
exec kbrsi_icd.rsSLLock(1);

PL/SQL procedure successfully completed.
 
RSSLUNLOCK
Undocumented kbrsi_icd.rsSLUnlock(sl_key IN NUMBER);
exec kbrsi_icd.rsSLUnlock(1);

PL/SQL procedure successfully completed.
 
RSSTARTSTATS
Undocumented kbrsi_icd.rsStartStats(tag IN VARCHAR2);
exec kbrsi_icd.rsStartStats('UWBATAG');

PL/SQL procedure successfully completed.
 
RSSTOPSTATS
Undocumented kbrsi_icd.rsStopStats;
exec kbrsi_icd.rsStopStats;

PL/SQL procedure successfully completed.
 
RSTIMERCHECK
Undocumented kbrsi_icd.rsTimerCheck RETURN BOOLEAN;
BEGIN
  IF kbrsi_icd.rsTimerCheck THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
T

PL/SQL procedure successfully completed.
 
RSTIMERLOCK
Undocumented kbrsi_icd.rsTimerLock RETURN BOOLEAN;
BEGIN
  IF kbrsi_icd.rsTimerLock THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
BEGIN
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kbrsosqlerr-program-error], [], [], [], [], [], [], [], [], [], [], []
ORA-45199: Error ORA-06550: line 1, column 332:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 7:
PL/SQL: SQL Statement ignored
encountered when executing BEGIN SELECT /*+ RESULT_CACHE */ MAX(DECODE(name, '_sgacommsize', value)), MAX(DECODE(name, '_pgacommsize', value)), MAX(DECODE(name,
'network_chunksize', value)), MAX(DECODE(name, '_largepoolpct', value)), MAX(DECODE(name, '_sharedpoolpct', value)) INTO :sgacommsize, :pgacommsize, :chunksize, :largepoolpct,
:sharedpoolpct FROM config WHERE name IN ( '_sgacommsize', '_pgacommsize', 'network_chunksize', '_largepoolpct', '_sharedpoolpct');END;.
ORA-06512: at "SYS.KBRSI_ICD", line 712
ORA-06512: at "SYS.KBRSI_ICD", line 733
ORA-06512: at line 2
 
RSTRACE
Undocumented kbrsi_icd.rsTrace(str IN VARCHAR2);
exec kbrsi_icd.rsTrace('TEST');

PL/SQL procedure successfully completed.
 
SEE_CHUNK (new 21c)
Undocumented kbrsi_icd.see_chunk(
FNAME   IN VARCHAR2,
FSIZE   IN NUMBER,
BLKSIZE IN NUMBER,
STRT    IN NUMBER,
FIN     IN NUMBER);
TBD
 
SETTRACING
Undocumented kbrsi_icd.setTracing(
p_trc_on   IN NUMBER,
p_stall_on IN NUMBER);
TBD
 
STATBPSBT
Undocumented kbrsi_icd.statBPSBT(
handle  IN  VARCHAR2,
mhandle OUT kbrsi_icd.names$_t,
single  OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
 
VALIDATEPIECE
Undocumented kbrsi_icd.validatePiece(
filename IN VARCHAR2,
blksize  IN NUMBER);
TBD
 
VALIDATETASK
Undocumented kbrsi_icd.validateTask(bpkey IN NUMBER);
TBD
 
VALIDATE_CONTAINER_GROUP
Undocumented kbrsi_icd.validate_container_group(
gname   IN  VARCHAR2,
amrvkey OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
 
WALLET2HOSTLST
Undocumented kbrsi_icd.wallet2HostLst(
wallet_loc IN  VARCHAR2,
cred_alias IN  VARCHAR2,
hostlst    OUT VARCHAR2,
port       OUT NUMBER,
ssl        OUT BOOLEAN,
client     IN  VARCHAR2);
TBD
 
WALLET2URL
Undocumented kbrsi_icd.wallet2URL(
wallet_loc IN  VARCHAR2,
cred_alias IN  VARCHAR2,
username   OUT VARCHAR2,
password   OUT VARCHAR2,
url        OUT VARCHAR2,
client     IN  VARCHAR2);
TBD
 
WRITEIO_TEST
Tests write I/O performance to a Oracle Backup Appliance kbrsi_icd.writeIO_test(
filename       IN  VARCHAR2,
filesize       IN  VARCHAR2,
chunksize      IN  VARCHAR2,
nowrite        IN  BOOLEAN,
containerwrite IN  BOOLEAN,
cputime        OUT NUMBER)
RETURN NUMBER;
DECLARE
 cTime NUMBER;
 retVal NUMBER;
BEGIN
  retVal := kbrsi_icd.writeIO_test('A', '100M', '4K', TRUE, TRUE, cTime);
  dbms_output.put_line(cTime);
END;
/
DECLARE
*
ERROR at line 1:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 36: File name too long
Additional information: 9
ORA-06512: at "SYS.KBRSI_ICD", line 1877
ORA-06512: at "SYS.KBRSI_ICD", line 1914
ORA-06512: at line 5

Related Topics
Built-in Functions
Built-in Packages
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx