Oracle DBMS_BA_POOL
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Do you remember when mainframes were replaced by client-server? When client-server was replaced by n-tier architecture? The "Cloud" is a distraction ... DevOps is not. Prepare for the future.
Purpose While this package is undocumented it clearly is related to RMAN.

This package was present in 12.1.0.2 only and will be dropped from the Library with the release of Oracle Database 18.1.
AUTHID CURRENT_USER
Constants
Name Data Type Value
AM
AM_DEBUG_ON NUMBER 1
AM_DEBUG_LOW NUMBER 2
AM_DEBUG_MED NUMBER 3
AM_DEBUG_HIGH NUMBER 4
AM_DEBUG_OFF NUMBER 5
KBRSOPER
KBRSOPER_CLSPOST NUMBER 1
KBRSOPER_POST NUMBER 2
KBRSOPER_RELEASE NUMBER 3
KBRSOPER_COPY NUMBER 4
KBRSOPER_DEL NUMBER 5
KBRSOPER_NEWFILE NUMBER 6
KBRSOPER_NEXT NUMBER 7
KBRSOPER_DONE NUMBER 8
KBRSPLBLD
KBRSPLBLD_PIECE NUMBER 1
KBRSPLBLD_PURGE NUMBER 2
KBRSPLBLD_SMALLPURGE NUMBER 3
KBRSPLBLD_OPTPURGE NUMBER 4
KBRSPLBLD_ALLPURGE NUMBER 5
KBRSPLBLD_OPTIMIZE NUMBER 6
KBRSPLBLD_DUPPURGE NUMBER 7
KBRSPLBLD_ORIGPIECE NUMBER 8
KBRSPLBLD_FULLPIECE NUMBER 10
KBRSPLBLD_PURGEBIG NUMBER 11
VBDF
VBDF_COMPLETE NUMBER 1
VBDF_BUILDING NUMBER 2
VBDF_ABORT NUMBER 3
VBDF_FIN_NOBP NUMBER 4
VBDF_CLEANUP NUMBER 5
VBDF_REPOPULATE NUMBER 6
VBDF_OBSOLETE NUMBER 7
VBDF_REPAIR NUMBER 8
NTFN
BIGNUM NUMBER 1E40
KSCNINV NUMBER 281474976710655
CHUNK
CHUNK_NOT_SHARED NUMBER 1
CHUNK_OWNER NUMBER 2
CHUNK_DEPENDENT NUMBER 3
KBRS_SAVE_INFO
KBRS_SAVE_INFO_POOL NUMBER 1
KBRS_SAVE_INFO_CFFILE NUMBER 2
KBRS_SAVE_INFO_SPFILE NUMBER 3
Data Types TYPE nolst IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

TYPE nmlst IS TABLE OF VARCHAR2(30) INDEX BY BINARY INTEGER;
Dependencies
     
     
     
Documented No
Exceptions
Error Code Reason
   
   
   
First Available 12.1.0.2
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/recover.bsq
Subprograms
 
BEGIN_DF
Begin Data File dbms_ba_pool.begin_df(
p_vbkey     IN OUT NUMBER,  -- virtual backup ID
p_ckpid     IN OUT NUMBER,  -- ckp_scn --> ckp_id
p_dbid      IN     NUMBER,  -- database ID
p_fno       IN     NUMBER,  -- datafile number
p_blocks    IN     NUMBER,  -- (opt) Datafile size in blocks
p_incrscn   IN     NUMBER,  -- (opt) Incr_scn for backup
p_crescn    IN     NUMBER,  -- (opt) Datafile creation scn
p_crestamp  IN     NUMBER,  -- (opt) Datafile creation time
p_rstscn    IN     NUMBER,  -- (opt) reset scn
p_rststamp  IN     NUMBER,  -- (opt) reset stamp
p_dfkey        OUT NUMBER,  -- datafile key
p_dbkey        OUT NUMBER,  -- database key
p_dbinckey     OUT NUMBER,  -- database incarnation key
p_unorderid    OUT NUMBER,  -- (opt) max(unorder_id)
p_firstblk  IN     NUMBER,  -- first block
p_lastblk   IN     NUMBER); -- last block
TDE
 
BUILD_READ_PLAN
Undocumented dbms_ba_pool.build_read_plan(
p_dbkey   IN  NUMBER,  -- Database key
p_vbkey   IN  NUMBER,  -- Virtual backup id
p_dfkey   IN  NUMBER,  -- Datafile key
p_bufsize IN  NUMBER,  -- size of read buffers
p_type    IN  NUMBER,  -- KBRSBLD_ type
p_chunks  IN  NUMBER,  -- Number of chunks to write.
p_stored  OUT NUMBER); -- Is 1 if plan was stored
TDE
 
DELETEVB
Undocumented dbms_ba_pool.deleteVB(
p_slkey   IN NUMBER,
p_dbkey   IN NUMBER,
p_currinc IN NUMBER,
p_bpkey   IN NUMBER,
p_noplans IN BOOLEAN,
p_notasks IN BOOLEAN);
TDE
 
END_DF
End Data File dbms_ba_pool.end_df(
p_vbkey   IN NUMBER,               -- virtual backup ID
p_dfkey   IN NUMBER,               -- datafile key
p_relfno  IN NUMBER,               -- backupset relative file num
p_ckpscn  IN NUMBER,               -- checkpoint scn
p_absscn  IN NUMBER,               -- absolute fuzzy scn
p_repair  IN BOOLEAN,              -- true if repair in progress
p_cmpvsn  IN NUMBER,               -- backup version#
p_issft   IN NUMBER,               -- iS Single File Tablespace
p_unorder IN NUMBER,               -- 1 if gap block found
p_replev  IN NUMBER DEFAULT NULL); -- repair incr level
TDE
 
INCRLEVEL
Undocumented dbms_ba_pool.incrLevel(p_create_scn IN NUMBER, -- bdf.create_scn
p_incr_scn      IN NUMBER, -- bdf.incr_scn
p_create_size   IN NUMBER, -- df.create_size
p_create_thread IN NUMBER) -- df.create_thread
RETURN NUMBER;
TDE
 
MOVEDF
Move Data File dbms_ba_pool.moveDF(
p_dbkey IN NUMBER,  -- database key
p_dfkey IN NUMBER); -- datafile key
TDE
 
NOT_TAPED
Undocumented dbms_ba_pool.not_taped(p_dbkey IN NUMBER) RETURN NUMBER;
TDE
 
OBSOLETEPLANS
Undocumented dbms_ba_pool.obsoletePlans(p_dfkey IN NUMBER,
p_chk_krbph IN NUMBER DEFAULT 1,
p_lock      IN NUMBER DEFAULT 1);
TDE
 
OK4POOL
Undocumented dbms_ba_pool.ok4pool(
p_dbkey    IN  NUMBER,
p_bpkey    IN  NUMBER,
p_update   IN  BOOLEAN,
p_hasdups  OUT BOOLEAN,
p_nofityet OUT BOOLEAN,
p_isok     OUT BOOLEAN);
TDE
 
OPTIMIZEDF
Optimize Data File dbms_ba_pool.optimizeDF(
p_dbkey IN NUMBER,  -- database key
p_dfkey IN NUMBER); -- datafile key
TDE
 
PLANDF
Undocumented dbms_ba_pool.planDF(
p_type   IN NUMBER,                 -- type of plan to build
p_dfkey  IN NUMBER,                 -- datafile key
p_vbkey  IN NUMBER,                 -- vbkey associated with the plan
p_res    IN NUMBER  DEFAULT 0,      -- chunks to reserve
p_locked IN BOOLEAN DEFAULT FALSE,  -- key lock already held
p_must   IN BOOLEAN DEFAULT FALSE,  -- guaranteed plan
p_plock  IN BOOLEAN DEFAULT FALSE); -- purge lock already held
TDE
 
PLANNED_DBSPACE
Undocumented dbms_ba_pool.plannedDBSpace(
p_db_key IN NUMBER) -- database key
RETURN NUMBER;
TDE
 
PLANNED_SPACE
Undocumented dbms_ba_pool.plannedSpace(
p_slkey      IN NUMBER,
p_enable_dup IN NUMBER)
RETURN NUMBER;
TDE
 
PRE_PIECE_READ
Undocumented dbms_ba_pool.prep_piece_read(
p_inbpkey    IN  NUMBER,
p_loc        OUT VARCHAR2, -- Storage location
p_dbkey      OUT NUMBER,
p_db_id      OUT NUMBER,
p_dfkey      OUT NUMBER,   -- 0 if more than 1 df
p_vbkey      OUT NUMBER,
p_blksize    OUT NUMBER,
p_original   OUT NUMBER,   -- 1 == Virtual copy
p_read_bufs  OUT NUMBER,
p_read_size  OUT NUMBER,
p_read_waste OUT NUMBER);
TDE
 
PREP_READ
Undocumented dbms_ba_pool.prep_read(
p_type       IN  NUMBER, /* KBRSPLBLD_% */
p_bskey      IN  NUMBER, /* optional */
p_vbkey      IN  NUMBER,
p_dfkey      IN  NUMBER,
p_blksize    OUT NUMBER,
p_read_bufs  OUT NUMBER,
p_read_size  OUT NUMBER,
p_read_waste OUT NUMBER);
TDE
 
PROCESS_BACKUP_PIECE
Undocumented dbms_ba_pool.process_backup_piece(
p_dbkey    IN  NUMBER,           -- database key
p_bpkey    IN  NUMBER,           -- BackupPiece key
p_upd      IN  NUMBER DEFAULT 0, -- update op
p_complete OUT BOOLEAN);
TDE
 
PURGEDB
Purge Database dbms_ba_pool.purgeDB(
p_slkey  IN NUMBER,                 -- storage location
p_dbkey  IN NUMBER,                 -- database key
p_inline IN BOOLEAN DEFAULT FALSE); -- True when testing;
TDE
 
PURGEDF
Purge Data File dbms_ba_pool.purgeDF(
p_type  IN NUMBER,  -- type of purge to perform
p_dfkey IN NUMBER,  -- datafile key
p_vbkey IN NUMBER); -- oldest available vbkey
TDE
 
PURGE_DUPDF
Purge Duplicate Data File dbms_ba_pool.purgeDupDF(
p_dfkey    IN NUMBER,                -- datafile key
p_vbkey    IN NUMBER,                -- virtual backup key
p_bpkey    IN NUMBER,                -- (optional) bp_key for locking
p_newplans IN BOOLEAN DEFAULT TRUE); -- inhibit new plan
TDE
 
REPAIR_CHUNKS
Undocumented dbms_ba_pool.repairChunks(p_dbkey IN NUMBER);
TDE
 
REPAIR_DF
Undocumented dbms_ba_pool.repair_df(
p_vbkey    IN OUT NUMBER,   -- virtual backup ID
p_newvb    IN OUT NUMBER,   -- NULL, 1 begin_df, 0 repair
p_dbid     IN     NUMBER,   -- database ID
p_fno      IN     NUMBER,   -- datafile number
p_blocks   IN     NUMBER,   -- datafile size in blocks
p_relfno   IN     NUMBER,   -- backupset relative fileno
p_crescn   IN     NUMBER,   -- datafile creation scn
p_crestamp IN     NUMBER,   -- datafile creation time
p_rstscn   IN     NUMBER,   -- reset scn
p_rststamp IN     NUMBER,   -- reset stamp
p_startscn IN     NUMBER,   -- Incremental start scn
p_ckpscn   IN     NUMBER,   -- checkpoint scn
p_cmpvsn   IN     NUMBER,   -- backup version#
p_issft    IN     NUMBER,   -- single File Tablespace
p_firstblk IN     NUMBER,   -- first block
p_lastblk  IN     NUMBER,   -- last block
p_replev   IN     NUMBER);  -- iLevel if invalid incrscn
TDE
 
SAVE_KRBPH
Undocumented dbms_ba_pool.save_krbph(
p_dfkey     IN NUMBER,   -- krbph df_key
p_chunkno   IN NUMBER,   -- krbph chunk number
p_name      IN VARCHAR2, -- krbph chunk name
p_splittype IN NUMBER);  -- splitting for block pool,
TDE
 
SETDEBUG
Set Debug Mode dbms_ba_pool.setDebug(
p_level    IN NUMBER,
p_safemode IN NUMBER,
p_outtype  IN NUMBER DEFAULT sys.dbms_system.trace_file);
TDE
 
VALIDATEDB
Validate Database dbms_ba_pool.validateDB(p_dbkey IN NUMBER);
TDE

Related Topics
Built-in Functions
Built-in Packages
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved