Oracle | DBMS_RA

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

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