Oracle | DBMS_RA

Oracle DBMS_RA_DUMP 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.

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