Oracle | DBMS_RA

Oracle DBMS_RA_SCHEDULER Version 21c

General Information

Library Note

Morgan's Library Page Header

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)

SELECT UNIQUE authid FROM dba_procedures WHERE object_name = 'DBMS_RA_SCHEDULER';

AUTHID DEFINER

Constants

Name	Data Type	Value
FTYPE
FTYPE_ARCHIVELOG	NUMBER	4
FTYPE_BACKUP	NUMBER	9
FTYPE_INCBACKUP	NUMBER	10
FTYPE_ARCHBACKUP	NUMBER	11
FTYPE_AUTOBACKUP	NUMBER	20
FTYPE_CHUNK	NUMBER	40
GC
GC_NOT_TAPED_STATE_VALID	VARCHAR2(1)	'V'
GC_NOT_TAPED_STATE_INVALID	VARCHAR2(1)	'I'
GC_NOT_TAPED_STATE_COMPUTE	VARCHAR2(1)	'C'
GC_NOT_TAPED_STATE_BROKEN	VARCHAR2(1)	'B'
GC_NOT_TAPED_STATE_NOBKP_TAPE	VARCHAR2(1)	'N'
INTERRUPT_TASKS
INTERRUPT_FOR_MOVE	INTERRUPT_T	1
INTERRUPT_FOR_PURGE	INTERRUPT_T	2
LOCK Constants
LOCK_TIMER	NUMBER	1
LOCK_SCHED	NUMBER	2
LOCK_API	NUMBER	3
LOCK_QUIESCE	NUMBER	4
LOCK_DB_KEY	NUMBER	5
LOCK_SL_KEY	NUMBER	6
LOCK_COMMON	NUMBER	7
LOCK_PURGE	NUMBER	8
LOCK_KEY	NUMBER	9
LOCK_QUIESCE_PENDING	NUMBER	1
MOVE
MOVE_PHASE_NULL	NUMBER	NULL
MOVE_PHASE_PEND	NUMBER	1
MOVE_PHASE_START	NUMBER	2
MOVE_PHASE_POOL	NUMBER	3
MOVE_PHASE_FILES	NUMBER	4
POLL
POLL_FLAGS_DELETE_INPUT	NUMBER	2**0
POLL_FLAGS_UNDO_DBID_ERROR	NUMBER	2**1
POLL_FLAGS_UNDO_TIMEOUT_ERROR	NUMBER	2**2
POLLING HISTORY
POLLING_HISTORY_PROCESSING	CHAR(1)	'P'
POLLING_HISTORY_COMPLETED	CHAR(1)	'C'
POLLING_HISTORY_BAD_DBID	CHAR(1)	'D'
POLLING_HISTORY_BAD_FTYPE	CHAR(1)	'F'
POLLING_HISTORY_ERROR	CHAR(1)	'E'
POLLING_HISTORY_TIMED_OUT	CHAR(1)	'T'
POLLING_HISTORY_REMOVED	CHAR(1)	'R'
PRIORITY Constants
PRIO_QUIESCE_RS	PLS_INTEGER	01
PRIO_SPAWN_SBT	PLS_INTEGER	02
PRIO_PURGE_DF_NOW	PLS_INTEGER	10
PRIO_POOL_MAINTENANCE	PLS_INTEGER	12
PRIO_REPAIR_DB	PLS_INTEGER	20
PRIO_STORAGE_HISTOGRAM	PLS_INTEGER	30
PRIO_RESTORE	PLS_INTEGER	40
PRIO_RECONCILE_IMMEDIATE	PLS_INTEGER	45
PRIO_DEFERRED_DELETE	PLS_INTEGER	50
PRIO_GCOPY_COMPUTE	PLS_INTEGER	57
PRIO_PURGE_DUP_DF	PLS_INTEGER	60
PRIO_PURGE_IMMEDIATE	PLS_INTEGER	70
PRIO_COALESCE	PLS_INTEGER	75
PRIO_PURGE_DF	PLS_INTEGER	80
PRIO_DELETE_DB	PLS_INTEGER	85
PRIO_TRIM_DB	PLS_INTEGER	90
PRIO_PURGE	PLS_INTEGER	100
PRIO_NEWDFKEY	PLS_INTEGER	110
PRIO_INSTANCE_CHANGE	PLS_INTEGER	115
PRIO_REQMODE_REQ	PLS_INTEGER	117
PRIO_BACKUP_ARCH	PLS_INTEGER	120
PRIO_PLAN_SBT	PLS_INTEGER	135
PRIO_INDEX_BACKUP	PLS_INTEGER	140
PRIO_POLL	PLS_INTEGER	150
PRIO_BACKUP_SBT	PLS_INTEGER	160
PRIO_RESTORE_SBT	PLS_INTEGER	170
PRIO_PURGE_SBT	PLS_INTEGER	180
PRIO_OBSOLETE_SBT	PLS_INTEGER	190
PRIO_RM_INCOMPLETE_FILES	PLS_INTEGER	200
PRIO_RECONCILE	PLS_INTEGER	210
PRIO_PURGE_DF_LOW	PLS_INTEGER	215
PRIO_MOVE_DF	PLS_INTEGER	220
PRIO_MOVE_ALL_DB	PLS_INTEGER	230
PRIO_CATALOG_CLEANUP	PLS_INTEGER	235
PRIO_DB_STATS_REFRESH	PLS_INTEGER	240
PRIO_RESTORE_RANGE_REFRESH	PLS_INTEGER	250
PRIO_INSERT_FAULT	PLS_INTEGER	290
PRIO_MIN_BUSYWORK	PLS_INTEGER	299
PRIO_OPTIMIZE_CHUNKS_DF	PLS_INTEGER	310
PRIO_OPTIMIZE_CHUNKS	PLS_INTEGER	320
PRIO_REBUILD_INDEX	PLS_INTEGER	325
PRIO_VALIDATE_DB	PLS_INTEGER	330
PRIO_PLAN_DF	PLS_INTEGER	335
PRIO_CHECK_FILES	PLS_INTEGER	340
PRIO_CROSSCHECK_DB	PLS_INTEGER	350
PRIO_TEST_DUMMY	PLS_INTEGER	410
PRIO_MAX_BUSYWORK	PLS_INTEGER	999
QUIESCE Constants
QUIESCE_OFF	BINARY_INTEGER	0
QUIESCE_LIMITED	BINARY_INTEGER	10
QUIESCE_ACTIVE	BINARY_INTEGER	100
REQUEST_PURGE_DF
KBRSJS_PURGE_DF	NUMBER	0
KBRSJS_PURGE_DUP	NUMBER	1
SEVERITY
SEVERITY_WARNING	NUMBER	1
SEVERITY_ERROR	NUMBER	10
SEVERITY_INTERNAL	NUMBER	20
SEVERITY DIAG
SEVERITY_DIAG_GENERIC	NUMBER	-1
SEVERITY_DIAG_VALIDATE	NUMBER	-10
SEVERITY_DIAG_RECONCILE	NUMBER	-20
SEVERITY_DIAG_RM_FILES	NUMBER	-30
SEVERITY_DIAG_RESOURCE	NUMBER	-40
SEVERITY_DIAG_RRANGE	NUMBER	-50
SEVERITY_DIAG_INTERNAL	NUMBER	-60
SEVERITY_DIAG_ORDERING	NUMBER	-70
SEVERITY_DIAG_SUSPENDED	NUMBER	-80
STATE Constants
STATE_EXECUTABLE	PLS_INTEGER	1
STATE_RUNNING	PLS_INTEGER	2
STATE_COMPLETED	PLS_INTEGER	3
STATE_ORDERING_WAIT	PLS_INTEGER	4
STATE_TASK_WAIT	PLS_INTEGER	5
STATE_RESTORE_WAIT	PLS_INTEGER	6
STATE_RETRYING	PLS_INTEGER	7
STATE_FAILED	PLS_INTEGER	8
STATE_CANCEL	PLS_INTEGER	9
STATE_CANCELING	PLS_INTEGER	10
STATE_CANCELED	PLS_INTEGER	11
STATE_PENDING	PLS_INTEGER	12
STATE_TIME_WAIT	PLS_INTEGER	13
STATE_SUSPEND	PLS_INTEGER	14
TASK Constants
TASK_QUIESCE_RS	PLS_INTEGER	00
TASK_SPAWN_SBT	PLS_INTEGER	01
TASK_PURGE_DF_NOW	PLS_INTEGER	10
TASK_POOL_MAINTENANCE	PLS_INTEGER	12
TASK_REPAIR_DB	PLS_INTEGER	20
TASK_STORAGE_HISTOGRAM	PLS_INTEGER	30
TASK_RESTORE	PLS_INTEGER	40
TASK_DEFERRED_DELETE	PLS_INTEGER	55
TASK_GCOPY_COMPUTE	PLS_INTEGER	57
TASK_PURGE_DUP_DF	PLS_INTEGER	60
TASK_PURGE_IMMEDIATE	PLS_INTEGER	70
TASK_COALESCE	PLS_INTEGER	75
TASK_PURGE_DF	PLS_INTEGER	80
TASK_DELETE_DB	PLS_INTEGER	85
TASK_TRIM_DB	PLS_INTEGER	90
TASK_PURGE	PLS_INTEGER	100
TASK_NEWDFKEY	PLS_INTEGER	110
TASK_INSTANCE_CHANGE	PLS_INTEGER	115
TASK_BACKUP_ARCH	PLS_INTEGER	120
TASK_PLAN_SBT	PLS_INTEGER	135
TASK_INDEX_BACKUP	PLS_INTEGER	140
TASK_POLL	PLS_INTEGER	150
TASK_BACKUP_SBT	PLS_INTEGER	160
TASK_RESTORE_SBT	PLS_INTEGER	170
TASK_PURGE_SBT	PLS_INTEGER	180
TASK_OBSOLETE_SBT	PLS_INTEGER	190
TASK_RM_INCOMPLETE_FILES	PLS_INTEGER	200
TASK_RECONCILE	PLS_INTEGER	210
TASK_MOVE_DF	PLS_INTEGER	220
TASK_MOVE_ALL_DB	PLS_INTEGER	230
TASK_CATALOG_CLEANUP	PLS_INTEGER	235
TASK_REQMODE_REQ	PLS_INTEGER	240
TASK_RESERVE_SBT	PLS_INTEGER	250
TASK_INSERT_FAULT	PLS_INTEGER	290
TASK_DB_STATS_REFRESH	PLS_INTEGER	300
TASK_RESTORE_RANGE_REFRESH	PLS_INTEGER	305
TASK_OPTIMIZE_CHUNKS_DF	PLS_INTEGER	310
TASK_OPTIMIZE_CHUNKS	PLS_INTEGER	320
TASK_REBUILD_INDEX	PLS_INTEGER	325
TASK_VALIDATE_DB	PLS_INTEGER	330
TASK_PLAN_DF	PLS_INTEGER	335
TASK_CHECK_FILES	PLS_INTEGER	340
TASK_CROSSCHECK_DB	PLS_INTEGER	350
TASK_TEST_DUMMY	PLS_INTEGER	410
TASK_LAST_EXECUTABLE	PLS_INTEGER	1000
TASK_PRUNED_TIMES	PLS_INTEGER	1990
TASK_SESSION_TIMES	PLS_INTEGER	2000
TASK_ERROR_INFO	PLS_INTEGER	2001
TASK_MIN_API	PLS_INTEGER	10000
TASK_API_ADD_DB	PLS_INTEGER	10000
TASK_API_UPD_DB	PLS_INTEGER	10010
TASK_API_DEL_DB	PLS_INTEGER	10020
TASK_API_REN_DB	PLS_INTEGER	10030
TASK_API_GRANT_DB	PLS_INTEGER	10050
TASK_API_REVOKE_DB	PLS_INTEGER	10060
TASK_API_ADD_SL	PLS_INTEGER	10070
TASK_API_UPD_SL	PLS_INTEGER	10080
TASK_API_DEL_SL	PLS_INTEGER	10090
TASK_API_ADD_PROT_POLICY	PLS_INTEGER	10100
TASK_API_UPD_PROT_POLICY	PLS_INTEGER	10110
TASK_API_DEL_PROT_POLICY	PLS_INTEGER	10120
TASK_API_ADD_POLL_POLICY	PLS_INTEGER	10130
TASK_API_UPD_POLL_POLICY	PLS_INTEGER	10140
TASK_API_DEL_POLL_POLICY	PLS_INTEGER	10150
TASK_API_ADD_SBT_LIB	PLS_INTEGER	10160
TASK_API_UPD_SBT_LIB	PLS_INTEGER	10170
TASK_API_DEL_SBT_LIB	PLS_INTEGER	10180
TASK_API_ADD_RESTRICT_SBT_INST	PLS_INTEGER	10190
TASK_API_DEL_RESTRICT_SBT_INST	PLS_INTEGER	10200
TASK_API_ADD_SBT_ATTR_SET	PLS_INTEGER	10210
TASK_API_UPD_SBT_ATTR_SET	PLS_INTEGER	10220
TASK_API_DEL_SBT_ATTR_SET	PLS_INTEGER	10230
TASK_API_ADD_SBT_JOB	PLS_INTEGER	10240
TASK_API_UPD_SBT_JOB	PLS_INTEGER	10250
TASK_API_DEL_SBT_JOB	PLS_INTEGER	10260
TASK_API_PAU_SBT_LIB	PLS_INTEGER	10270
TASK_API_RES_SBT_LIB	PLS_INTEGER	10280
TASK_API_OLD_ADD_REPOSITORY	PLS_INTEGER	10290
TASK_API_OLD_DEL_REPOSITORY	PLS_INTEGER	10300
TASK_API_ADD_REP_SERVER	PLS_INTEGER	10310
TASK_API_REM_REP_SERVER	PLS_INTEGER	10320
TASK_API_STARTUP	PLS_INTEGER	10330
TASK_API_SHUTDOWN	PLS_INTEGER	10340
TASK_API_ABORT	PLS_INTEGER	10350
TASK_API_CONFIG	PLS_INTEGER	10360
TASK_API_POPULATE	PLS_INTEGER	10370
TASK_API_MOVE_BACKUP	PLS_INTEGER	10380
TASK_API_COPY_BACKUP	PLS_INTEGER	10390
TASK_API_MOVE_BACKUP_PIECE	PLS_INTEGER	10400
TASK_API_COPY_BACKUP_PIECE	PLS_INTEGER	10410
TASK_API_OLD_REP_EXISTING	PLS_INTEGER	10420
TASK_API_OLD_REP_RECONCILE	PLS_INTEGER	10430
TASK_API_OLD_REP_ONE_PIECE	PLS_INTEGER	10440
TASK_API_MIGRATE_TAPE	PLS_INTEGER	10460
TASK_API_PAU_REP_SRV	PLS_INTEGER	10470
TASK_API_RES_REP_SRV	PLS_INTEGER	10480
TASK_API_OLD_REPAIR_SL	PLS_INTEGER	10490
TASK_API_OLD_TESTTASK	PLS_INTEGER	10500
TASK_API_CRE_REP_SERVER	PLS_INTEGER	10510
TASK_API_DEL_REP_SERVER	PLS_INTEGER	10520
TASK_API_UPD_REP_SERVER	PLS_INTEGER	10530
TASK_API_OLD_DEL_BACKUP_PIECE	PLS_INTEGER	10540
TASK_API_OLD_KILL_TASK	PLS_INTEGER	10550
TASK_API_SET_SYS_DESC	PLS_INTEGER	10560
TASK_API_ENCKEY_REKEY	PLS_INTEGER	10570
TASK_API_QUEUE_SBT_BACKUP	PLS_INTEGER	10580
TASK_API_CREUPG	PLS_INTEGER	14998
TASK_MAX_API	PLS_INTEGER	14999
TASK_MIN_INTAPI	PLS_INTEGER	TASK_MAX_API + 1
TASK_INTAPI_TESTTASK	PLS_INTEGER	15000
TASK_INTAPI_DEL_BACKUP_PIECE	PLS_INTEGER	15010
TASK_INTAPI_KILL_TASK	PLS_INTEGER	15020
TASK_INTAPI_REP_ADD_REPO	PLS_INTEGER	15030
TASK_INTAPI_REP_DEL_REPO	PLS_INTEGER	15040
TASK_INTAPI_REP_EXISTING	PLS_INTEGER	15050
TASK_INTAPI_REP_RECONCILE	PLS_INTEGER	15060
TASK_INTAPI_REP_ONE_PIECE	PLS_INTEGER	15070
TASK_INTAPI_REP_NET_GRANT	PLS_INTEGER	15080
TASK_INTAPI_REP_NET_REVOKE	PLS_INTEGER	15090
TASK_INTAPI_VALIDATE_BP	PLS_INTEGER	15100
TASK_INTAPI_REBLD_BLK_POOL	PLS_INTEGER	15110
TASK_INTAPI_REBLD_BLOCKS	PLS_INTEGER	15120
TASK_INTAPI_RELEASE_ORPHANED	PLS_INTEGER	15130
TASK_INTAPI_RELEASE_TASK	PLS_INTEGER	15134
TASK_INTAPI_ADD_REP_SERVER_ALT	PLS_INTEGER	15140
TASK_INTAPI_REPAIR_SL	PLS_INTEGER	15150
TASK_INTAPI_ENCKEY_CREATE	PLS_INTEGER	15160
TASK_INTAPI_ENCKEY_TAG_UPDATE	PLS_INTEGER	15170
TASK_INTAPI_VALIDATE_DB	PLS_INTEGER	15180
TASK_INTAPI_PLAN_BP	PLS_INTEGER	15190
TASK_INTAPI_RMTRA_PROBE	PLS_INTEGER	15200
TASK_INTAPI_RETRY_TASK	PLS_INTEGER	15210
TASK_INTAPI_RMTRA_REQBU	PLS_INTEGER	15220
TASK_INTAPI_RMTRA_QREQBU	PLS_INTEGER	15230
TASK_INTAPI_RMTRA_REQCALC	PLS_INTEGER	15240
TASK_MAX_INTAPI	PLS_INTEGER	16000
TASKS Constants
TASKS_RECEIVED_BACKUP	NUMBER	TO_NUMBER('0001','XXXX')
TASKS_BLOCKING_TASK	NUMBER	TO_NUMBER('0002','XXXX')
TASKS_NO_ORDERING_WAIT	NUMBER	TO_NUMBER('0004','XXXX')
TASKS_DELETE_INPUT	NUMBER	TO_NUMBER('0008','XXXX')
TASKS_POLLED_INPUT	NUMBER	TO_NUMBER('0010','XXXX')
TASKS_CHUNK_CACHE_ACTIVE	NUMBER	TO_NUMBER('0020','XXXX')
TASKS_TOO_MANY_INTERRUPTS	NUMBER	TO_NUMBER('0040','XXXX')
TASKS_CANCEL_PENDING	NUMBER	TO_NUMBER('0080','XXXX')
TASKS_ABANDONED_TASK	NUMBER	TO_NUMBER('0100','XXXX')
TASKS_START_IN_WAIT	NUMBER	TO_NUMBER('0200','XXXX')
TIMER
TIMER_RELOAD_CONFIG	NUMBER	0
TIMER_VERIFY	NUMBER	1
TIMER_POLLING	NUMBER	2
TIMER_HISTORY_PRUNE	NUMBER	3
TIMER_RM_INCOMPLETE_FILES	NUMBER	4
TIMER_STORAGE_HISTOGRAM	NUMBER	5
TIMER_STORAGE_MAINTENANCE	NUMBER	6
TIMER_TASK_MAINTENANCE	NUMBER	7
TIMER_OBSOLETE_SBT	NUMBER	8
TIMER_RECONCILE	NUMBER	9
TIMER_SPAWN_SBT	NUMBER	10
TIMER_SET_RECONCILE_TIMER	NUMBER	11
TIMER_DB_STATS_REFRESH	NUMBER	12
TIMER_RM_SBT_SESSION	NUMBER	15
TIMER_DEAD_SCHEDULERS	NUMBER	16
TIMER_RESTART_RESTORE	NUMBER	17
Miscellaneous
GEN_EXEC_PRIORITY	NUMBER	TO_NUMBER('0001','XXXX')
KEY_PURGELOCK_REBUILD_INDEX	NUMBER	1025
IS_ARCH_GRP_TASK	NUMBER	-1
DB_STATE_IN_DELETE	NUMBER	1
DB_TASK_IS_BENIGN	NUMBER	1
DB_TASK_IS_NOT_BENIGN	NUMBER	2
SERVLET_PSEUDO_TASK	NUMBER	-1
SPACE_PSEUDO_TASK	NUMBER	-2
OPT_DF_PSEUDO_TASK	NUMBER	-3
TEST_PSEUDO_TASK	NUMBER	-4
RESOURCE_PSEUDO_TASK	NUMBER	-5
STALL_PSEUDO_TASK	NUMBER	-6
LIBRARY_PSEUDO_TASK	NUMBER	-7
POOL_FULL_PSEUDO_TASK	NUMBER	-8
RECON_WAIT_PSEUDO_TASK	NUMBER	-9
PURGE_PSEUDO_TASK	NUMBER	-10
RAPOOL_PSEUDO_TASK	NUMBER	-11
MAX_RESOURCE_WAIT_PROCESSES	NUMBER	99999

Data Types SUBTYPE interrupt_t IS BINARY_INTEGER RANGE 1..2;

Dependencies

* This 19c dependency will require updating to DBMS_LOG in 21c due to the movement of the Alert Log writing procedures.

ALL_BACKUPS	EM_AGG_SBT_LIB_KEY	SBT_ATTR_SET
AMRV$MSG	EM_AGG_SBT_PROT_KEY	SBT_CATALOG
ARCH_GROUP_TASK	EM_AGG_SBT_TEMPLATE_KEY	SBT_JOB_TEMPLATE
BDF	ERROR_LOG	SBT_LIB_DESC
BDFDF	GV$CONTAINERS	SBT_SESSION
BLOCKS_PARTITIONS	GV$INSTANCE	SBT_TASK
BP	GV$SESSION	SBT_TASK_CACHE
BS	INSTANCE_TIMES	SBT_TASK_HISTORY
CHUNKS_OLD##	NODE	SBT_TEMPLATE_DB
CONFIG	ODB	SBT_TEMPLATE_DF
DB	ODB_STATS_CACHE	SESSIONS
DBA_DATA_FILES	PDBINC	SL
DBA_FREE_SPACE	PENDING_PURGE_DF	STORAGE_DESTS
DBA_REDO_LOG	PLANS	STORAGE_HISTOGRAM
DBINC	PLANS_DETAILS	TASK
DBMS_APPLICATION_INFO	POLL	TASK_CHUNK_CACHE
DBMS_BACKUP_RESTORE	POLLING_HISTORY	TASK_HISTORY
DBMS_LOCK	PROT	TIMER_TASK
DBMS_RCVCAT	RAI_ACTIVE_INSTANCES	UNREG_DATABASE
DBMS_RCVMAN	RAI_DEBUG_WHEN	USER_FREE_SPACE
DBMS_SCHEDULER	RAI_DISK_RESTORE_RANGE	USER_IND_PARTITIONS
DBMS_SESSION	RAI_INTERRUPT_WHEN	USER_SCHEDULER_JOBS
DBMS_SPACE	RAI_JS_GVLOCKS	USER_SCHEDULER_JOB_RUNNING_DETAILS
DBMS_SYSTEM *	RAI_JS_LOCKS	USER_SCHEDULER_RUNNING_JOBS
DBMS_SYS_ERROR	RAI_JS_SEARCH_FILE	USER_SEGMENTS
DBMS_UTILITY	RAI_MY_OSPID	USER_TAB_PARTITIONS
DBSL	RAI_RECOVERY_WINDOW_SPACE	VBDF
DF	RAI_RESTORE_RANGE	V_$ACTIVE_INSTANCES
DF_SEQ	RAI_SBT_RESTORE_RANGE	V_$DATABASE_INCARNATION
DROP_CONTAINER_GROUP	RAI_STALL_WHEN	V_$DIAG_INFO
DUAL	RAI_UNPROTECTED_WINDOW	V_$DLM_RESS
EM_AGG_REFRESH_TIME	RC	V_$INSTANCE
EM_AGG_SBT_DB_KEY	REP_PAIR	V_$PARAMETER
EM_AGG_SBT_FLAT	REP_SERVER

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.

Subprograms

ASSERT_OWNER	NEWDFKEY	SCHEDLOCK
AVOID_DB	NEW_TASK	SCHEDULE
AVOID_SL	NEW_TIMER_TASK	SCHEDUNLOCK
CHECK_FOR_INTERRUPT	PURGE_IMMEDIATE	SETDATABASE
CREATE_REPLICATION_TASKS	QUEUE_ONE_SBT_BACKUP_TASK	SETTRACING
DELETE_DB_TASK_IS_BENIGN	QUEUE_RECONCILE_TASKS	SET_BLOCKING_PURGE
ENQUEUE_TIMER_RELOAD_CONFIG	QUEUE_REPLICATION_TASK	SET_STALL_TASKS
ENQUEUE_VERIFY_TIMER_TASK	QUEUE_RESTORE_TASK	SHOW_LOCKS
EXECUTER	QUEUE_SBT_BACKUP_TASK	SPAWN_JOB
FIXUP_ORDWAIT_ERROR	QUEUE_SPAWN_SBT	SPAWN_PURGE_IMMEDIATE
FIX_ERROR	QUIESCE_RS	STALLMODECHECK
GET_LOCK	QUIESCE_STATE	STOP
GET_LOCK_DIRECT_WAITABLE	RAISE_PURGE_PRIORITY	STOP_SCHEDULER_JOBS
GET_SAVEPOINT	RELEASE_BLOCKED_TASKS	TASKSTATE2NAME
INIT	RELEASE_ORDERING_WAIT	TASKTYPE2NAME
INTERRUPT_TASKS	RELEASE_RESTORE_WAIT	TESTTASK
INTERVAL2SECS	RELEASE_WAITING_TASK	TIMER_FUNCTIONS
KILL_JOB	REPAIR_RS	TYPE2PRIORITY
KILL_TASK	REQUEST_PURGE_DF	UNLOCK
LOAD_CONFIG	RESET_ERROR	UNQUIESCE_RS
LOG_ERROR	RESET_RECONCILE_TIMER	WAIT_FOR_RESOURCE
MAKE_AMJOBS	RESTART_TIMER_PROCESS	WRITE_ERROR
MAKE_AMLOCKS	RUN_POOL_MAINTENANCE_TASK

ASSERT_OWNER

Undocumented dbms_ra_scheduler.assert_owner;

exec dbms_ra_scheduler.assert_owner;

AVOID_DB

Undocumented dbms_ra_scheduler.avoid_db(p_db_key IN NUMBER);

TBD

AVOID_SL

Undocumented dbms_ra_scheduler.avoid_sl( p_type IN NUMBER, -- TASK_PURGE or TASK_INDEX_BACKUP p_slkey IN NUMBER);

TBD

CHECK_FOR_INTERRUPT

Undocumented dbms_ra_scheduler.check_for_interrupt(p_state IN NUMBER DEFAULT NULL);

TBD

CREATE_REPLICATION_TASKS

Undocumented dbms_ra_scheduler.create_replication_tasks( p_db_key IN NUMBER, p_bp_key IN NUMBER DEFAULT NULL, p_bs_key IN NUMBER DEFAULT NULL, p_piece_no IN NUMBER DEFAULT NULL, 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);

TBD

DELETE_DB_TASK_IS_BENIGN

Undocumented dbms_ra_scheduler.delete_db_task_is_benign(p_task_type IN NUMBER) RETURN NUMBER;

TBD

ENQUEUE_TIMER_RELOAD_CONFIG

Undocumented dbms_ra_scheduler.enqueue_timer_reload_config;

exec dbms_ra_scheduler.enqueue_timer_reload_config;

ENQUEUE_VERIFY_TIMER_TASK

Undocumented dbms_ra_scheduler.enqueue_verify_timer_task;

exec dbms_ra_scheduler.enqueue_verify_timer_task;

EXECUTER

Undocumented dbms_ra_scheduler.executer( p_sched_type IN NUMBER DEFAULT NULL, p_param1 IN NUMBER DEFAULT NULL, p_param2 IN NUMBER DEFAULT NULL, p_settrace IN NUMBER DEFAULT NULL);

TBD

FIXUP_ORDWAIT_ERROR

Undocumented dbms_ra_scheduler.fixup_ordwait_error( p_dbkey IN NUMBER, p_bpkey IN NUMBER);

TBD

FIX_ERROR

Undocumented dbms_ra_scheduler.fix_error( p_error_num IN NUMBER, p_sl_key IN NUMBER DEFAULT NULL, p_db_key IN NUMBER DEFAULT NULL, p_tkey IN NUMBER DEFAULT NULL, p_param_char IN VARCHAR2 DEFAULT NULL, p_param_num IN NUMBER DEFAULT NULL, p_param_num2 IN NUMBER DEFAULT NULL, p_param_num3 IN NUMBER DEFAULT NULL, p_timestamp IN TIMESTAMP WITH TIME ZONE DEFAULT NULL);

TBD

GET_LOCK

Undocumented dbms_ra_scheduler.get_lock( p_type IN NUMBER, p_key IN NUMBER, p_mode IN NUMBER); -- DEFAULT sys.kbrsi_icd.LOCK_MODE_KSQMX)

TBD

GET_LOCK_DIRECT_WAITABLE

Undocumented dbms_ra_scheduler.get_lock_direct_waitable( p_type IN NUMBER, p_key IN NUMBER, wait_time_in_seconds IN NUMBER, p_mode IN NUMBER DEFAULT sys.kbrsi_icd.LOCK_MODE_KSQMX)

TBD

GET_SAVEPOINT

Undocumented dbms_ra_scheduler.get_savepoint RETURN NUMBER;

TBD

INIT

Undocumented dbms_ra_scheduler.init( p_instance_only IN BOOLEAN DEFAULT FALSE, p_repair IN BOOLEAN DEFAULT FALSE);

TBD

INTERRUPT_TASKS

Undocumented dbms_ra_scheduler.interrupt_tasks( p_interrupt IN interrupt_t, p_task_id IN NUMBER DEFAULT NULL, p_db_key IN NUMBER DEFAULT NULL);

TBD

INTERVAL2SECS

Undocumented dbms_ra_scheduler.interval2secs(p_interval IN DSINTERVAL_UNCONSTRAINED) RETURN NUMBER;

TBD

KILL_JOB

Undocumented dbms_ra_scheduler.kill_job( p_job_name IN VARCHAR2, p_error IN BOOLEAN) RETURN BOOLEAN;

TBD

KILL_TASK

Undocumented dbms_ra_scheduler.kill_task(p_task_id IN NUMBER);

TBD

LOAD_CONFIG

Undocumented dbms_ra_scheduler.load_config;

exec dbms_ra_scheduler.load_config;

LOG_ERROR

Undocumented dbms_ra_scheduler.log_error( p_errno IN NUMBER, p_param1 IN VARCHAR2 DEFAULT NULL, p_param2 IN VARCHAR2 DEFAULT NULL, p_param3 IN VARCHAR2 DEFAULT NULL, p_param4 IN VARCHAR2 DEFAULT NULL, p_keep_stack IN BOOLEAN DEFAULT TRUE, p_component IN VARCHAR2, p_severity IN NUMBER, p_sl_key IN NUMBER DEFAULT NULL, p_db_key IN NUMBER DEFAULT NULL, p_tkey IN NUMBER DEFAULT NULL, p_param_char IN VARCHAR2 DEFAULT NULL, p_param_num IN NUMBER DEFAULT NULL, p_param_num2 IN NUMBER DEFAULT NULL, p_param_num3 IN NUMBER DEFAULT NULL, p_sbt_session_id IN VARCHAR2 DEFAULT NULL, p_task_id IN NUMBER DEFAULT NULL);

TBD

MAKE_AMJOBS

Undocumented dbms_ra_scheduler.make_amjobs(name IN VARCHAR2 DEFAULT 'RA$%');

TBD

MAKE_AMLOCKS

Undocumented dbms_ra_scheduler.make_amlocks;

exec dbms_ra_scheduler.make_amlocks;

NEWDFKEY

Undocumented dbms_ra_scheduler.newdfkey( p_dfkey IN NUMBER, p_dbinckey IN NUMBER, p_pdbinckey IN NUMBER);

TBD

NEW_TASK

Undocumented dbms_ra_scheduler.new_task( task_rec IN OUT task%ROWTYPE, p_commit IN BOOLEAN DEFAULT TRUE, p_delay IN BOOLEAN DEFAULT FALSE, p_sbt_task IN BOOLEAN DEFAULT FALSE, p_priority_set IN BOOLEAN DEFAULT FALSE);

TBD

NEW_TIMER_TASK

Undocumented dbms_ra_scheduler.new_timer_task( p_timer IN OUT NOCOPY timer_task%ROWTYPE, p_dups_ok IN BOOLEAN);

TBD

PURGE_IMMEDIATE

Undocumented dbms_ra_scheduler.purge_immediate( p_sl_key IN NUMBER, p_db_key IN NUMBER, p_allocation IN NUMBER);

TBD

QUEUE_ONE_SBT_BACKUP_TASK

Undocumented dbms_ra_scheduler.queue_one_sbt_backup_task( p_db_key IN NUMBER, p_bs_key IN NUMBER, p_piece_no IN NUMBER, p_template_key IN NUMBER, p_full_template_key IN NUMBER, p_attr_set_key IN NUMBER, p_lib_key IN NUMBER, p_copies IN NUMBER, p_src_bpkey IN NUMBER DEFAULT NULL, p_delete_source IN VARCHAR2 DEFAULT 'N', p_format IN VARCHAR2 DEFAULT NULL, p_rep_server_key IN NUMBER DEFAULT NULL, p_compression_algo IN VARCHAR2 DEFAULT NULL, p_encryption_algo IN VARCHAR2 DEFAULT NULL, p_autobackup_prefix IN VARCHAR2 DEFAULT NULL, p_tag IN VARCHAR2 DEFAULT NULL, p_is_arch_backup IN BOOLEAN DEFAULT FALSE, p_sbt_task_id OUT NUMBER) RETURN BOOLEAN;

TBD

QUEUE_RECONCILE_TASKS

Undocumented dbms_ra_scheduler.queue_reconcile_tasks( p_prot_key IN NUMBER DEFAULT NULL, p_db_key IN NUMBER DEFAULT NULL, p_immediate IN BOOLEAN DEFAULT FALSE, p_override_reqonly IN BOOLEAN DEFAULT FALSE);

TBD

QUEUE_REPLICATION_TASK

Undocumented dbms_ra_scheduler.queue_replication_task( p_bp_key IN NUMBER, p_handle IN VARCHAR2, p_db_key IN NUMBER, p_bs_key IN NUMBER, p_piece_no IN NUMBER, p_rep_server_key IN NUMBER, p_sbt_template_key IN NUMBER, p_sbt_attr_set_key IN NUMBER, p_sbt_lib_key IN NUMBER);

TBD

QUEUE_RESTORE_TASK

Undocumented dbms_ra_scheduler.queue_restore_task( request_id IN NUMBER, sbt_sessionid IN VARCHAR2, handle IN VARCHAR2);

TBD

QUEUE_SBT_BACKUP_TASK

Undocumented dbms_ra_scheduler.queue_sbt_backup_task( template_name IN VARCHAR2, src_bpkey IN NUMBER DEFAULT NULL, delete_source IN VARCHAR2 DEFAULT 'N', format IN VARCHAR2 DEFAULT NULL, compression_algo IN VARCHAR2 DEFAULT NULL, encryption_algo IN VARCHAR2 DEFAULT NULL, autobackup_prefix IN VARCHAR2 DEFAULT NULL, tag IN VARCHAR2 DEFAULT NULL);

TBD

QUEUE_SPAWN_SBT

Undocumented dbms_ra_scheduler.queue_spawn_sbt( p_libkey IN NUMBER, p_forpurge IN BOOLEAN, p_check_work IN BOOLEAN DEFAULT FALSE);

TBD

QUIESCE_RS

Undocumented dbms_ra_scheduler.quiesce_rs;

exec dbms_ra_scheduler.quiesce_rs;

QUIESCE_STATE

Returns one of the Quiesce State constants dbms_ra_scheduler.quiesce_state RETURN BINARY_INTEGER;

DECLARE

       retVal BINARY_INTEGER;

      BEGIN

        retVal :=  dbms_ra_scheduler.quiesce_state;

        dbms_output.put_line(retVal);

      END;

      /

      100

RAISE_PURGE_PRIORITY

Undocumented dbms_ra_scheduler.raise_purge_priority(p_dfkey IN NUMBER);

TBD

RELEASE_BLOCKED_TASKS

Undocumented dbms_ra_scheduler.release_blocked_tasks( p_task_id IN NUMBER, p_db_key IN NUMBER DEFAULT NULL);

TBD

RELEASE_ORDERING_WAIT

Undocumented dbms_ra_scheduler.release_ordering_wait(p_dbkey IN NUMBER);

TBD

RELEASE_RESTORE_WAIT

Undocumented dbms_ra_scheduler.release_restore_wait( p_instance IN NUMBER DEFAULT NULL, p_schedislocked IN BOOLEAN DEFAULT FALSE);

TBD

RELEASE_WAITING_TASK

Undocumented dbms_ra_scheduler.release_waiting_task( p_task_id IN NUMBER DEFAULT NULL, p_defer IN BOOLEAN DEFAULT FALSE);

TBD

REPAIR_RS

Undocumented dbms_ra_scheduler.repair_rs;

exec dbms_ra_scheduler.repair_rs;

REQUEST_PURGE_DF

Undocumented dbms_ra_scheduler.request_purge_df( p_db_key IN NUMBER, p_df_key IN NUMBER, p_type IN NUMBER DEFAULT KBRSJS_PURGE_DF);

TBD

RESET_ERROR

Undocumented dbms_ra_scheduler.reset_error( p_incident# IN NUMBER DEFAULT NULL, p_tkey IN NUMBER DEFAULT NULL, p_error_code IN NUMBER DEFAULT NULL, p_error_text IN VARCHAR2 DEFAULT NULL, p_task_id IN NUMBER DEFAULT NULL, p_component IN VARCHAR2 DEFAULT NULL, p_low_time IN TIMESTAMP WITH TIME ZONE DEFAULT NULL, p_high_time IN TIMESTAMP WITH TIME ZONE DEFAULT NULL);

TBD

RESET_RECONCILE_TIMER

Undocumented dbms_ra_scheduler.reset_reconcile_timer(p_execute_asap IN BOOLEAN DEFAULT FALSE);

TBD

RESTART_TIMER_PROCESS

Undocumented dbms_ra_scheduler.restart_timer_process(do_check IN BOOLEAN) RETURN NUMBER;

TBD

RUN_POOL_MAINTENANCE_TASK

Undocumented dbms_ra_scheduler.run_pool_maintenance_task(p_sl_key IN NUMBER);

TBD

SCHEDLOCK

Undocumented dbms_ra_scheduler.schedlock(p_info IN VARCHAR2);

TBD

SCHEDULE

Undocumented dbms_ra_scheduler.schedule;

exec dbms_ra_scheduler.schedule;

SCHEDUNLOCK

Undocumented dbms_ra_scheduler.schedunlock;

exec dbms_ra_scheduler.schedunlock;

SETDATABASE

Undocumented dbms_ra_scheduler.setDatabase( p_dbkey IN NUMBER, p_dbid OUT NUMBER, p_currinc OUT NUMBER, p_db_slkey OUT NUMBER);

TBD

SETTRACING

Undocumented dbms_ra_scheduler.setTracing( p_trc_on IN NUMBER, p_perf_on IN NUMBER DEFAULT 0, p_stall_on IN NUMBER DEFAULT 0, p_safe_mode IN NUMBER DEFAULT 0);

TBD

SET_BLOCKING_PURGE

Undocumented dbms_ra_scheduler.set_blocking_purge( p_dbkey IN NUMBER, p_space IN NUMBER DEFAULT NULL) RETURN NUMBER;

TBD

SET_STALL_TASKS

Undocumented dbms_ra_scheduler.set_stall_tasks;

exec dbms_ra_scheduler.set_stall_tasks;

SHOW_LOCKS

Undocumented dbms_ra_scheduler.show_locks( p_type IN NUMBER, p_key IN NUMBER);

TBD

SPAWN_JOB

Undocumented dbms_ra_scheduler.spawn_job( p_name IN VARCHAR2, p_action IN VARCHAR2, p_instance IN NUMBER, p_comments IN VARCHAR2);

TBD

SPAWN_PURGE_IMMEDIATE

Undocumented dbms_ra_scheduler.spawn_purge_immediate( p_sl_key IN NUMBER, p_db_key IN NUMBER, p_allocation IN NUMBER, p_job_name OUT VARCHAR2);

TBD

STALLMODECHECK

Undocumented dbms_ra_scheduler.stallmodecheck;

exec dbms_ra_scheduler.stallmodecheck;

STOP

Undocumented dbms_ra_scheduler.stop(p_quiesce_first IN BOOLEAN DEFAULT FALSE);

TBD

STOP_SCHEDULER_JOBS

Undocumented dbms_ra_scheduler.stop_scheduler_jobs;

exec dbms_ra_scheduler.stop_scheduler_jobs;

TASKSTATE2NAME

Undocumented dbms_ra_scheduler.taskstate2name( p_task_state IN NUMBER, p_pending_interrupt IN NUMBER DEFAULT 0) RETURN VARCHAR2;

TBD

TASKTYPE2NAME

Undocumented dbms_ra_scheduler.tasktype2name(p_task_type IN NUMBER) RETURN VARCHAR2;

TBD

TESTTASK

Undocumented dbms_ra_scheduler.testTask( p_taskid IN NUMBER DEFAULT NULL, p_tasktype IN NUMBER DEFAULT NULL, p_num1 IN NUMBER DEFAULT NULL, p_num2 IN NUMBER DEFAULT NULL, p_num3 IN NUMBER DEFAULT NULL, p_num4 IN NUMBER DEFAULT NULL, p_num5 IN NUMBER DEFAULT NULL, p_char1 IN VARCHAR2 DEFAULT NULL, p_char2 IN VARCHAR2 DEFAULT NULL, p_param IN VARCHAR2 DEFAULT NULL, p_slkey IN NUMBER DEFAULT NULL, p_dbkey IN NUMBER DEFAULT NULL, p_settrace IN NUMBER DEFAULT NULL, p_newsession IN BOOLEAN DEFAULT FALSE, p_wait IN BOOLEAN DEFAULT TRUE);

TBD

TIMER_FUNCTIONS

Undocumented dbms_ra_scheduler.timer_functions;

exec dbms_ra_scheduler.timer_functions;

TYPE2PRIORITY

Undocumented dbms_ra_scheduler.

TBD

UNLOCK

Undocumented dbms_ra_scheduler.unlock( p_type IN NUMBER, p_key IN NUMBER);

TBD

UNQUIESCE_RS

Undocumented dbms_ra_scheduler.unquiesce_rs;

exec dbms_ra_scheduler.unquiesce_rs;

WAIT_FOR_RESOURCE

Undocumented dbms_ra_scheduler.wait_for_resource( request_id IN NUMBER, handle IN VARCHAR2) RETURN BINARY_INTEGER;

TBD

WRITE_ERROR

Undocumented dbms_ra_scheduler.write_error( p_component IN VARCHAR2, p_severity IN NUMBER, p_sl_key IN NUMBER DEFAULT NULL, p_db_key IN NUMBER DEFAULT NULL, p_tkey NUMBER IN DEFAULT NULL, p_param_char IN VARCHAR2 DEFAULT NULL, p_param_num IN NUMBER DEFAULT NULL, p_param_num2 IN NUMBER DEFAULT NULL, p_param_num3 IN NUMBER DEFAULT NULL, p_sbt_session_id IN VARCHAR2 DEFAULT NULL, p_task_id IN NUMBER DEFAULT NULL);

TBD