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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_BACKUP_RESTORE
DBMS_RA
DBMS_RA_DUMP
DBMS_RA_INT
DBMS_RA_MISC
DBMS_RA_POOL
DBMS_RA_SBT
DBMS_RA_STORAGE
KBRSI_ICD
RMAN
What's New In 21c
What's New In 23c

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