Oracle KBRSI_ICD
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.
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 DBMS_UTILITY
DBMS_ASSERT DBMS_SYS_ERROR KBRSLIB
DBMS_LOCK    
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 12cR1
Security Model Owned by SYS with
Source {ORACLE_HOME}/rdbms/admin/dbmsrsicd.plb
dbmsrspreq.plb
recover.bsq
Subprograms
 
BA_ENABLED
Returns an exception if a Backup (Recovery) Appliance is not enabled kbrsi_icd.ba_enabled;
SQL> 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 1950
ORA-06512: at line 1
 
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;
SQL> SELECT kbrsi_icd.container_bdapi_reload_config
  2  FROM dual;

CONTAINER_BDAPI_RELOAD_CONFIG
-----------------------------
                            0
 
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;
 
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 kbrsi_icd.container_system_init;
exec kbrsi_icd.container_system_init;
 
CREATE_CONTAINER
Create a Backup Appliance Container kbrsi_icd.create_container(
gname IN VARCHAR2,
bytes IN VARCHAR2,
dest  IN VARCHAR2);
I considered trying this but it has the appearance of possibly being destructive so I chose not to and recommend that others do not do so as well.
 
CREATE_CONTAINER_GROUP
Create a Backup Appliance Container Group kbrsi_icd.create_container_group(gname IN VARCHAR2);
SQL> ALTER SESSION SET tracefile_identifier = 'test_plan1';

Session altered.

SQL> ALTER SESSION SET EVENTS '10046 trace name context forever, level 12';

Session altered.

SQL> 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


SQL> ALTER SESSION SET EVENTS '10046 trace 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);
SQL> 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 1273
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
 
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
SQL> exec kbrsi_icd.drop_container_group('ZZYZX', 0, 1);
BEGIN kbrsi_icd.drop_container_group('ZZYZX', 0, 1); END;
*
ERROR at line 1:
ORA-45279: Container group ZZYZX does not exist.
ORA-06512: at "SYS.KBRSI_ICD", line 1509
ORA-06512: at "SYS.KBRSI_ICD", line 1527
ORA-06512: at line 1
 
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;
 
GETSTALLTIMEOUT
Returns the Backup Appliance stall timeout value in seconds kbrsi_icd.getStallTimeout RETURN NUMBER;
SQL> SELECT kbrsi_icd.getStallTimeout
  2  FROM dual;

GETSTALLTIMEOUT
---------------
           1800
 
GETVERIFIER
Undocumented kbrsi_icd.getVerifier RETURN VARCHAR2;
SQL> SELECT kbrsi_icd.getverifier
  2  FROM dual;

GETVERIFIER
-------------------------------------------------------------------------------------
Uzo3MjA3MzQyQjAyQTI5NTdGMzFGOTVDRUZEMTdDRjEwRDUxNUFDQkIxNzE2QzI5OTVEODVBNUU5QUM0Njg=
 
ISORSALIVE
Appears to raise an exception if an Oracle Recovery Appliance is not configured and available kbrsi_icd.isOrsaLive RETURN BOOLEAN;
SQL> BEGIN
  2    IF kbrsi_icd.isOrsaLive THEN
  3      dbms_output.put_line('T');
  4    ELSE
  5      dbms_output.put_line('F');
  6    END IF;
  7  END;
  8  /
BEGIN
*
ERROR at line 1:
ORA-45155: The Recovery Appliance has not been installed.
ORA-06512: at "SYS.KBRSI_ICD", line 116
ORA-06512: at "SYS.KBRSI_ICD", line 1437
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;
 
 
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;
SQL> BEGIN
  2    IF kbrsi_icd.rsapiLock THEN
  3      dbms_output.put_line('T');
  4    ELSE
  5      dbms_output.put_line('F');
  6    END IF;
  7  END;
  8  /
F
 
RSAPIUNLOCK
Undocumented kbrsi_icd.rsapiUnlock;
exec kbrsi_icd.rsapiUnlock;
 
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;
 
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
 
RSGENFINCARN
Undocumented kbrsi_icd.rsGenFincarn(fincarn OUT VARCHAR2);
SQL> DECLARE
  2   outVal VARCHAR2(128);
  3  BEGIN
  4    kbrsi_icd.rsGenFincarn(outVal);
  5    dbms_output.put_line(outVal);
  6  END;
  7  /
l0lbLZvXK33S

PL/SQL procedure successfully completed.
 
RSGETDEBUGFLAGS
Returns the RS debug flags if a Recovery Appliance is installed kbrsi_icd.rsGetDebugFlags RETURN NUMBER;
SQL> SELECT kbrsi_icd.rsGetDebugFlags
  2  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 116
ORA-06512: at "SYS.KBRSI_ICD", line 1484
 
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
Undocumented kbrsi_icd.rsKrspDeleteDB(dbid IN NUMBER) RETURN BINARY_INTEGER;
SQL> SELECT dbid FROM v$database;

 DBID
----------
549318987

SQL> SELECT kbrsi_icd.rsKrspDeleteDB(549318987)
  2  FROM dual;

KBRSI_ICD.RSKRSPDELETEDB(549318987)
-----------------------------------
                                 -2
 
RSMOVEPOOLDF
Undocumented kbrsi_icd.rsMovePoolDF(
db_id      IN NUMBER,
dbinc_key  IN NUMBER,
db_key     IN NUMBER,
df_key     IN NUMBER,
chunkno    IN NUMBER,
sl_loc     IN VARCHAR2,
fsize      IN BINARY_INTEGER,
blksize    IN BINARY_INTEGER,
issft      IN BINARY_INTEGER,
cmpvsn     IN BINARY_INTEGER,
fullblocks IN BINARY_INTEGER);
TBD
 
RSOAMDUMP
Undocumented kbrsi_icd.rsOAMDump;
SQL> 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 1839
ORA-06512: at line 1
 
RSOAMTESTTRACE
Undocumented kbrsi_icd.rsOAMTestTrace;
exec kbrsi_icd.rsOAMTestTrace;
 
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;
SQL> BEGIN
  2    IF kbrsi_icd.rsQuiesceCheck(TRUE) THEN
  3      dbms_output.put_line('TRUE');
  4    ELSE
  5      dbms_output.put_line('FALSE');
  6    END IF;
  7 END;
  8 /
TRUE

PL/SQL procedure successfully completed.
 
RSQUIESCELOCK
Undocumented kbrsi_icd.rsQuiesceLock;
-- an exception was generated because a Backup Appliance was not configured and attached
SQL> exec kbrsi_icd.rsQuiesceLock;
BEGIN kbrsi_icd.rsQuiesceLock; END;
*
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "SYS.KBRSI_ICD", line 861
ORA-06512: at line 1
 
RSQUIESCEUNLOCK
Undocumented kbrsi_icd.rsQuiesceUnlock;
exec kbrsi_icd.rsQuiesceUnlock;
 
RSRUNSCHED
Undocumented kbrsi_icd.rsRunSched;
SQL> exec kbrsi_icd.rsRunSched;
BEGIN kbrsi_icd.rsRunSched; 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 796
ORA-06512: at line 1
 
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(nomorejobsin IN BINARY_INTEGER);
SQL> exec kbrsi_icd.rsSchedUnlock(1);

PL/SQL procedure successfully completed.
 
RSSETDEBUGFLAGS
Undocumented kbrsi_icd.rsSetDebugFlags(dbgn IN NUMBER);
SQL> 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 116
ORA-06512: at "SYS.KBRSI_ICD", line 1466
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);
SQL> 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 116
ORA-06512: at "SYS.KBRSI_ICD", line 1109
ORA-06512: at line 1
 
RSSLLOCK
Undocumented kbrsi_icd.rsSLLock(sl_key IN NUMBER);
exec kbrsi_icd.rsSLLock(1);
 
RSSLUNLOCK
Undocumented kbrsi_icd.rsSLUnlock(sl_key IN NUMBER);
exec kbrsi_icd.rsSLUnlock(1);
 
RSSTARTSTATS
Undocumented kbrsi_icd.rsStartStats(tag IN VARCHAR2);
exec kbrsi_icd.rsStartStats('UWBATAG');
 
RSSTOPSTATS
Undocumented kbrsi_icd.rsStopStats;
exec kbrsi_icd.rsStopStats;
 
RSTIMERCHECK
Undocumented kbrsi_icd.rsTimerCheck RETURN BOOLEAN;
SQL> BEGIN
  2    IF kbrsi_icd.rsTimerCheck THEN
  3      dbms_output.put_line('T');
  4    ELSE
  5      dbms_output.put_line('F');
  6    END IF;
  7 END;
  8 /
T

PL/SQL procedure successfully completed.
 
RSTIMERLOCK
Undocumented kbrsi_icd.rsTimerLock;
SQL> exec kbrsi_icd.rsTimerLock;
BEGIN kbrsi_icd.rsTimerLock; END;
*
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 730
ORA-06512: at "SYS.KBRSI_ICD", line 751
ORA-06512: at line 1
 
RSTRACE
Undocumented kbrsi_icd.rsTrace(str IN VARCHAR2);
exec kbrsi_icd.rsTrace('TEST');
 
SETSTALLTIMEOUT
Undocumented kbrsi_icd.setStallTimeOut(p_secs IN NUMBER);
SQL> exec kbrsi_icd.setStallTimeOut(60);
BEGIN kbrsi_icd.setStallTimeOut(60); END;
*
ERROR at line 1:
ORA-45155: The Recovery Appliance has not been installed.
ORA-06512: at "SYS.KBRSI_ICD", line 116
ORA-06512: at "SYS.KBRSI_ICD", line 1109
ORA-06512: at "SYS.KBRSI_ICD", line 1081
ORA-06512: at line 1
 
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;
SQL> DECLARE
  2   cTime NUMBER;
  3   retVal NUMBER;
  4  BEGIN
  5    retVal := kbrsi_icd.writeIO_test('ORACLE_BASE\test.txt', '100M', '4K', TRUE, TRUE, cTime);
  6    dbms_output.put_line(cTime);
  7  END;
  8  /
DECLARE
*
ERROR at line 1:
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 123) The filename, directory name, or volume label syntax is incorrect.
ORA-06512: at "SYS.KBRSI_ICD", line 1861
ORA-06512: at "SYS.KBRSI_ICD", line 1898
ORA-06512: at line 5

Related Topics
Built-in Functions
Built-in Packages
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved