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.
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);
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);
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);
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)
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);
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);
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;
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);
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);
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);
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);
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);
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);