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