ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
-- 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
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);
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;
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;
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);
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;
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);
-- 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;
