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.
Purpose
Recovery Appliance (Recovery Appliance) Backup and Recovery support utility for tape (SBT)
AUTHID
DEFINER
Constants
Name
Data Type
Value
General
RRA_MSG_UNSUPPORTED
PLS_INTEGER
9999
RRA_MSG_PROBE
PLS_INTEGER
1
RRA_MSG_HEARTBEAT
PLS_INTEGER
2
RRA_MSG_BREAK_REPPAIR
PLS_INTEGER
3
RRA_MSG_REQUEST_BACKUP
PLS_INTEGER
4
RRA_MSG_LAST_MSGCODE
PLS_INTEGER
RRA_MSG_REQUEST_BACKUP
Data Types
CREATE OR REPLACE TYPE rai_number_2t IS TABLE OF rai_two_numbers_type;
Dependencies
ARCH_GROUP_TASK
DBMS_RCVMAN
SBT_CATALOG
BCF
DBMS_SYS_ERROR
SBT_JOB_TEMPLATE
BDF
DBMS_XMLGEN
SBT_LIB_DESC
BP
DF
SBT_TASK
BRL
INITREP_ALT
SBT_TASK_HISTORY
BS
KBRSI_ICD
SBT_TEMPLATE_DB
BSF
NODE
SBT_TEMPLATE_DF
CKP
ODB
SERVER
CONFIG
OFFR
SF_BACKUP
DB
PROT
TASK
DBINC
RAA_VERSIONS
TENANT
DBMS_BACKUP_RESTORE
RAI_ACTIVE_INSTANCES
TIMER_TASK
DBMS_LOB
RAI_SCHEMA
USER_TAB_COLUMNS
DBMS_NETWORK_ACL_ADMIN
RA_REPLICATION_CONFIG
V_$PARAMETER
DBMS_RA
RCFILE
V_$RMAN_ENCRYPTION_ALGORITHMS
DBMS_RA_INT
REP_PAIR
_RSX_RSI_RMTRA_HANDSHAKE_
DBMS_RA_MISC
REP_SERVER
_RSX_RSI_RMTRA_REQBU_BU_RESP_
DBMS_RA_SCHEDULER
RRA_REQUEST_BACKUP
_RSX_RSI_RMTRA_REQBU_PDBINFO_
DBMS_RA_STORAGE
SBT_ATTR_SET
_RSX_RSI_RMTRA_REQBU_BU_
Documented
No
First Available
Not known
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/recover.bsq
Compilation requires sys.kbrsi_icd is installed and execute is granted to the RMAN catalog owner.
dbms_ra_sbt.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 DEFAULT NULL,
proxy_port IN NUMBER DEFAULT NULL,
http_timeout IN NUMBER DEFAULT NULL)
RETURN NUMBER;
dbms_ra_sbt.baselineTimezone(
p_db_key IN NUMBER,
p_baseline_time OUT NOCOPY DATE,
p_baseline_untscn OUT NOCOPY NUMBER,
p_recovery_window_sbt OUT NOCOPY DATE);
dbms_ra_sbt.copy_one_backuppiece(
p_bpkey IN NUMBER,
p_format IN VARCHAR2,
p_deletesource IN VARCHAR2,
p_template_key IN NUMBER DEFAULT NULL,
p_compression_algo IN VARCHAR2 DEFAULT NULL,
p_encryption_algo IN VARCHAR2 DEFAULT NULL);
dbms_ra_sbt.create_sbt_job_template_int(
template_name IN VARCHAR2,
prot_name IN VARCHAR2,
attr_name IN VARCHAR2,
backup_type IN VARCHAR2,
full_template_name IN VARCHAR2 DEFAULT NULL,
from_tag IN VARCHAR2 DEFAULT NULL,
priority IN NUMBER DEFAULT 100, -- SBT_PRIORITY_MEDIUM
copies IN NUMBER DEFAULT 1,
window IN DSINTERVAL_UNCONSTRAINED DEFAULT NULL,
p_compression_algo IN VARCHAR2 DEFAULT NULL,
p_encryption_algo IN VARCHAR2 DEFAULT NULL,
do_commit IN BOOLEAN DEFAULT TRUE);
TBD
Overload 2
dbms_ra_sbt.create_sbt_job_template_int(
template_name IN VARCHAR2,
db_unique_name IN VARCHAR2,
attr_name IN VARCHAR2,
backup_type IN VARCHAR2,
full_template_name IN VARCHAR2 DEFAULT NULL,
from_tag IN VARCHAR2 DEFAULT NULL,
priority IN NUMBER DEFAULT 100, -- SBT_PRIORITY_MEDIUM
copies IN NUMBER DEFAULT 1,
window IN DSINTERVAL_UNCONSTRAINED DEFAULT NULL,
p_compression_algo IN VARCHAR2 DEFAULT NULL,
p_encryption_algo IN VARCHAR2 DEFAULT NULL,
do_commit IN BOOLEAN DEFAULT TRUE,
p_tkey IN NUMBER DEFAULT 0); -- DEFAULT_TENANT
dbms_ra_sbt.ProcessAllPieceScheduled(
p_bs_key IN NUMBER,
p_template_key IN NUMBER,
p_db_key IN NUMBER,
p_df_file_no IN NUMBER,
p_df_ckpscn IN NUMBER,
p_df_crescn IN NUMBER,
p_df_pc IN NUMBER,
p_raise_error IN BOOLEAN);
dbms_ra_sbt.queueArchivedLogBcks(
p_db_key IN NUMBER,
p_from_tag IN VARCHAR2,
p_template_key IN NUMBER,
p_full_template_key IN NUMBER,
p_baseline_scn IN NUMBER,
p_lib_key IN NUMBER,
p_attr_key IN NUMBER,
p_copies IN NUMBER,
p_delete_source IN VARCHAR2,
p_format IN VARCHAR2,
p_init_cf_bs_key IN NUMBER,
p_last_bp_key IN NUMBER,
p_server_key IN NUMBER,
p_compression_algo IN VARCHAR2,
p_encryption_algo IN VARCHAR2,
p_autobackup_prefix IN VARCHAR2,
p_tag IN VARCHAR2);
dbms_ra_sbt.queueBaseLevelBcks(
p_db_key IN NUMBER,
p_dbid OUT NUMBER,
p_currinc IN OUT NUMBER,
p_db_slkey IN OUT NUMBER,
p_from_tag IN VARCHAR2,
p_template_key IN NUMBER,
p_baseline_scn IN OUT NUMBER,
p_lib_key IN NUMBER,
p_attr_key IN NUMBER,
p_copies IN NUMBER,
p_delete_source IN VARCHAR2,
p_format IN VARCHAR2,
p_last_bp_key IN NUMBER,
p_max_bp_key IN NUMBER,
p_server_key IN NUMBER,
p_compression_algo IN VARCHAR2,
p_encryption_algo IN VARCHAR2,
p_autobackup_prefix IN VARCHAR2,
p_tag IN VARCHAR2);
dbms_ra_sbt.queueIncrementalBcks(
p_db_key IN NUMBER,
p_from_tag IN VARCHAR2,
p_template_key IN NUMBER,
p_full_template_key IN NUMBER,
p_baseline_scn IN NUMBER,
p_lib_key IN NUMBER,
p_attr_key IN NUMBER,
p_copies IN NUMBER,
p_delete_source IN VARCHAR2,
p_format IN VARCHAR2,
p_init_cf_bs_key IN NUMBER,
p_last_bp_key IN NUMBER,
p_server_key IN NUMBER,
p_compression_algo IN VARCHAR2,
p_encryption_algo IN VARCHAR2,
p_autobackup_prefix IN VARCHAR2,
p_tag IN VARCHAR2);
dbms_ra_sbt.queueKeepAndNvFullBcks(
p_db_key IN NUMBER,
p_from_tag IN VARCHAR2,
p_template_key IN NUMBER,
p_baseline_scn IN NUMBER,
p_lib_key IN NUMBER,
p_attr_key IN NUMBER,
p_copies IN NUMBER,
p_delete_source IN VARCHAR2,
p_format IN VARCHAR2,
p_last_bp_key IN NUMBER,
p_server_key IN NUMBER,
p_keep_bck IN NUMBER,
p_nvfull_bck IN NUMBER);
dbms_ra_sbt.queueMissingDFBcks(
p_db_key IN NUMBER,
p_from_tag IN VARCHAR2,
p_template_key IN NUMBER,
p_baseline_scn IN NUMBER,
p_lib_key IN NUMBER,
p_attr_key IN NUMBER,
p_copies IN NUMBER,
p_delete_source IN VARCHAR2,
p_format IN VARCHAR2,
p_last_bp_key IN NUMBER,
p_server_key IN NUMBER,
p_compression_algo IN VARCHAR2,
p_encryption_algo IN VARCHAR2,
p_autobackup_prefix IN VARCHAR2,
p_tag IN VARCHAR2);
dbms_ra_sbt.reconcile_db (p_where IN VARCHAR2,
p_db_key IN NUMBER,
p_server_key IN NUMBER DEFAULT NULL,
p_only_active IN BOOLEAN DEFAULT TRUE,
p_force_reconcile IN BOOLEAN DEFAULT FALSE,
rec_cnt OUT NUMBER,
p_force_fixed IN BOOLEAN DEFAULT FALSE)
RETURN BOOLEAN;
dbms_ra_sbt.replicate_one_bp (p_db_key IN NUMBER,
p_bp_key IN NUMBER,
p_server_key IN NUMBER DEFAULT NULL,
p_override_read_only IN BOOLEAN DEFAULT FALSE,
p_allow_rerep IN BOOLEAN DEFAULT FALSE,
p_cnt_new_tasks OUT NUMBER);
dbms_ra_sbt.reqmode_calculate_missing(
p_db_key IN NUMBER DEFAULT NULL,
p_rep_pair_key IN NUMBER DEFAULT NULL,
p_group# IN NUMBER DEFAULT NULL,
p_from_api IN BOOLEAN DEFAULT FALSE);
dbms_ra_sbt.statBpSbt(
db_key IN NUMBER,
handle IN VARCHAR2,
mhandle OUT NOCOPY sys.kbrsi_icd.names$_t,
single OUT BINARY_INTEGER,
recall IN BINARY_INTEGER,
remote OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;