Oracle | DBMS_RA

Oracle DBMS_RA_DUMP Version 21c

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Recovery Appliance (Recovery Appliance) Backup and Recovery support utility.

AUTHID DEFINER

Dependencies

ALL_DIRECTORIES	DF	KU$_STATUS
CONFIG	KBRSI_ICD	PLITBLM
DBMS_DATAPUMP	KU$_LOGENTRY	SERVER
DBMS_LOCK	KU$_LOGLINE1010	UTL_FILE
DBMS_SQL

Documented No

First Available Not known

Security Model Owned by RMAN catalog owner with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/recover.bsq

Compilation requires sys.kbrsi_icd be installed and execute be granted to the RMAN catalog owner.

DUMPER

Undocumented dbms_ra_dump.dumper( ospid IN VARCHAR2, quiesce IN BOOLEAN DEFAULT FALSE, datapumpdump IN BOOLEAN DEFAULT NULL, blocks IN BOOLEAN DEFAULT NULL, chunks IN BOOLEAN DEFAULT NULL, db_key IN NUMBER DEFAULT NULL, df_key IN NUMBER DEFAULT NULL);

-- from recover.bsq 
      reformatted for clarity

      

      dbms_scheduler.create_job(

       job_name   => l_job_name,

       job_type   => 'plsql_block',

       job_action => 'dbms_ra_dump.dumper(' || l_ospid || ',FALSE, NULL);',

       enabled    => TRUE,

       auto_drop  => TRUE);