Oracle DBMS_RA_INT
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 TBD
AUTHID DEFINER
Constants
Name Data Type Value
 Debug Level
AM_DEBUG_OFF NUMBER 0
AM_DEBUG_ON NUMBER 1
AM_DEBUG_LOW NUMBER 2
AM_DEBUG_MED NUMBER 3
AM_DEBUG_HIGH NUMBER 4
 Debug Flags
DEBUG_FLAG_NAMES VARCHAR2(1000) 'NONE ' || 'TO_DISK ' ||
'SQL ' || 'SERVLET ' ||
'RCVCAT_MIN ' || 'RCVCAT_MAX ' ||
'RCVMAN ' || 'KRBR ' ||
'RSPL_LOW ' || 'RSPL_MED ' ||
'RSPL_HIGH ' ||'RSMISC ' ||
'RSJS ' ||'RSSM ' ||
'FUNC ' || 'RSSBT ' ||
'KBC_LOW ' || 'KBC_MED ' ||
'KBC_HIGH ' || 'PERF_ON '
'KBRP_MIN '|| ''KBRP_ALL    '
'SAFE_MODE    ' || 'STALL       ' ||
'SQLTRACE    ' || 'BLOCKS      ' ||
'KBRSPL      ' || 'KBRS        ' ||
'KBRSSV      ' || 'KBRSPM      ' ||
KBC_MIN     ' || 'KBC_MAX     '
Dependencies
BDF DBMS_SYS_ERROR SBT_ATTR_SET
BLOCKS ENCINFO SBT_CATALOG
BP KBRSI_ICD SBT_JOB_TEMPLATE
CHUNKS NODE SBT_LIB_DESC
CONFIG ODB SERVER
DBMS_LOCK PLANS SESSIONS
DBMS_RA PROT SL
DBMS_RA_MISC RA_REPLICATION_CONFIG STORAGE_DESTS
DBMS_RA_POOL REP_PAIR TASK
DBMS_RA_SBT REP_SERVER VBDF
DBMS_RA_SCHEDULER RRA_REQUSET_BACKUP V$DIAG_INFO
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/recover.bsq
-- The SQL for this package was extracted from recover.bsq and executed independently
-- from a SQL*Plus prompt. Not having an Oracle Recovery Appliance handy some a small
-- amount of the source was commented out to obtain a successful compilation.


SQL> @?\rdbms\admin\dbms_ra_int.sql

SP2-0808: Package created with compilation warnings

SQL> show err
Errors for PACKAGE DBMS_RA_INT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1/1 PLW-05018: unit DBMS_RA_INT omitted optional AUTHID clause;
default value DEFINER used
72/25 PLW-07203: parameter 'P_FILE_TEMPLATE_NAME' may benefit from use of the NOCOPY compiler hint
139/19 PLW-06026: package specification exposes global variable S_ALT_INIT_REP
Subprograms
 
ADD_REPLICATION_SERVER_ALT
Undocumented dbms_ra_int.add_replication_server_alt(
replication_server_name IN VARCHAR2,
protection_policy_name  IN VARCHAR2);
TBD
 
BLOCK_VIEW
Undocumented dbms_ra_int.block_view(
dfkey  IN NUMBER,
chunk  IN NUMBER,
offset IN NUMBER);
TBD
 
CREATE_REPLICATION_SERVER
Undocumented dbms_ra_int.create_replication_server(
replication_server_name IN VARCHAR2,
sbt_so_name             IN VARCHAR2,
sbt_parms               IN VARCHAR2,
max_streams             IN NUMBER,
catalog_user_name       IN VARCHAR2,
wallet_alias            IN VARCHAR2,
wallet_path             IN VARCHAR2,
proxy_url               IN VARCHAR2,
proxy_port              IN NUMBER,
http_timeout            IN NUMBER);
TBD
 
DEBUG_DECODE
Undocumented dbms_ra_int.debug_decode(p_param IN VARCHAR2) RETURN VARCHAR2;
TBD
 
DEBUG_ENCODE
Undocumented dbms_ra_int.debug_encode(p_strval IN VARCHAR2) RETURN NUMBER;
-- demo code from recover.bsq
IF l_name LIKE '_debug%' or l_name = '_servlet_debug_flags' THEN
  l_val := dbms_ra_int.debug_encode(p_value);

  IF l_name = '_debug_flags' AND l_val = 0 THEN
    l_val := 1;
  END IF;

  upsert_config_parm(l_name, l_val);
ELSIF l_name = '_test_point' THEN
  upsert_config_parm(l_name, UPPER(p_value));
  upsert_config_parm('_test_point_regexp', NULL);
ELSIF l_name = '_test_point_regexp' THEN
  upsert_config_parm(l_name, p_value);
  upsert_config_parm('_test_point', NULL);
ELSE
  upsert_config_parm(l_name, UPPER(p_value));
END IF;
 
DELETE_BACKUP_PIECE
Undocumented dbms_ra_int.delete_backup_piece(bpkey IN NUMBER);
TBD
 
DG_BACKUP_LOG
Undocumented dbms_ra_int.dg_backup_log(
p_ct_key   IN NUMBER,
p_next_scn IN NUMBER,
p_complete IN BOOLEAN,
p_retry    IN BOOLEAN);
TBD
 
DG_BTS2HANDLE
Undocumented dbms_ra_int.dg_bts2handle(
p_reset_scn  IN NUMBER,
p_reset_time IN NUMBER,
p_thread     IN NUMBER,
p_sequence   IN NUMBER)
RETURN VARCHAR2;
TBD
 
DG_FIND_CT_KEY
Undocumented dbms_ra_int.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
Undocumented dbms_ra_int.dg_get_platform_id(
p_dbid IN NUMBER,
p_tkey IN NUMBER)
RETURN NUMBER;
TBD
 
DG_HANDLE2BTS
Undocumented dbms_ra_int.dg_handle2bts(
p_handle     IN  VARCHAR2,
p_reset_scn  OUT NUMBER,
p_reset_time OUT NUMBER,
p_thread     OUT NUMBER,
p_sequence   OUT NUMBER);
TBD
 
DG_IS_DB_OK
Undocumented dbms_ra_int.dg_is_db_ok(
p_dbid IN NUMBER,
p_tkey IN NUMBER)
RETURN NUMBER;
TBD
 
DG_NAME_LOG
Undocumented dbms_ra_int.dg_name_log(
p_ct_key    IN NUMBER,
p_file_name IN VARCHAR2);
TBD
 
DG_NEW_LOG
Undocumented dbms_ra_int.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  NUMBER,
p_ct_key             OUT NUMBER,
p_file_template_name OUT VARCHAR2)
RETURN NUMBER;
TBD
 
KEY_CREATE
Undocumented dbms_ra_int.key_create(db_unique_name IN VARCHAR2);
exec dbms_ra_int.key_create('ORABASEXXI');
 
KEY_UPDATE_TAG
Undocumented dbms_ra_int.key_update_tag(
db_unique_name IN VARCHAR2,
tag            IN VARCHAR2);
TBD
 
KILLTASK
Undocumented dbms_ra_int.killTask(taskid IN NUMBER);
TBD
 
PLAN_BP
Undocumented dbms_ra_int.plan_bp(
bp_key   IN NUMBER,
priority IN NUMBER);
TBD
 
REBUILDBLOCKS
Undocumented dbms_ra_int.rebuildBlocks(
p_partition_hash IN NUMBER,
p_dfkey          IN NUMBER);
TBD
 
RELEASEORPHANEDPENDINGTASKS
Undocumented dbms_ra_int.releaseOrphanedPendingTasks;
exec dbms_ra_int.releaseOrphanedPendingTasks;
 
RELEASETASK
Undocumented dbms_ra_int.releaseTask(task_id IN NUMBER);
TBD
 
REPAIR_STORAGE_LOCATION
Undocumented dbms_ra_int.repair_storage_location(
storage_location_name IN VARCHAR2,
repair_type           IN VARCHAR2);
TBD
 
REPLICATE_BACKUPS
Undocumented dbms_ra_int.replicate_backups(
db_unique_name          IN VARCHAR2,
replication_server_name IN VARCHAR2,
alt_init_rep            IN BOOLEAN,
override_read_only      IN BOOLEAN);
TBD
 
REPLICATE_ONE_BACKUP
Undocumented dbms_ra_int.replicate_one_backup(
bpkey                   IN NUMBER,
replication_server_name IN VARCHAR2,
override_read_only      IN BOOLEAN);
TBD
 
REPLICATION_ADD_REPOSITORY
Undocumented dbms_ra_int.replication_add_repository(
catalog_user_name IN VARCHAR2,
new_server_key    IN NUMBER,
am_server_name    IN VARCHAR2,
wallet_alias      IN VARCHAR2,
wallet_path       IN VARCHAR2,
proxy_url         IN VARCHAR2,
proxy_port        IN NUMBER,
http_timeout      IN NUMBER)
RETURN NUMBER;
TBD
 
REPLICATION_DELETE_REPOSITORY
Undocumented dbms_ra_int.replication_delete_repository(
catalog_user_name IN VARCHAR2,
wallet_alias      IN VARCHAR2,
wallet_path       IN VARCHAR2);
TBD
 
REPLICATION_NETWORK_GRANT
Undocumented dbms_ra_int.replication_network_grant(
catalog_user_name IN VARCHAR2,
wallet_alias      IN VARCHAR2,
wallet_path       IN VARCHAR2);
TBD
 
REPLICATION_NETWORK_REVOKE
Undocumented dbms_ra_int.replication_network_revoke(
catalog_user_name IN VARCHAR2,
wallet_alias      IN VARCHAR2,
wallet_path       IN VARCHAR2);
TBD
 
REPLICATION_RECONCILE
Undocumented

Overload 1
dbms_ra_int.replication_reconcile(
db_unique_name          IN VARCHAR2,
replication_server_name IN VARCHAR2,
p_force_fixed           IN BOOLEAN);
TBD
Overload 2 dbms_ra_int.replication_reconcile(protection_policy_name IN VARCHAR2);
TBD
 
REPLICATION_RECONCILE_RESET
Undocumented dbms_ra_int.replication_reconcile_reset(db_unique_name IN VARCHAR2);
exec dbms_ra_int.replication_reconcile_reset('orabasexxi');
 
RETRYTASK
Undocumented dbms_ra_int.retrytask(taskid IN NUMBER);
TBD
 
RMTRA_PROBE
Undocumented dbms_ra_int.rmtra_probe(replication_server_name IN VARCHAR2);
TBD
 
RMTRA_REQUEST_CALC_MISSING
Undocumented dbms_ra_int.rmtra_request_calc_missing(
db_key       IN NUMBER,
group#       IN NUMBER,
rep_pair_key IN NUMBER);
TBD
 
RMTRA_REQUEST_EXECUTE
Undocumented dbms_ra_int.rmtra_request_execute(group# IN NUMBER);
TBD
 
RMTRA_REQUEST_QUEUE_PIECE
Undocumented dbms_ra_int.rmtra_request_queue_piece(
bp_key IN NUMBER,
group# IN NUMBER);
TBD
 
RRA_PROBE
Undocumented ddbms_ra_int.rra_probe(replication_server_name IN VARCHAR2);
TBD
 
SETTRACING
Undocumented dbms_ra_int.setTracing(p_trc_on IN NUMBER);
TBD
 
TESTRBP
Undocumented dbms_ra_int.testRPB(p_dfkey IN NUMBER);
TBD
 
TESTTASK
Undocumented dbms_ra_int.testTask(
taskid     IN NUMBER,
tasktype   IN NUMBER,
num1       IN NUMBER,
num2       IN NUMBER,
num3       IN NUMBER,
num4       IN NUMBER,
num5       IN NUMBER,
char1      IN VARCHAR2,
char2      IN VARCHAR2,
param      IN VARCHAR2,
slkey      IN NUMBER,
dbkey      IN NUMBER,
settrace   IN NUMBER,
newsession IN BOOLEAN,
wait       IN BOOLEAN);
TBD
 
TEST_POINT_CB
Undocumented dbms_ra_int.test_point_cb(p_instr IN VARCHAR2);
-- demo code from recover.bsq
PROCEDURE trc (message IN VARCHAR2) IS
 l_pos NUMBER := 1;
BEGIN
  IF NOT dbms_ra_scheduler.s_config_loaded THEN
    dbms_ra_scheduler.load_config;
  END IF;

  IF s_tracing_on THEN
    sys.kbrsi_icd.rsTrace('RSI:' || message);
  END IF;
  dbms_ra_int.test_point_cb('RA: ' || message);
END trc;
 
TRACING_ON
Undocumented dbms_ra_int.tracing_on(dbgflags IN VARCHAR2);
-- demo code from recover.bsq
exec dbms_ra_int.tracing_on(268437506);
exec dbms_ra_int.tracing_on('NONE');
 
VALIDATE
Undocumented dbms_ra_int.validate(
p_dbkey   IN NUMBER,
p_dfkey   IN NUMBER,
p_vbkey   IN NUMBER,
p_sort    IN NUMBER,
p_deb_ext IN BOOLEAN,
p_trace   IN VARCHAR2);
TBD
 
VALIDATE_BP
Undocumented dbms_ra_int.validate_bp(
bpkey    IN NUMBER,
dbgflags IN VARCHAR2);
TBD
 
VALIDATE_DB
Undocumented dbms_ra_int.validate_db(
db_key   IN NUMBER,
priority IN NUMBER);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_RA
DBMS_RA_DUMP
DBMS_RA_MISC
DBMS_RA_POOL
DBMS_RA_SBT
DBMS_RA_SCHEDULER
DBMS_RA_STORAGE
KBRSI_ICD
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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx